Re: [GUSDEV] install on local host

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

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