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