Note, the Oracle server on Jupiter is reserved for members of the DISL group.
Oracle Server is upgraded to version 9.0.1.0.0. You can use
the new server with more features provided by Oracle9i. You may want to
know the following information
related to the migration.
1. A summary of upgrading.
2. (Important!) The configuration changes you need to make to use the new
Oracle.
2.1 For sqlplus
2.2 For JDBC access
3. New products/features
1. Upgrading Summary
I installed Oracle9i Database (software) 9.0.1.0.0. It took me five times
to finally install it successfully. A lesson I learned is not to run a
java-based GUI application on Exceed without the desktop display. The GUI
displayed so badly that you would miss some check lists,
choices and inputs you need make, which caused the four failures.
Then I migrated our database to 9.0.1.0.0. The migration took a very long
time. (about 6 hours to a half day for a 17G database.)
I did not install Oracle9i Client and Oracle9i management and Integration
on jupiter, which are not very useful for us right now. If we need it, I believe we should install these
two components on a machine other than jupiter to avoid the bottleneck.
2. Configuration Changes.
I assume you use either sqlplus or JDBC to access the database.
2.1 Accessing through sqlplus
You need to replace the oracle-related configurations in your start up
files with the new configuration as below.
NOTE: you must log in again or execute the configuration file after you have edited it for
the changes to take effect. For example:
"source $HOME/.cshrc-sun-5"
For your curiosity, the main change is the variable
ORACLE_HOME. sqlplus resides the bin directory
of the new ORACLE_HOME.
#----------------------------------------------------------------------------#
# Set the environment for Oracle for C Shell
#
#----------------------------------------------------------------------------#
set ORAENV_ASK = NO
setenv ORACLE_BASE /hp71/oracle/oraInventory
setenv ORACLE_HOME /hp71/oracle/OraHome9i
setenv ORACLE_SID infopipe
setenv LD_LIBRARY_PATH $ORACLE_HOME/lib
setenv PATH /hp71/oracle/bin:$ORACLE_HOME/bin:usr/ccs/bin:/usr/bin:/etc:/usr/openwin/bin:/usr/local/bin:$PATH
setenv CLASSPATH /hp71/oracle/jre:$ORACLE_HOME/JRE/lib:$ORACLE_HOME/JRE/lib/rt.jar:$ORACLE_HOME/jlib/:$ORACLE_HOME/product/jlib:$CLASSPATH
source /hp71/oracle/bin/coraenv
unset ORAENV_ASK
#----------------------------------------------------------------------------#
# Set the environment for Oracle for B Shell
#
#----------------------------------------------------------------------------#
set ORAENV_ASK = NO
setenv ORACLE_BASE /hp71/oracle/oraInventory
setenv ORACLE_HOME /hp71/oracle/OraHome9i
setenv ORACLE_SID infopipe
setenv LD_LIBRARY_PATH $ORACLE_HOME/lib
setenv PATH /hp71/oracle/bin:$ORACLE_HOME/bin:usr/ccs/bin:/usr/bin:/etc:/usr/openwin/bin:/usr/local/bin:$PATH
setenv CLASSPATH /hp71/oracle/jre:$ORACLE_HOME/JRE/lib:$ORACLE_HOME/JRE/lib/rt.jar:$ORACLE_HOME/jlib/:$ORACLE_HOME/product/jlib:$CLASSPATH
source /hp71/oracle/bin/oraenv
unset ORAENV_ASK
2.2 Accessing through JDBC
Current JDBC implementation you use should still work. However, Oracle9i
provides some new versions that you may want to try. $Oracle_Home/jdbc/
(/hp71/oracle/OraHome9i/jdbc) contains the new jdbc library, demo and
docs. It is group open for read.
3. New products and features
It seems that Oracle9i comes with some new products.
For more information, visit http://jupiter.cc.gatech.edu:7777/.
Not all the demos are working because we did not use their default
database. We use a database that is migrated from Oracle8, which doesn't
contain the data for the new Oracle9i demos.