gusdev-gusdev

[GUSDEV] install on local host

[Chris T. <cmt...@gm...>]

when I run build I get...

[InstallSchema] Nov 29, 2005 11:12:18 AM
org.gusdb.schema.InstallSchemaTaskinitialize
[InstallSchema] SEVERE: Unable to connect to database.  DSN=3D'
jdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521:WS17'
[InstallSchema] java.sql.SQLException: ORA-28009: connection to sys should
be as sysdba or sysoper
[InstallSchema]         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
[InstallSchema]         at oracle.jdbc.driver.T4CTTIoer.processError(
T4CTTIoer.java:304)
[InstallSchema]         at oracle.jdbc.driver.T4CTTIoer.processError(
T4CTTIoer.java:271)
.
.
.
.
[InstallSchema]         at org.apache.tools.ant.Main.startAnt(Main.java:187=
)
[InstallSchema]         at org.apache.tools.ant.launch.Launcher.run(
Launcher.java:246)
[InstallSchema]         at org.apache.tools.ant.launch.Launcher.main(
Launcher.java:67)

BUILD FAILED
/home/oracle/GUS/project_home/install/build.xml:28: The following error
occurred while executing this line:
/home/oracle/GUS/project_home/GUS/build.xml:92: Unable to connect to
database

Total time: 7 seconds


My gus.config looks like this:

 dbVendor=3DOracle
dbiDsn=3Ddbi:Oracle:ws17.itcomplab.missouri.edu
jdbcDsn=3Djdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521:WS17


# Login and Password to the RDBMS

databaseLogin=3Dsys
databasePassword=3Dadminws17

# Username, group, and project info from the relevant Core tables

userName=3Dsys
group=3Dsysdba
project=3DDatabase administration

tablespace=3DGUS

Any suggestions? The line:

[InstallSchema] java.sql.SQLException: ORA-28009: connection to sys should
be as sysdba or sysoper

seems to be the problem.  How should I change config?

Thanks,

chris


--
Christopher M. Topinka
NLM-BHIRT Predoctoral Fellow in Computer Science
113 Life Sciences Center
University of Missouri
Columbia, MO 65211
(573)-823-0616
cmt...@mi...

Re: [GUSDEV] install on local host

[Michael S. <msa...@pc...>]

Hi Chris,

Don't use the sys account.  Use another account that has been granted  
dba privileges.

--Mike

On Nov 29, 2005, at 12:24 PM, Chris Topinka wrote:

> when I run build I get...
>
> [InstallSchema] Nov 29, 2005 11:12:18 AM  
> org.gusdb.schema.InstallSchemaTask initialize
> [InstallSchema] SEVERE: Unable to connect to database.   
> DSN='jdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521:WS17'
> [InstallSchema] java.sql.SQLException: ORA-28009: connection to sys  
> should be as sysdba or sysoper
> [InstallSchema]         at  
> oracle.jdbc.driver.DatabaseError.throwSqlException 
> (DatabaseError.java:124)
> [InstallSchema]         at oracle.jdbc.driver.T4CTTIoer.processError 
> (T4CTTIoer.java:304)
> [InstallSchema]         at oracle.jdbc.driver.T4CTTIoer.processError 
> (T4CTTIoer.java:271)
> .
> .
> .
> .
> [InstallSchema]         at org.apache.tools.ant.Main.startAnt 
> (Main.java:187)
> [InstallSchema]         at org.apache.tools.ant.launch.Launcher.run 
> (Launcher.java:246)
> [InstallSchema]         at org.apache.tools.ant.launch.Launcher.main 
> (Launcher.java:67)
>
> BUILD FAILED
> /home/oracle/GUS/project_home/install/build.xml:28: The following  
> error occurred while executing this line:
> /home/oracle/GUS/project_home/GUS/build.xml:92: Unable to connect  
> to database
>
> Total time: 7 seconds
>
>
> My gus.config looks like this:
>
> dbVendor=Oracle
> dbiDsn=dbi:Oracle:ws17.itcomplab.missouri.edu
> jdbcDsn=jdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521 :WS17
>
>
> # Login and Password to the RDBMS
>
> databaseLogin=sys
> databasePassword=adminws17
>
> # Username, group, and project info from the relevant Core tables
>
> userName=sys
> group=sysdba
> project=Database administration
>
> tablespace=GUS
>
> Any suggestions? The line:
>
> [InstallSchema] java.sql.SQLException: ORA-28009: connection to sys  
> should be as sysdba or sysoper
>
> seems to be the problem.  How should I change config?
>
> Thanks,
>
> chris
>
>
> -- 
> Christopher M. Topinka
> NLM-BHIRT Predoctoral Fellow in Computer Science
> 113 Life Sciences Center
> University of Missouri
> Columbia, MO 65211
> (573)-823-0616
> cmt...@mi...

Re: [GUSDEV] install on local host

[Chris T. <cmt...@gm...>]

How should I reply?

Ok. now I get...

[InstallSchema] Nov 29, 2005 11:32:07 AM
org.gusdb.schema.InstallSchemaTaskexecute
[InstallSchema] INFO: Reading database from
/home/oracle/GUS/project_home/GUS/Schema/gus_schema.xml
[InstallSchema] Nov 29, 2005 11:32:07 AM
org.gusdb.dbadmin.reader.SchemaReader doRead
[InstallSchema] INFO: Reading Database
[InstallSchema] Nov 29, 2005 11:32:08 AM
org.gusdb.dbadmin.model.DatabaseresolveReferences
[InstallSchema] INFO: Resolving Database References
[InstallSchema] Nov 29, 2005 11:32:08 AM
org.gusdb.dbadmin.util.DatabaseValidator validate
[InstallSchema] INFO: Validating Database: 'null'
[InstallSchema] Nov 29, 2005 11:32:09 AM
org.gusdb.schema.InstallSchemaTasksetTablespace
[InstallSchema] INFO: Setting tablespaces to GUS
[InstallSchema] Nov 29, 2005 11:32:09 AM
org.gusdb.dbadmin.util.DatabaseValidator validate
[InstallSchema] INFO: Validating Database: 'null'
[InstallSchema] Nov 29, 2005 11:32:09 AM
org.gusdb.dbadmin.writer.SchemaWriter write
[InstallSchema] INFO: Writing Database
[InstallSchema] Nov 29, 2005 11:32:09 AM
org.gusdb.dbadmin.util.DatabaseValidator validate
[InstallSchema] INFO: Validating Database: 'null'
[InstallSchema] Nov 29, 2005 11:32:09 AM
org.gusdb.dbadmin.writer.SchemaWriter write
[InstallSchema] INFO: Writing Database

BUILD FAILED
/home/oracle/GUS/project_home/install/build.xml:28: The following error
occurred while executing this line:
/home/oracle/GUS/project_home/GUS/build.xml:92: java.io.IOException: Error
executing SQL: '
ALTER USER SResVer QUOTA UNLIMITED ON GUS' Error: ORA-00959: tablespace
'GUS' does not exist


what is this last line?

