-
Assuming I want to udgrade one database which of the two below is the right way to start.
Assuming the database name is MYDATABASE
Also Assuming this is my oracle home:
ORACLE_HOME=/oracle/orc/db/product/8.1.5;
EXAMPLE ONE
------------------
ORACLE_HOME=/oracle/orc/db/product/8.1.5;export ORACLE_HOME
ORACLE_SID=MYDATABASE;export ORACLE_SID
PATH=$PATH:$ORACLE_HOME/bin;export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATH
EXAMPLE TWO
--------------------
ORACLE_HOME=/oracle/orc/pp/product/8.1.5;export ORACLE_HOME
ORACLE_SID=MYDATABASE;export ORACLE_SID
which of the above examples is the right step before copying the init file to the new oracle home?
dorothy
-
The first one would be your best choice. Also include the CLASSPATH also in the settings.
Sam
-
What do you mean by CLASSPATH?
is it this
PATH=$PATH:$ORACLE_HOME/bin;export PATH ?
-
Class path is used to specify where the java libraries are at.
here you go.
CLASSPATH=$CLASSPATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib
export CLASSPATH
Sam