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...