On 11/29/05, Michael Saffitz <msa...@pc...> wrote:
>
>
> Hi Chris,
>
> Don't use the sys account.  Use another account that has been granted
> dba privileges.
>
> --Mike
>
> On Nov 29, 2005, at 12:24 PM, Chris Topinka wrote:
>
> > when I run build I get...
> >
> > [InstallSchema] Nov 29, 2005 11:12:18 AM
> > org.gusdb.schema.InstallSchemaTask initialize
> > [InstallSchema] SEVERE: Unable to connect to database.
> > DSN=3D'jdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521:WS17'
> > [InstallSchema] java.sql.SQLException: ORA-28009: connection to sys
> > should be as sysdba or sysoper
> > [InstallSchema]         at
> > oracle.jdbc.driver.DatabaseError.throwSqlException
> > (DatabaseError.java:124)
> > [InstallSchema]         at oracle.jdbc.driver.T4CTTIoer.processError
> > (T4CTTIoer.java:304)
> > [InstallSchema]         at oracle.jdbc.driver.T4CTTIoer.processError
> > (T4CTTIoer.java:271)
> > .
> > .
> > .
> > .
> > [InstallSchema]         at org.apache.tools.ant.Main.startAnt
> > (Main.java:187)
> > [InstallSchema]         at org.apache.tools.ant.launch.Launcher.run
> > (Launcher.java:246)
> > [InstallSchema]         at org.apache.tools.ant.launch.Launcher.main
> > (Launcher.java:67)
> >
> > BUILD FAILED
> > /home/oracle/GUS/project_home/install/build.xml:28: The following
> > error occurred while executing this line:
> > /home/oracle/GUS/project_home/GUS/build.xml:92: Unable to connect
> > to database
> >
> > Total time: 7 seconds
> >
> >
> > My gus.config looks like this:
> >
> > dbVendor=3DOracle
> > dbiDsn=3Ddbi:Oracle:ws17.itcomplab.missouri.edu
> > jdbcDsn=3Djdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521 :WS17
> >
> >
> > # Login and Password to the RDBMS
> >
> > databaseLogin=3Dsys
> > databasePassword=3Dadminws17
> >
> > # Username, group, and project info from the relevant Core tables
> >
> > userName=3Dsys
> > group=3Dsysdba
> > project=3DDatabase administration
> >
> > tablespace=3DGUS
> >
> > Any suggestions? The line:
> >
> > [InstallSchema] java.sql.SQLException: ORA-28009: connection to sys
> > should be as sysdba or sysoper
> >
> > seems to be the problem.  How should I change config?
> >
> > Thanks,
> >
> > chris
> >
> >
> > --
> > Christopher M. Topinka
> > NLM-BHIRT Predoctoral Fellow in Computer Science
> > 113 Life Sciences Center
> > University of Missouri
> > Columbia, MO 65211
> > (573)-823-0616
> > cmt...@mi...
>
>


--
Christopher M. Topinka
NLM-BHIRT Predoctoral Fellow in Computer Science
113 Life Sciences Center
University of Missouri
Columbia, MO 65211
(573)-823-0616
cmt...@mi...

Re: [GUSDEV] install on local host

[Michael S. <msa...@pc...>]

Hi Chris,

Ok, you're almost there.  Either:

1) Create a GUS tablespace
2) Update your gus_schema.xml file (in $PROJECT_HOME/GusSchema/ 
Definition/config) to use tablespace="USERS" (or whatever) instead of  
GUS.

--Mike

On Nov 29, 2005, at 12:37 PM, Chris Topinka wrote:

> How should I reply?
>
> Ok. now I get...
>
> [InstallSchema] Nov 29, 2005 11:32:07 AM  
> org.gusdb.schema.InstallSchemaTask execute
> [InstallSchema] INFO: Reading database from /home/oracle/GUS/ 
> project_home/GUS/Schema/gus_schema.xml
> [InstallSchema] Nov 29, 2005 11:32:07 AM  
> org.gusdb.dbadmin.reader.SchemaReader doRead
> [InstallSchema] INFO: Reading Database
> [InstallSchema] Nov 29, 2005 11:32:08 AM  
> org.gusdb.dbadmin.model.Database resolveReferences
> [InstallSchema] INFO: Resolving Database References
> [InstallSchema] Nov 29, 2005 11:32:08 AM  
> org.gusdb.dbadmin.util.DatabaseValidator validate
> [InstallSchema] INFO: Validating Database: 'null'
> [InstallSchema] Nov 29, 2005 11:32:09 AM  
> org.gusdb.schema.InstallSchemaTask setTablespace
> [InstallSchema] INFO: Setting tablespaces to GUS
> [InstallSchema] Nov 29, 2005 11:32:09 AM  
> org.gusdb.dbadmin.util.DatabaseValidator validate
> [InstallSchema] INFO: Validating Database: 'null'
> [InstallSchema] Nov 29, 2005 11:32:09 AM  
> org.gusdb.dbadmin.writer.SchemaWriter write
> [InstallSchema] INFO: Writing Database
> [InstallSchema] Nov 29, 2005 11:32:09 AM  
> org.gusdb.dbadmin.util.DatabaseValidator validate
> [InstallSchema] INFO: Validating Database: 'null'
> [InstallSchema] Nov 29, 2005 11:32:09 AM  
> org.gusdb.dbadmin.writer.SchemaWriter write
> [InstallSchema] INFO: Writing Database
>
> BUILD FAILED
> /home/oracle/GUS/project_home/install/build.xml:28: The following  
> error occurred while executing this line:
> /home/oracle/GUS/project_home/GUS/build.xml:92:  
> java.io.IOException: Error executing SQL: '
> ALTER USER SResVer QUOTA UNLIMITED ON GUS' Error: ORA-00959:  
> tablespace 'GUS' does not exist
>
>
> what is this last line?
>
> On 11/29/05, Michael Saffitz <msa...@pc...> wrote:
> Hi Chris,
>
> Don't use the sys account.  Use another account that has been granted
> dba privileges.
>
> --Mike
>
> On Nov 29, 2005, at 12:24 PM, Chris Topinka wrote:
>
> > when I run build I get...
> >
> > [InstallSchema] Nov 29, 2005 11:12:18 AM
> > org.gusdb.schema.InstallSchemaTask initialize
> > [InstallSchema] SEVERE: Unable to connect to database.
> > DSN=' jdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521:WS17'
> > [InstallSchema] java.sql.SQLException: ORA-28009: connection to sys
> > should be as sysdba or sysoper
> > [InstallSchema]         at
> > oracle.jdbc.driver.DatabaseError.throwSqlException
> > (DatabaseError.java:124)
> > [InstallSchema]         at oracle.jdbc.driver.T4CTTIoer.processError
> > (T4CTTIoer.java:304)
> > [InstallSchema]         at oracle.jdbc.driver.T4CTTIoer.processError
> > ( T4CTTIoer.java:271)
> > .
> > .
> > .
> > .
> > [InstallSchema]         at org.apache.tools.ant.Main.startAnt
> > (Main.java:187)
> > [InstallSchema]         at org.apache.tools.ant.launch.Launcher.run
> > (Launcher.java:246)
> > [InstallSchema]         at org.apache.tools.ant.launch.Launcher.main
> > (Launcher.java:67)
> >
> > BUILD FAILED
> > /home/oracle/GUS/project_home/install/build.xml:28: The following
> > error occurred while executing this line:
> > /home/oracle/GUS/project_home/GUS/build.xml:92: Unable to connect
> > to database
> >
> > Total time: 7 seconds
> >
> >
> > My gus.config looks like this:
> >
> > dbVendor=Oracle
> > dbiDsn=dbi:Oracle:ws17.itcomplab.missouri.edu
> > jdbcDsn=jdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521 :WS17
> >
> >
> > # Login and Password to the RDBMS
> >
> > databaseLogin=sys
> > databasePassword=adminws17
> >
> > # Username, group, and project info from the relevant Core tables
> >
> > userName=sys
> > group=sysdba
> > project=Database administration
> >
> > tablespace=GUS
> >
> > Any suggestions? The line:
> >
> > [InstallSchema] java.sql.SQLException: ORA-28009: connection to sys
> > should be as sysdba or sysoper
> >
> > seems to be the problem.  How should I change config?
> >
> > Thanks,
> >
> > chris
> >
> >
> > --
> > Christopher M. Topinka
> > NLM-BHIRT Predoctoral Fellow in Computer Science
> > 113 Life Sciences Center
> > University of Missouri
> > Columbia, MO 65211
> > (573)-823-0616
> > cmt...@mi...
>
>
>
>
> -- 
> Christopher M. Topinka
> NLM-BHIRT Predoctoral Fellow in Computer Science
> 113 Life Sciences Center
> University of Missouri
> Columbia, MO 65211
> (573)-823-0616
> cmt...@mi...

Re: [GUSDEV] install on local host

[Chris T. <cmt...@gm...>]

after creating GUS tablespace I get...

BUILD FAILED
/home/oracle/GUS/project_home/install/build.xml:28: The following error
occurred while executing this line:
/home/oracle/GUS/project_home/GUS/build.xml:92: java.io.IOException: Error
executing SQL: '
CREATE USER TESSVer IDENTIFIED BY temppass PASSWORD EXPIRE ACCOUNT LOCK
QUOTA UNLIMITED ON USERS DEFAULT TABLESPACE USERS' Error: ORA-01920: user
name 'TESSVER' conflicts with another user or role name


Thanks.



