New Oracle database on Chevre

[Xiaokang Pan]

Dear Gramene Oracle database users:

     Because we are no longer to use the Gruyere machine for our Gramene
project, I have created a new Oracle database on Chevre to replace the
current Oracle database on Gruyere. 

     The new database is named "gramene" (i.e., SID = gramene). Within 
this database, four user accounts have been set up for our project
purposes: usernames "riceseq" for rice BAC/PAC info, "ontology" for gene
and trait ontology data, "cmap" for comparative mapping data, "test" for
any people to do tests. The passwords are the same as the old ones in the
current database on Gruyere machine. 

     The new database was created based on Oracle 8.0.5 Server which was
installed last year and has been using by another project group since the
time it was created. So, it is important to set up your working
environment in your account on Chevre and make sure that the SID is
gramene. Here is an example for C shell users to set up the environement
in .cshrc to use the new database:
     setenv ORACLE_HOME /oracle1/app/oracle/product/8.0.5
     setenv ORACLE_BASE /oracle1/app/oracle
     setenv LD_LIBRARY_PATH /oracle1/app/oracle/product/8.0.5/lib:/usr/lib
     setenv ORACLE_TERM xsun5
     setenv PATH $ORACLE_HOME/bin:/opt/bin:$PATH
     setenv ORACLE_SID gramene

     After making sure that you can login into the database, please try to
move your stuff from the current database on the Gruyere machine to the
new database on Chevre. If you have problems on using this database,
please let me know. 

     Thanks,
     Xiaokang