Re: [GUSDEV] install on local host

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

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