On 11/29/05, Michael Saffitz <msa...@pc...> wrote:
>
>
> Hi Chris,
>
> Ok, you're almost there.  Either:
>
> 1) Create a GUS tablespace
> 2) Update your gus_schema.xml file (in $PROJECT_HOME/GusSchema/
> Definition/config) to use tablespace=3D"USERS" (or whatever) instead of
> GUS.
>
> --Mike
>
> On Nov 29, 2005, at 12:37 PM, Chris Topinka wrote:
>
> > How should I reply?
> >
> > Ok. now I get...
> >
> > [InstallSchema] Nov 29, 2005 11:32:07 AM
> > org.gusdb.schema.InstallSchemaTask execute
> > [InstallSchema] INFO: Reading database from /home/oracle/GUS/
> > project_home/GUS/Schema/gus_schema.xml
> > [InstallSchema] Nov 29, 2005 11:32:07 AM
> > org.gusdb.dbadmin.reader.SchemaReader doRead
> > [InstallSchema] INFO: Reading Database
> > [InstallSchema] Nov 29, 2005 11:32:08 AM
> > org.gusdb.dbadmin.model.Database resolveReferences
> > [InstallSchema] INFO: Resolving Database References
> > [InstallSchema] Nov 29, 2005 11:32:08 AM
> > org.gusdb.dbadmin.util.DatabaseValidator validate
> > [InstallSchema] INFO: Validating Database: 'null'
> > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > org.gusdb.schema.InstallSchemaTask setTablespace
> > [InstallSchema] INFO: Setting tablespaces to GUS
> > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > org.gusdb.dbadmin.util.DatabaseValidator validate
> > [InstallSchema] INFO: Validating Database: 'null'
> > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > org.gusdb.dbadmin.writer.SchemaWriter write
> > [InstallSchema] INFO: Writing Database
> > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > org.gusdb.dbadmin.util.DatabaseValidator validate
> > [InstallSchema] INFO: Validating Database: 'null'
> > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > org.gusdb.dbadmin.writer.SchemaWriter write
> > [InstallSchema] INFO: Writing Database
> >
> > BUILD FAILED
> > /home/oracle/GUS/project_home/install/build.xml:28: The following
> > error occurred while executing this line:
> > /home/oracle/GUS/project_home/GUS/build.xml:92:
> > java.io.IOException: Error executing SQL: '
> > ALTER USER SResVer QUOTA UNLIMITED ON GUS' Error: ORA-00959:
> > tablespace 'GUS' does not exist
> >
> >
> > what is this last line?
> >
> > On 11/29/05, Michael Saffitz <msa...@pc...> wrote:
> > Hi Chris,
> >
> > Don't use the sys account.  Use another account that has been granted
> > dba privileges.
> >
> > --Mike
> >
> > On Nov 29, 2005, at 12:24 PM, Chris Topinka wrote:
> >
> > > when I run build I get...
> > >
> > > [InstallSchema] Nov 29, 2005 11:12:18 AM
> > > org.gusdb.schema.InstallSchemaTask initialize
> > > [InstallSchema] SEVERE: Unable to connect to database.
> > > DSN=3D' jdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521:WS17'
> > > [InstallSchema] java.sql.SQLException: ORA-28009: connection to sys
> > > should be as sysdba or sysoper
> > > [InstallSchema]         at
> > > oracle.jdbc.driver.DatabaseError.throwSqlException
> > > (DatabaseError.java:124)
> > > [InstallSchema]         at oracle.jdbc.driver.T4CTTIoer.processError
> > > (T4CTTIoer.java:304)
> > > [InstallSchema]         at oracle.jdbc.driver.T4CTTIoer.processError
> > > ( T4CTTIoer.java:271)
> > > .
> > > .
> > > .
> > > .
> > > [InstallSchema]         at org.apache.tools.ant.Main.startAnt
> > > (Main.java:187)
> > > [InstallSchema]         at org.apache.tools.ant.launch.Launcher.run
> > > (Launcher.java:246)
> > > [InstallSchema]         at org.apache.tools.ant.launch.Launcher.main
> > > (Launcher.java:67)
> > >
> > > BUILD FAILED
> > > /home/oracle/GUS/project_home/install/build.xml:28: The following
> > > error occurred while executing this line:
> > > /home/oracle/GUS/project_home/GUS/build.xml:92: Unable to connect
> > > to database
> > >
> > > Total time: 7 seconds
> > >
> > >
> > > My gus.config looks like this:
> > >
> > > dbVendor=3DOracle
> > > dbiDsn=3Ddbi:Oracle:ws17.itcomplab.missouri.edu
> > > jdbcDsn=3Djdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521 :WS17
> > >
> > >
> > > # Login and Password to the RDBMS
> > >
> > > databaseLogin=3Dsys
> > > databasePassword=3Dadminws17
> > >
> > > # Username, group, and project info from the relevant Core tables
> > >
> > > userName=3Dsys
> > > group=3Dsysdba
> > > project=3DDatabase administration
> > >
> > > tablespace=3DGUS
> > >
> > > Any suggestions? The line:
> > >
> > > [InstallSchema] java.sql.SQLException: ORA-28009: connection to sys
> > > should be as sysdba or sysoper
> > >
> > > seems to be the problem.  How should I change config?
> > >
> > > Thanks,
> > >
> > > chris
> > >
> > >
> > > --
> > > Christopher M. Topinka
> > > NLM-BHIRT Predoctoral Fellow in Computer Science
> > > 113 Life Sciences Center
> > > University of Missouri
> > > Columbia, MO 65211
> > > (573)-823-0616
> > > cmt...@mi...
> >
> >
> >
> >
> > --
> > Christopher M. Topinka
> > NLM-BHIRT Predoctoral Fellow in Computer Science
> > 113 Life Sciences Center
> > University of Missouri
> > Columbia, MO 65211
> > (573)-823-0616
> > cmt...@mi...
>
>


--
Christopher M. Topinka
NLM-BHIRT Predoctoral Fellow in Computer Science
113 Life Sciences Center
University of Missouri
Columbia, MO 65211
(573)-823-0616
cmt...@mi...

Re: [GUSDEV] install on local host

[Michael S. <msa...@pc...>]

Sorry.  You'll have to back out the previous install before you try  
again.  You can use the dbaDeinstallGus utility to do this (but be  
careful and read the warnings-- it will delete data).

--Mike

On Nov 29, 2005, at 1:20 PM, Chris Topinka wrote:

