Database Reference
In-Depth Information
2.
Set the environment variables and clean up the existing configuration (if such exists) on
both database nodes. (The Oracle SID will be different on each node). For example:
[oracle@s1 ~]$
export ORACLE_HOME=$NEW_OH
[oracle@s1 ~]$
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib
[oracle@s1 ~]$
export ORACLE_SID=PROD2
[oracle@s1 ~]$
export PATH=$PATH:$ORACLE_HOME/bin
[oracle@s1 ~]$
export CONTEXT_NAME=${ORACLE_SID}_`hostname -s`
[oracle@s1 ~]$
export TNS_ADMIN=$ORACLE_HOME/network/admin/${CONTEXT_NAME}
[oracle@s1 ~]$
mv appsutil appsutil.old
[oracle@s1 ~]$
mv $TNS_ADMIN ${TNS_ADMIN}.old
[oracle@s1 ~]$
rm $ORACLE_HOME/network/admin/*.ora
3.
Create the new Net services' configuration files on both database nodes. The configuration
files will only include pointers to the
AutoConfig
-managed configuration files that do not
exist at the moment, but will be created later. For example:
[oracle@s1 ~]$
echo "IFILE=${ORACLE_HOME}/network/admin/${CONTEXT_NAME}/tnsnames.ora" >
$ORACLE_HOME/network/admin/tnsnames.ora
[oracle@s1 ~]$
echo "IFILE=${ORACLE_HOME}/network/admin/${CONTEXT_NAME}/listener.ora" >
$ORACLE_HOME/network/admin/listener.ora
[oracle@s1 ~]$
echo "IFILE=${ORACLE_HOME}/network/admin/${CONTEXT_NAME}/sqlnet.ora" >
$ORACLE_HOME/network/admin/sqlnet.ora
Extract the new
appsutil.zip
on both database nodes (the file is already accessible
because the application tier is located on the
/cloudfs
). You also need to copy the JRE
from the old database Oracle Home into the extracted
appsutil
directory, as shown next:
4.
[oracle@s1 ~]$
unzip -q -d $ORACLE_HOME/ /cloudfs/prod/fs1/inst/apps/PROD_oevm1/admin/out/appsutil.zip
[oracle@s1 ~]$
rsync -az s1:/u02/prod/11.2.0/appsutil/jre $ORACLE_HOME/appsutil/
5.
Create the new database listener. Use “LISTENER_<SID>” as the listener name and set
the port according to the primary port pool you chose for the e-Business Suite (in this
example, the port pool is 11, so the listener port is 1532 (1521+11)). This needs to be run
on one of the DB nodes only. For example:
[oracle@s1 ~]$
srvctl add listener -l LISTENER_PROD -o $ORACLE_HOME -p 1532
[oracle@s1 ~]$
srvctl setenv listener -l LISTENER_PROD -T TNS_ADMIN=$ORACLE_HOME/network/admin
[oracle@s1 ~]$
srvctl start listener -l LISTENER_PROD
Adjust the
local_listener
parameter so that both database instances register to the local
listeners:
6.
[oracle@s1 ~]$
sqlplus / as sysdba
SQL>
alter system set local_listener='s1:1532' sid='PROD1';
System altered.
SQL>
alter system set local_listener='s2:1532' sid='PROD2';
System altered.