> after creating GUS tablespace I get...
>
> BUILD FAILED
> /home/oracle/GUS/project_home/install/build.xml:28: The following  
> error occurred while executing this line:
> /home/oracle/GUS/project_home/GUS/build.xml:92:  
> java.io.IOException: Error executing SQL: '
> CREATE USER TESSVer IDENTIFIED BY temppass PASSWORD EXPIRE ACCOUNT  
> LOCK  QUOTA UNLIMITED ON USERS DEFAULT TABLESPACE USERS' Error:  
> ORA-01920: user name 'TESSVER' conflicts with another user or role  
> name
>
>
> Thanks.
>
>
>
> On 11/29/05, Michael Saffitz <msa...@pc...> wrote:
> Hi Chris,
>
> Ok, you're almost there.  Either:
>
> 1) Create a GUS tablespace
> 2) Update your gus_schema.xml file (in $PROJECT_HOME/GusSchema/
> Definition/config) to use tablespace="USERS" (or whatever) instead of
> GUS.
>
> --Mike
>
> On Nov 29, 2005, at 12:37 PM, Chris Topinka wrote:
>
> > How should I reply?
> >
> > Ok. now I get...
> >
> > [InstallSchema] Nov 29, 2005 11:32:07 AM
> > org.gusdb.schema.InstallSchemaTask execute
> > [InstallSchema] INFO: Reading database from /home/oracle/GUS/
> > project_home/GUS/Schema/gus_schema.xml
> > [InstallSchema] Nov 29, 2005 11:32:07 AM
> > org.gusdb.dbadmin.reader.SchemaReader doRead
> > [InstallSchema] INFO: Reading Database
> > [InstallSchema] Nov 29, 2005 11:32:08 AM
> > org.gusdb.dbadmin.model.Database resolveReferences
> > [InstallSchema] INFO: Resolving Database References
> > [InstallSchema] Nov 29, 2005 11:32:08 AM
> > org.gusdb.dbadmin.util.DatabaseValidator validate
> > [InstallSchema] INFO: Validating Database: 'null'
> > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > org.gusdb.schema.InstallSchemaTask setTablespace
> > [InstallSchema] INFO: Setting tablespaces to GUS
> > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > org.gusdb.dbadmin.util.DatabaseValidator validate
> > [InstallSchema] INFO: Validating Database: 'null'
> > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > org.gusdb.dbadmin.writer.SchemaWriter write
> > [InstallSchema] INFO: Writing Database
> > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > org.gusdb.dbadmin.util.DatabaseValidator validate
> > [InstallSchema] INFO: Validating Database: 'null'
> > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > org.gusdb.dbadmin.writer.SchemaWriter write
> > [InstallSchema] INFO: Writing Database
> >
> > BUILD FAILED
> > /home/oracle/GUS/project_home/install/build.xml:28: The following
> > error occurred while executing this line:
> > /home/oracle/GUS/project_home/GUS/build.xml:92:
> > java.io.IOException : Error executing SQL: '
> > ALTER USER SResVer QUOTA UNLIMITED ON GUS' Error: ORA-00959:
> > tablespace 'GUS' does not exist
> >
> >
> > what is this last line?
> >
> > On 11/29/05, Michael Saffitz < msa...@pc...> wrote:
> > Hi Chris,
> >
> > Don't use the sys account.  Use another account that has been  
> granted
> > dba privileges.
> >
> > --Mike
> >
> > On Nov 29, 2005, at 12:24 PM, Chris Topinka wrote:
> >
> > > when I run build I get...
> > >
> > > [InstallSchema] Nov 29, 2005 11:12:18 AM
> > > org.gusdb.schema.InstallSchemaTask initialize
> > > [InstallSchema] SEVERE: Unable to connect to database.
> > > DSN=' jdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521 :WS17'
> > > [InstallSchema] java.sql.SQLException: ORA-28009: connection to  
> sys
> > > should be as sysdba or sysoper
> > > [InstallSchema]         at
> > > oracle.jdbc.driver.DatabaseError.throwSqlException
> > > (DatabaseError.java:124)
> > > [InstallSchema]         at  
> oracle.jdbc.driver.T4CTTIoer.processError
> > > (T4CTTIoer.java:304)
> > > [InstallSchema]         at  
> oracle.jdbc.driver.T4CTTIoer.processError
> > > ( T4CTTIoer.java:271)
> > > .
> > > .
> > > .
> > > .
> > > [InstallSchema]         at org.apache.tools.ant.Main.startAnt
> > > (Main.java:187)
> > > [InstallSchema]         at  
> org.apache.tools.ant.launch.Launcher.run
> > > (Launcher.java:246)
> > > [InstallSchema]         at  
> org.apache.tools.ant.launch.Launcher.main
> > > (Launcher.java:67)
> > >
> > > BUILD FAILED
> > > /home/oracle/GUS/project_home/install/build.xml:28: The following
> > > error occurred while executing this line:
> > > /home/oracle/GUS/project_home/GUS/build.xml:92: Unable to connect
> > > to database
> > >
> > > Total time: 7 seconds
> > >
> > >
> > > My gus.config looks like this:
> > >
> > > dbVendor=Oracle
> > > dbiDsn=dbi:Oracle: ws17.itcomplab.missouri.edu
> > > jdbcDsn=jdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521 :WS17
> > >
> > >
> > > # Login and Password to the RDBMS
> > >
> > > databaseLogin=sys
> > > databasePassword=adminws17
> > >
> > > # Username, group, and project info from the relevant Core tables
> > >
> > > userName=sys
> > > group=sysdba
> > > project=Database administration
> > >
> > > tablespace=GUS
> > >
> > > Any suggestions? The line:
> > >
> > > [InstallSchema] java.sql.SQLException: ORA-28009: connection to  
> sys
> > > should be as sysdba or sysoper
> > >
> > > seems to be the problem.  How should I change config?
> > >
> > > Thanks,
> > >
> > > chris
> > >
> > >
> > > --
> > > Christopher M. Topinka
> > > NLM-BHIRT Predoctoral Fellow in Computer Science
> > > 113 Life Sciences Center
> > > University of Missouri
> > > Columbia, MO 65211
> > > (573)-823-0616
> > > cmt...@mi...
> >
> >
> >
> >
> > --
> > Christopher M. Topinka
> > NLM-BHIRT Predoctoral Fellow in Computer Science
> > 113 Life Sciences Center
> > University of Missouri
> > Columbia, MO 65211
> > (573)-823-0616
> > cmt...@mi...
>
>
>
>
> -- 
> Christopher M. Topinka
> NLM-BHIRT Predoctoral Fellow in Computer Science
> 113 Life Sciences Center
> University of Missouri
> Columbia, MO 65211
> (573)-823-0616
> cmt...@mi...

Re: [GUSDEV] install on local host

[Chris T. <cmt...@gm...>]

where can I find the Deinstall script?  Is there a way to just manually
remove users/groups/tables from Oracle that conflict?

thanks,

chris

On 11/29/05, Michael Saffitz <msa...@pc...> wrote:
>
>
> Sorry.  You'll have to back out the previous install before you try
> again.  You can use the dbaDeinstallGus utility to do this (but be
> careful and read the warnings-- it will delete data).
>
> --Mike
>
> On Nov 29, 2005, at 1:20 PM, Chris Topinka wrote:
>
> > after creating GUS tablespace I get...
> >
> > BUILD FAILED
> > /home/oracle/GUS/project_home/install/build.xml:28: The following
> > error occurred while executing this line:
> > /home/oracle/GUS/project_home/GUS/build.xml:92:
> > java.io.IOException: Error executing SQL: '
> > CREATE USER TESSVer IDENTIFIED BY temppass PASSWORD EXPIRE ACCOUNT
> > LOCK  QUOTA UNLIMITED ON USERS DEFAULT TABLESPACE USERS' Error:
> > ORA-01920: user name 'TESSVER' conflicts with another user or role
> > name
> >
> >
> > Thanks.
> >
> >
> >
> > On 11/29/05, Michael Saffitz <msa...@pc...> wrote:
> > Hi Chris,
> >
> > Ok, you're almost there.  Either:
> >
> > 1) Create a GUS tablespace
> > 2) Update your gus_schema.xml file (in $PROJECT_HOME/GusSchema/
> > Definition/config) to use tablespace=3D"USERS" (or whatever) instead of
> > GUS.
> >
> > --Mike
> >
> > On Nov 29, 2005, at 12:37 PM, Chris Topinka wrote:
> >
> > > How should I reply?
> > >
> > > Ok. now I get...
> > >
> > > [InstallSchema] Nov 29, 2005 11:32:07 AM
> > > org.gusdb.schema.InstallSchemaTask execute
> > > [InstallSchema] INFO: Reading database from /home/oracle/GUS/
> > > project_home/GUS/Schema/gus_schema.xml
> > > [InstallSchema] Nov 29, 2005 11:32:07 AM
> > > org.gusdb.dbadmin.reader.SchemaReader doRead
> > > [InstallSchema] INFO: Reading Database
> > > [InstallSchema] Nov 29, 2005 11:32:08 AM
> > > org.gusdb.dbadmin.model.Database resolveReferences
> > > [InstallSchema] INFO: Resolving Database References
> > > [InstallSchema] Nov 29, 2005 11:32:08 AM
> > > org.gusdb.dbadmin.util.DatabaseValidator validate
> > > [InstallSchema] INFO: Validating Database: 'null'
> > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > org.gusdb.schema.InstallSchemaTask setTablespace
> > > [InstallSchema] INFO: Setting tablespaces to GUS
> > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > org.gusdb.dbadmin.util.DatabaseValidator validate
> > > [InstallSchema] INFO: Validating Database: 'null'
> > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > org.gusdb.dbadmin.writer.SchemaWriter write
> > > [InstallSchema] INFO: Writing Database
> > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > org.gusdb.dbadmin.util.DatabaseValidator validate
> > > [InstallSchema] INFO: Validating Database: 'null'
> > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > org.gusdb.dbadmin.writer.SchemaWriter write
> > > [InstallSchema] INFO: Writing Database
> > >
> > > BUILD FAILED
> > > /home/oracle/GUS/project_home/install/build.xml:28: The following
> > > error occurred while executing this line:
> > > /home/oracle/GUS/project_home/GUS/build.xml:92:
> > > java.io.IOException : Error executing SQL: '
> > > ALTER USER SResVer QUOTA UNLIMITED ON GUS' Error: ORA-00959:
> > > tablespace 'GUS' does not exist
> > >
> > >
> > > what is this last line?
> > >
> > > On 11/29/05, Michael Saffitz < msa...@pc...> wrote:
> > > Hi Chris,
> > >
> > > Don't use the sys account.  Use another account that has been
> > granted
> > > dba privileges.
> > >
> > > --Mike
> > >
> > > On Nov 29, 2005, at 12:24 PM, Chris Topinka wrote:
> > >
> > > > when I run build I get...
> > > >
> > > > [InstallSchema] Nov 29, 2005 11:12:18 AM
> > > > org.gusdb.schema.InstallSchemaTask initialize
> > > > [InstallSchema] SEVERE: Unable to connect to database.
> > > > DSN=3D' jdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521 :WS17'
> > > > [InstallSchema] java.sql.SQLException: ORA-28009: connection to
> > sys
> > > > should be as sysdba or sysoper
> > > > [InstallSchema]         at
> > > > oracle.jdbc.driver.DatabaseError.throwSqlException
> > > > (DatabaseError.java:124)
> > > > [InstallSchema]         at
> > oracle.jdbc.driver.T4CTTIoer.processError
> > > > (T4CTTIoer.java:304)
> > > > [InstallSchema]         at
> > oracle.jdbc.driver.T4CTTIoer.processError
> > > > ( T4CTTIoer.java:271)
> > > > .
> > > > .
> > > > .
> > > > .
> > > > [InstallSchema]         at org.apache.tools.ant.Main.startAnt
> > > > (Main.java:187)
> > > > [InstallSchema]         at
> > org.apache.tools.ant.launch.Launcher.run
> > > > (Launcher.java:246)
> > > > [InstallSchema]         at
> > org.apache.tools.ant.launch.Launcher.main
> > > > (Launcher.java:67)
> > > >
> > > > BUILD FAILED
> > > > /home/oracle/GUS/project_home/install/build.xml:28: The following
> > > > error occurred while executing this line:
> > > > /home/oracle/GUS/project_home/GUS/build.xml:92: Unable to connect
> > > > to database
> > > >
> > > > Total time: 7 seconds
> > > >
> > > >
> > > > My gus.config looks like this:
> > > >
> > > > dbVendor=3DOracle
> > > > dbiDsn=3Ddbi:Oracle: ws17.itcomplab.missouri.edu
> > > > jdbcDsn=3Djdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521 :WS17
> > > >
> > > >
> > > > # Login and Password to the RDBMS
> > > >
> > > > databaseLogin=3Dsys
> > > > databasePassword=3Dadminws17
> > > >
> > > > # Username, group, and project info from the relevant Core tables
> > > >
> > > > userName=3Dsys
> > > > group=3Dsysdba
> > > > project=3DDatabase administration
> > > >
> > > > tablespace=3DGUS
> > > >
> > > > Any suggestions? The line:
> > > >
> > > > [InstallSchema] java.sql.SQLException: ORA-28009: connection to
> > sys
> > > > should be as sysdba or sysoper
> > > >
> > > > seems to be the problem.  How should I change config?
> > > >
> > > > Thanks,
> > > >
> > > > chris
> > > >
> > > >
> > > > --
> > > > Christopher M. Topinka
> > > > NLM-BHIRT Predoctoral Fellow in Computer Science
> > > > 113 Life Sciences Center
> > > > University of Missouri
> > > > Columbia, MO 65211
> > > > (573)-823-0616
> > > > cmt...@mi...
> > >
> > >
> > >
> > >
> > > --
> > > Christopher M. Topinka
> > > NLM-BHIRT Predoctoral Fellow in Computer Science
> > > 113 Life Sciences Center
> > > University of Missouri
> > > Columbia, MO 65211
> > > (573)-823-0616
> > > cmt...@mi...
> >
> >
> >
> >
> > --
> > Christopher M. Topinka
> > NLM-BHIRT Predoctoral Fellow in Computer Science
> > 113 Life Sciences Center
> > University of Missouri
> > Columbia, MO 65211
> > (573)-823-0616
> > cmt...@mi...
>
>


--
Christopher M. Topinka
NLM-BHIRT Predoctoral Fellow in Computer Science
MU ACM Student Chapter 2005-2006 Program Chair
University of Missouri
Columbia, MO 65211
(573)-823-0616
cmt...@mi...

Re: [GUSDEV] install on local host

[Michael S. <msa...@pc...>]

Hi Chris:

dbaDeinstallGus is in the trunk of the repository, it's installed  
with GUS in $GUS_HOME/bin

You can always just do a drop user dots, drop user ... and so on, but  
the utility is much faster and makes sure you didn't miss anything.

--Mike

On Dec 1, 2005, at 1:32 PM, Chris Topinka wrote:

> where can I find the Deinstall script?  Is there a way to just  
> manually remove users/groups/tables from Oracle that conflict?
>
> thanks,
>
> chris
>
> On 11/29/05, Michael Saffitz <msa...@pc...> wrote:
> Sorry.  You'll have to back out the previous install before you try
> again.  You can use the dbaDeinstallGus utility to do this (but be
> careful and read the warnings-- it will delete data).
>
> --Mike
>
> On Nov 29, 2005, at 1:20 PM, Chris Topinka wrote:
>
> > after creating GUS tablespace I get...
> >
> > BUILD FAILED
> > /home/oracle/GUS/project_home/install/build.xml:28: The following
> > error occurred while executing this line:
> > /home/oracle/GUS/project_home/GUS/build.xml:92:
> > java.io.IOException: Error executing SQL: '
> > CREATE USER TESSVer IDENTIFIED BY temppass PASSWORD EXPIRE ACCOUNT
> > LOCK  QUOTA UNLIMITED ON USERS DEFAULT TABLESPACE USERS' Error:
> > ORA-01920: user name 'TESSVER' conflicts with another user or role
> > name
> >
> >
> > Thanks.
> >
> >
> >
> > On 11/29/05, Michael Saffitz <msa...@pc...> wrote:
> > Hi Chris,
> >
> > Ok, you're almost there.  Either:
> >
> > 1) Create a GUS tablespace
> > 2) Update your gus_schema.xml file (in $PROJECT_HOME/GusSchema/
> > Definition/config) to use tablespace="USERS" (or whatever)  
> instead of
> > GUS.
> >
> > --Mike
> >
> > On Nov 29, 2005, at 12:37 PM, Chris Topinka wrote:
> >
> > > How should I reply?
> > >
> > > Ok. now I get...
> > >
> > > [InstallSchema] Nov 29, 2005 11:32:07 AM
> > > org.gusdb.schema.InstallSchemaTask execute
> > > [InstallSchema] INFO: Reading database from /home/oracle/GUS/
> > > project_home/GUS/Schema/gus_schema.xml
> > > [InstallSchema] Nov 29, 2005 11:32:07 AM
> > > org.gusdb.dbadmin.reader.SchemaReader doRead
> > > [InstallSchema] INFO: Reading Database
> > > [InstallSchema] Nov 29, 2005 11:32:08 AM
> > > org.gusdb.dbadmin.model.Database resolveReferences
> > > [InstallSchema] INFO: Resolving Database References
> > > [InstallSchema] Nov 29, 2005 11:32:08 AM
> > > org.gusdb.dbadmin.util.DatabaseValidator validate
> > > [InstallSchema] INFO: Validating Database: 'null'
> > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > org.gusdb.schema.InstallSchemaTask setTablespace
> > > [InstallSchema] INFO: Setting tablespaces to GUS
> > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > org.gusdb.dbadmin.util.DatabaseValidator validate
> > > [InstallSchema] INFO: Validating Database: 'null'
> > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > org.gusdb.dbadmin.writer.SchemaWriter write
> > > [InstallSchema] INFO: Writing Database
> > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > org.gusdb.dbadmin.util.DatabaseValidator validate
> > > [InstallSchema] INFO: Validating Database: 'null'
> > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > org.gusdb.dbadmin.writer.SchemaWriter write
> > > [InstallSchema] INFO: Writing Database
> > >
> > > BUILD FAILED
> > > /home/oracle/GUS/project_home/install/build.xml:28: The following
> > > error occurred while executing this line:
> > > /home/oracle/GUS/project_home/GUS/build.xml:92:
> > > java.io.IOException : Error executing SQL: '
> > > ALTER USER SResVer QUOTA UNLIMITED ON GUS' Error: ORA-00959:
> > > tablespace 'GUS' does not exist
> > >
> > >
> > > what is this last line?
> > >
> > > On 11/29/05, Michael Saffitz < msa...@pc... > wrote:
> > > Hi Chris,
> > >
> > > Don't use the sys account.  Use another account that has been
> > granted
> > > dba privileges.
> > >
> > > --Mike
> > >
> > > On Nov 29, 2005, at 12:24 PM, Chris Topinka wrote:
> > >
> > > > when I run build I get...
> > > >
> > > > [InstallSchema] Nov 29, 2005 11:12:18 AM
> > > > org.gusdb.schema.InstallSchemaTask initialize
> > > > [InstallSchema] SEVERE: Unable to connect to database.
> > > > DSN=' jdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521 :WS17'
> > > > [InstallSchema] java.sql.SQLException: ORA-28009: connection to
> > sys
> > > > should be as sysdba or sysoper
> > > > [InstallSchema]         at
> > > > oracle.jdbc.driver.DatabaseError.throwSqlException
> > > > (DatabaseError.java:124)
> > > > [InstallSchema]         at
> > oracle.jdbc.driver.T4CTTIoer.processError
> > > > (T4CTTIoer.java:304)
> > > > [InstallSchema]         at
> > oracle.jdbc.driver.T4CTTIoer.processError
> > > > ( T4CTTIoer.java:271)
> > > > .
> > > > .
> > > > .
> > > > .
> > > > [InstallSchema]         at org.apache.tools.ant.Main.startAnt
> > > > (Main.java:187)
> > > > [InstallSchema]         at
> > org.apache.tools.ant.launch.Launcher.run
> > > > (Launcher.java:246)
> > > > [InstallSchema]         at
> > org.apache.tools.ant.launch.Launcher.main
> > > > (Launcher.java:67)
> > > >
> > > > BUILD FAILED
> > > > /home/oracle/GUS/project_home/install/build.xml:28: The  
> following
> > > > error occurred while executing this line:
> > > > /home/oracle/GUS/project_home/GUS/build.xml:92: Unable to  
> connect
> > > > to database
> > > >
> > > > Total time: 7 seconds
> > > >
> > > >
> > > > My gus.config looks like this:
> > > >
> > > > dbVendor=Oracle
> > > > dbiDsn=dbi:Oracle: ws17.itcomplab.missouri.edu
> > > > jdbcDsn= jdbc:oracle:thin:@ws17.itcomplab.missouri.edu: 
> 1521 :WS17
> > > >
> > > >
> > > > # Login and Password to the RDBMS
> > > >
> > > > databaseLogin=sys
> > > > databasePassword=adminws17
> > > >
> > > > # Username, group, and project info from the relevant Core  
> tables
> > > >
> > > > userName=sys
> > > > group=sysdba
> > > > project=Database administration
> > > >
> > > > tablespace=GUS
> > > >
> > > > Any suggestions? The line:
> > > >
> > > > [InstallSchema] java.sql.SQLException: ORA-28009: connection to
> > sys
> > > > should be as sysdba or sysoper
> > > >
> > > > seems to be the problem.  How should I change config?
> > > >
> > > > Thanks,
> > > >
> > > > chris
> > > >
> > > >
> > > > --
> > > > Christopher M. Topinka
> > > > NLM-BHIRT Predoctoral Fellow in Computer Science
> > > > 113 Life Sciences Center
> > > > University of Missouri
> > > > Columbia, MO 65211
> > > > (573)-823-0616
> > > > cmt...@mi...
> > >
> > >
> > >
> > >
> > > --
> > > Christopher M. Topinka
> > > NLM-BHIRT Predoctoral Fellow in Computer Science
> > > 113 Life Sciences Center
> > > University of Missouri
> > > Columbia, MO 65211
> > > (573)-823-0616
> > > cmt...@mi...
> >
> >
> >
> >
> > --
> > Christopher M. Topinka
> > NLM-BHIRT Predoctoral Fellow in Computer Science
> > 113 Life Sciences Center
> > University of Missouri
> > Columbia, MO 65211
> > (573)-823-0616
> > cmt...@mi...
>
>
>
>
> -- 
> Christopher M. Topinka
> NLM-BHIRT Predoctoral Fellow in Computer Science
> MU ACM Student Chapter 2005-2006 Program Chair
> University of Missouri
> Columbia, MO 65211
> (573)-823-0616
> cmt...@mi...

Re: [GUSDEV] install on local host

[Chris T. <cmt...@gm...>]

Apparently I didn't get it in the distribution I downloaded from the GUS
site.
This is my bin dir:

[oracle@ws17 bin]$ pwd
/home/oracle/GUS/gus_home/bin
[oracle@ws17 bin]$ ls
benchmarkQueries.pl         getSubTaxa           rebuildIndexes.pl
checkForeignKeysIndexed.pl  gobuild              runBlastSim4.pl
checkTableInfo.pl           grantPermissions.pl  runGoSimilarities
dbaDumpSchema               gusDeleteRows        showConstraints.pl
dumpTable.pl                gusExtractSequences  singleCoverage.pl
extractHits.pl              hierAnatomyDemo.pl   updateDbESTMirror.pl
genbankFileFilter           hifytojava           versionEntries.pl
generateAAFilterFile        loadDbESTMirror.pl


Is it one of these?

Is there a way I can get it without downloading the whole thing?

Chris

On 12/1/05, Michael Saffitz <msa...@pc...> wrote:
>
>
> Hi Chris:
>
> dbaDeinstallGus is in the trunk of the repository, it's installed
> with GUS in $GUS_HOME/bin
>
> You can always just do a drop user dots, drop user ... and so on, but
> the utility is much faster and makes sure you didn't miss anything.
>
> --Mike
>
> On Dec 1, 2005, at 1:32 PM, Chris Topinka wrote:
>
> > where can I find the Deinstall script?  Is there a way to just
> > manually remove users/groups/tables from Oracle that conflict?
> >
> > thanks,
> >
> > chris
> >
> > On 11/29/05, Michael Saffitz <msa...@pc...> wrote:
> > Sorry.  You'll have to back out the previous install before you try
> > again.  You can use the dbaDeinstallGus utility to do this (but be
> > careful and read the warnings-- it will delete data).
> >
> > --Mike
> >
> > On Nov 29, 2005, at 1:20 PM, Chris Topinka wrote:
> >
> > > after creating GUS tablespace I get...
> > >
> > > BUILD FAILED
> > > /home/oracle/GUS/project_home/install/build.xml:28: The following
> > > error occurred while executing this line:
> > > /home/oracle/GUS/project_home/GUS/build.xml:92:
> > > java.io.IOException: Error executing SQL: '
> > > CREATE USER TESSVer IDENTIFIED BY temppass PASSWORD EXPIRE ACCOUNT
> > > LOCK  QUOTA UNLIMITED ON USERS DEFAULT TABLESPACE USERS' Error:
> > > ORA-01920: user name 'TESSVER' conflicts with another user or role
> > > name
> > >
> > >
> > > Thanks.
> > >
> > >
> > >
> > > On 11/29/05, Michael Saffitz <msa...@pc...> wrote:
> > > Hi Chris,
> > >
> > > Ok, you're almost there.  Either:
> > >
> > > 1) Create a GUS tablespace
> > > 2) Update your gus_schema.xml file (in $PROJECT_HOME/GusSchema/
> > > Definition/config) to use tablespace=3D"USERS" (or whatever)
> > instead of
> > > GUS.
> > >
> > > --Mike
> > >
> > > On Nov 29, 2005, at 12:37 PM, Chris Topinka wrote:
> > >
> > > > How should I reply?
> > > >
> > > > Ok. now I get...
> > > >
> > > > [InstallSchema] Nov 29, 2005 11:32:07 AM
> > > > org.gusdb.schema.InstallSchemaTask execute
> > > > [InstallSchema] INFO: Reading database from /home/oracle/GUS/
> > > > project_home/GUS/Schema/gus_schema.xml
> > > > [InstallSchema] Nov 29, 2005 11:32:07 AM
> > > > org.gusdb.dbadmin.reader.SchemaReader doRead
> > > > [InstallSchema] INFO: Reading Database
> > > > [InstallSchema] Nov 29, 2005 11:32:08 AM
> > > > org.gusdb.dbadmin.model.Database resolveReferences
> > > > [InstallSchema] INFO: Resolving Database References
> > > > [InstallSchema] Nov 29, 2005 11:32:08 AM
> > > > org.gusdb.dbadmin.util.DatabaseValidator validate
> > > > [InstallSchema] INFO: Validating Database: 'null'
> > > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > > org.gusdb.schema.InstallSchemaTask setTablespace
> > > > [InstallSchema] INFO: Setting tablespaces to GUS
> > > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > > org.gusdb.dbadmin.util.DatabaseValidator validate
> > > > [InstallSchema] INFO: Validating Database: 'null'
> > > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > > org.gusdb.dbadmin.writer.SchemaWriter write
> > > > [InstallSchema] INFO: Writing Database
> > > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > > org.gusdb.dbadmin.util.DatabaseValidator validate
> > > > [InstallSchema] INFO: Validating Database: 'null'
> > > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > > org.gusdb.dbadmin.writer.SchemaWriter write
> > > > [InstallSchema] INFO: Writing Database
> > > >
> > > > BUILD FAILED
> > > > /home/oracle/GUS/project_home/install/build.xml:28: The following
> > > > error occurred while executing this line:
> > > > /home/oracle/GUS/project_home/GUS/build.xml:92:
> > > > java.io.IOException : Error executing SQL: '
> > > > ALTER USER SResVer QUOTA UNLIMITED ON GUS' Error: ORA-00959:
> > > > tablespace 'GUS' does not exist
> > > >
> > > >
> > > > what is this last line?
> > > >
> > > > On 11/29/05, Michael Saffitz < msa...@pc... > wrote:
> > > > Hi Chris,
> > > >
> > > > Don't use the sys account.  Use another account that has been
> > > granted
> > > > dba privileges.
> > > >
> > > > --Mike
> > > >
> > > > On Nov 29, 2005, at 12:24 PM, Chris Topinka wrote:
> > > >
> > > > > when I run build I get...
> > > > >
> > > > > [InstallSchema] Nov 29, 2005 11:12:18 AM
> > > > > org.gusdb.schema.InstallSchemaTask initialize
> > > > > [InstallSchema] SEVERE: Unable to connect to database.
> > > > > DSN=3D' jdbc:oracle:thin:@ws17.itcomplab.missouri.edu:1521 :WS17'
> > > > > [InstallSchema] java.sql.SQLException: ORA-28009: connection to
> > > sys
> > > > > should be as sysdba or sysoper
> > > > > [InstallSchema]         at
> > > > > oracle.jdbc.driver.DatabaseError.throwSqlException
> > > > > (DatabaseError.java:124)
> > > > > [InstallSchema]         at
> > > oracle.jdbc.driver.T4CTTIoer.processError
> > > > > (T4CTTIoer.java:304)
> > > > > [InstallSchema]         at
> > > oracle.jdbc.driver.T4CTTIoer.processError
> > > > > ( T4CTTIoer.java:271)
> > > > > .
> > > > > .
> > > > > .
> > > > > .
> > > > > [InstallSchema]         at org.apache.tools.ant.Main.startAnt
> > > > > (Main.java:187)
> > > > > [InstallSchema]         at
> > > org.apache.tools.ant.launch.Launcher.run
> > > > > (Launcher.java:246)
> > > > > [InstallSchema]         at
> > > org.apache.tools.ant.launch.Launcher.main
> > > > > (Launcher.java:67)
> > > > >
> > > > > BUILD FAILED
> > > > > /home/oracle/GUS/project_home/install/build.xml:28: The
> > following
> > > > > error occurred while executing this line:
> > > > > /home/oracle/GUS/project_home/GUS/build.xml:92: Unable to
> > connect
> > > > > to database
> > > > >
> > > > > Total time: 7 seconds
> > > > >
> > > > >
> > > > > My gus.config looks like this:
> > > > >
> > > > > dbVendor=3DOracle
> > > > > dbiDsn=3Ddbi:Oracle: ws17.itcomplab.missouri.edu
> > > > > jdbcDsn=3D jdbc:oracle:thin:@ws17.itcomplab.missouri.edu:
> > 1521 :WS17
> > > > >
> > > > >
> > > > > # Login and Password to the RDBMS
> > > > >
> > > > > databaseLogin=3Dsys
> > > > > databasePassword=3Dadminws17
> > > > >
> > > > > # Username, group, and project info from the relevant Core
> > tables
> > > > >
> > > > > userName=3Dsys
> > > > > group=3Dsysdba
> > > > > project=3DDatabase administration
> > > > >
> > > > > tablespace=3DGUS
> > > > >
> > > > > Any suggestions? The line:
> > > > >
> > > > > [InstallSchema] java.sql.SQLException: ORA-28009: connection to
> > > sys
> > > > > should be as sysdba or sysoper
> > > > >
> > > > > seems to be the problem.  How should I change config?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > chris
> > > > >
> > > > >
> > > > > --
> > > > > Christopher M. Topinka
> > > > > NLM-BHIRT Predoctoral Fellow in Computer Science
> > > > > 113 Life Sciences Center
> > > > > University of Missouri
> > > > > Columbia, MO 65211
> > > > > (573)-823-0616
> > > > > cmt...@mi...
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Christopher M. Topinka
> > > > NLM-BHIRT Predoctoral Fellow in Computer Science
> > > > 113 Life Sciences Center
> > > > University of Missouri
> > > > Columbia, MO 65211
> > > > (573)-823-0616
> > > > cmt...@mi...
> > >
> > >
> > >
> > >
> > > --
> > > Christopher M. Topinka
> > > NLM-BHIRT Predoctoral Fellow in Computer Science
> > > 113 Life Sciences Center
> > > University of Missouri
> > > Columbia, MO 65211
> > > (573)-823-0616
> > > cmt...@mi...
> >
> >
> >
> >
> > --
> > Christopher M. Topinka
> > NLM-BHIRT Predoctoral Fellow in Computer Science
> > MU ACM Student Chapter 2005-2006 Program Chair
> > University of Missouri
> > Columbia, MO 65211
> > (573)-823-0616
> > cmt...@mi...
>
>


--
Christopher M. Topinka
NLM-BHIRT Predoctoral Fellow in Computer Science
MU ACM Student Chapter 2005-2006 Program Chair
University of Missouri
Columbia, MO 65211
(573)-823-0616
cmt...@mi...

Re: [GUSDEV] install on local host

[Michael S. <msa...@pc...>]

No guarantees, but you can grab it here:

https://www.cbil.upenn.edu/svn/gus/GusAppFramework/trunk/DBAdmin/bin/ 
dbaDeinstallGus

I believe that it does have dependencies on other things that have  
been updated in GUS since the downloadable release.

At least you can look at the code and see what it's doing-- pretty  
trivial.

--Mike


On Dec 1, 2005, at 2:12 PM, Chris Topinka wrote:

> Apparently I didn't get it in the distribution I downloaded from  
> the GUS site.
> This is my bin dir:
>
> [oracle@ws17 bin]$ pwd
> /home/oracle/GUS/gus_home/bin
> [oracle@ws17 bin]$ ls
> benchmarkQueries.pl         getSubTaxa           rebuildIndexes.pl
> checkForeignKeysIndexed.pl  gobuild              runBlastSim4.pl
> checkTableInfo.pl           grantPermissions.pl  runGoSimilarities
> dbaDumpSchema               gusDeleteRows        showConstraints.pl
> dumpTable.pl                gusExtractSequences  singleCoverage.pl
> extractHits.pl              hierAnatomyDemo.pl   updateDbESTMirror.pl
> genbankFileFilter           hifytojava           versionEntries.pl
> generateAAFilterFile        loadDbESTMirror.pl
>
>
> Is it one of these?
>
> Is there a way I can get it without downloading the whole thing?
>
> Chris
>
> On 12/1/05, Michael Saffitz <msa...@pc...> wrote:
> Hi Chris:
>
> dbaDeinstallGus is in the trunk of the repository, it's installed
> with GUS in $GUS_HOME/bin
>
> You can always just do a drop user dots, drop user ... and so on, but
> the utility is much faster and makes sure you didn't miss anything.
>
> --Mike
>
> On Dec 1, 2005, at 1:32 PM, Chris Topinka wrote:
>
> > where can I find the Deinstall script?  Is there a way to just
> > manually remove users/groups/tables from Oracle that conflict?
> >
> > thanks,
> >
> > chris
> >
> > On 11/29/05, Michael Saffitz <msa...@pc...> wrote:
> > Sorry.  You'll have to back out the previous install before you try
> > again.  You can use the dbaDeinstallGus utility to do this (but be
> > careful and read the warnings-- it will delete data).
> >
> > --Mike
> >
> > On Nov 29, 2005, at 1:20 PM, Chris Topinka wrote:
> >
> > > after creating GUS tablespace I get...
> > >
> > > BUILD FAILED
> > > /home/oracle/GUS/project_home/install/build.xml:28: The following
> > > error occurred while executing this line:
> > > /home/oracle/GUS/project_home/GUS/build.xml:92:
> > > java.io.IOException: Error executing SQL: '
> > > CREATE USER TESSVer IDENTIFIED BY temppass PASSWORD EXPIRE ACCOUNT
> > > LOCK  QUOTA UNLIMITED ON USERS DEFAULT TABLESPACE USERS' Error:
> > > ORA-01920: user name 'TESSVER' conflicts with another user or role
> > > name
> > >
> > >
> > > Thanks.
> > >
> > >
> > >
> > > On 11/29/05, Michael Saffitz < msa...@pc...> wrote:
> > > Hi Chris,
> > >
> > > Ok, you're almost there.  Either:
> > >
> > > 1) Create a GUS tablespace
> > > 2) Update your gus_schema.xml file (in $PROJECT_HOME/GusSchema/
> > > Definition/config) to use tablespace="USERS" (or whatever)
> > instead of
> > > GUS.
> > >
> > > --Mike
> > >
> > > On Nov 29, 2005, at 12:37 PM, Chris Topinka wrote:
> > >
> > > > How should I reply?
> > > >
> > > > Ok. now I get...
> > > >
> > > > [InstallSchema] Nov 29, 2005 11:32:07 AM
> > > > org.gusdb.schema.InstallSchemaTask execute
> > > > [InstallSchema] INFO: Reading database from /home/oracle/GUS/
> > > > project_home/GUS/Schema/gus_schema.xml
> > > > [InstallSchema] Nov 29, 2005 11:32:07 AM
> > > > org.gusdb.dbadmin.reader.SchemaReader doRead
> > > > [InstallSchema] INFO: Reading Database
> > > > [InstallSchema] Nov 29, 2005 11:32:08 AM
> > > > org.gusdb.dbadmin.model.Database resolveReferences
> > > > [InstallSchema] INFO: Resolving Database References
> > > > [InstallSchema] Nov 29, 2005 11:32:08 AM
> > > > org.gusdb.dbadmin.util.DatabaseValidator validate
> > > > [InstallSchema] INFO: Validating Database: 'null'
> > > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > > org.gusdb.schema.InstallSchemaTask setTablespace
> > > > [InstallSchema] INFO: Setting tablespaces to GUS
> > > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > > org.gusdb.dbadmin.util.DatabaseValidator validate
> > > > [InstallSchema] INFO: Validating Database: 'null'
> > > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > > org.gusdb.dbadmin.writer.SchemaWriter write
> > > > [InstallSchema] INFO: Writing Database
> > > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > > org.gusdb.dbadmin.util.DatabaseValidator validate
> > > > [InstallSchema] INFO: Validating Database: 'null'
> > > > [InstallSchema] Nov 29, 2005 11:32:09 AM
> > > > org.gusdb.dbadmin.writer.SchemaWriter write
> > > > [InstallSchema] INFO: Writing Database
> > > >
> > > > BUILD FAILED
> > > > /home/oracle/GUS/project_home/install/build.xml:28: The  
> following
> > > > error occurred while executing this line:
> > > > /home/oracle/GUS/project_home/GUS/build.xml:92:
> > > > java.io.IOException : Error executing SQL: '
> > > > ALTER USER SResVer QUOTA UNLIMITED ON GUS' Error: ORA-00959:
> > > > tablespace 'GUS' does not exist
> > > >
> > > >
> > > > what is this last line?
> > > >
> > > > On 11/29/05, Michael Saffitz < msa...@pc... > wrote:
> > > > Hi Chris,
> > > >
> > > > Don't use the sys account.  Use another account that has been
> > > granted
> > > > dba privileges.
> > > >
> > > > --Mike
> > > >
> > > > On Nov 29, 2005, at 12:24 PM, Chris Topinka wrote:
> > > >
> > > > > when I run build I get...
> > > > >
> > > > > [InstallSchema] Nov 29, 2005 11:12:18 AM
> > > > > org.gusdb.schema.InstallSchemaTask initialize
> > > > > [InstallSchema] SEVERE: Unable to connect to database.
> > > > > DSN=' jdbc:oracle:thin:@ws17.itcomplab.missouri.edu: 
> 1521 :WS17'
> > > > > [InstallSchema] java.sql.SQLException: ORA-28009:  
> connection to
> > > sys
> > > > > should be as sysdba or sysoper
> > > > > [InstallSchema]         at
> > > > > oracle.jdbc.driver.DatabaseError.throwSqlException
> > > > > (DatabaseError.java :124)
> > > > > [InstallSchema]         at
> > > oracle.jdbc.driver.T4CTTIoer.processError
> > > > > (T4CTTIoer.java:304)
> > > > > [InstallSchema]         at
> > > oracle.jdbc.driver.T4CTTIoer.processError
> > > > > ( T4CTTIoer.java:271)
> > > > > .
> > > > > .
> > > > > .
> > > > > .
> > > > > [InstallSchema]         at org.apache.tools.ant.Main.startAnt
> > > > > (Main.java:187)
> > > > > [InstallSchema]         at
> > > org.apache.tools.ant.launch.Launcher.run
> > > > > (Launcher.java:246)
> > > > > [InstallSchema]         at
> > > org.apache.tools.ant.launch.Launcher.main
> > > > > (Launcher.java:67)
> > > > >
> > > > > BUILD FAILED
> > > > > /home/oracle/GUS/project_home/install/build.xml:28: The
> > following
> > > > > error occurred while executing this line:
> > > > > /home/oracle/GUS/project_home/GUS/build.xml:92: Unable to
> > connect
> > > > > to database
> > > > >
> > > > > Total time: 7 seconds
> > > > >
> > > > >
> > > > > My gus.config looks like this:
> > > > >
> > > > > dbVendor=Oracle
> > > > > dbiDsn=dbi:Oracle: ws17.itcomplab.missouri.edu
> > > > > jdbcDsn= jdbc:oracle:thin:@ws17.itcomplab.missouri.edu :
> > 1521 :WS17
> > > > >
> > > > >
> > > > > # Login and Password to the RDBMS
> > > > >
> > > > > databaseLogin=sys
> > > > > databasePassword=adminws17
> > > > >
> > > > > # Username, group, and project info from the relevant Core
> > tables
> > > > >
> > > > > userName=sys
> > > > > group=sysdba
> > > > > project=Database administration
> > > > >
> > > > > tablespace=GUS
> > > > >
> > > > > Any suggestions? The line:
> > > > >
> > > > > [InstallSchema] java.sql.SQLException: ORA-28009:  
> connection to
> > > sys
> > > > > should be as sysdba or sysoper
> > > > >
> > > > > seems to be the problem.  How should I change config?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > chris
> > > > >
> > > > >
> > > > > --
> > > > > Christopher M. Topinka
> > > > > NLM-BHIRT Predoctoral Fellow in Computer Science
> > > > > 113 Life Sciences Center
> > > > > University of Missouri
> > > > > Columbia, MO 65211
> > > > > (573)-823-0616
> > > > > cmt...@mi...
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Christopher M. Topinka
> > > > NLM-BHIRT Predoctoral Fellow in Computer Science
> > > > 113 Life Sciences Center
> > > > University of Missouri
> > > > Columbia, MO 65211
> > > > (573)-823-0616
> > > > cmt...@mi...
> > >
> > >
> > >
> > >
> > > --
> > > Christopher M. Topinka
> > > NLM-BHIRT Predoctoral Fellow in Computer Science
> > > 113 Life Sciences Center
> > > University of Missouri
> > > Columbia, MO 65211
> > > (573)-823-0616
> > > cmt...@mi...
> >
> >
> >
> >
> > --
> > Christopher M. Topinka
> > NLM-BHIRT Predoctoral Fellow in Computer Science
> > MU ACM Student Chapter 2005-2006 Program Chair
> > University of Missouri
> > Columbia, MO 65211
> > (573)-823-0616
> > cmt...@mi...
>
>
>
>
> -- 
> Christopher M. Topinka
> NLM-BHIRT Predoctoral Fellow in Computer Science
> MU ACM Student Chapter 2005-2006 Program Chair
> University of Missouri
> Columbia, MO 65211
> (573)-823-0616
> cmt...@mi...