Upgrade Oracle 9i RAC to Oracle 10g RAC - Page 3

January 31, 2006

Step 3: Install Oracle RAC Software

3a. Edit the oracle user environment file

[oracle@salmon1]$ more .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi
export PATH=$PATH:$HOME/bin
export ORACLE_SID=prod1a
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORA_CRS_HOME=$ORACLE_BASE/product/crs
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
umask 022
[oracle@salmon1]$ mkdir -p /u01/app/oracle/product/10.2.0/db_1

3b. Oracle Database pre-installation checks

Perform Oracle Database pre-installation checks and correct any errors:

/stage/clusterware/cluvfy/runcluvfy.sh stage –pre dbinst -n salmon1,salmon2 –verbose

3c. Install RAC software

Mount the Oracle Database 10g Enterprise Edition CD or download the software from http://www.oracle.com/technology/software/products/database/oracle10g/index.html.

Launch the OUI on only the first node. During installation, the installer automatically copies the software to the second node.

1. Welcome: Click "Next"
2. Select Installation Type:
   a. Select "Enterprise Edition"
3. Specify Home Details:
   a. Name: OraDB10g_home1
   b. Path: /u01/app/oracle/product/10.2.0/db_1
4. Specify Hardware Cluster Installation Mode:
   a. Select "Cluster Installation"
   b. Click on "Select All"
5. Product-Specific Prerequisite Checks:
   a. Verify that all checks are successful before proceeding.
6. Select Configuration Option:
   a. Select "Install database Software only"
7. Summary: Click on "Install"
8. Execute Configuration scripts: Execute /u01/app/oracle/product/10.2.0/db_1/root.sh script
from another window as the root user on each cluster node.
9. Return to the Execute Configuration scripts screen and click on "OK."
10. End of Installation: Click on "Exit."

3d. Configure Oracle Listener

The Network Configuration Assistant (NETCA) should only be launched and configured on one node. At the end of the configuration process, the NETCA starts up the Oracle listener on both nodes.

1. Real Application Clusters, Configuration:
   a. Select "Cluster configuration"
2. Real Application Clusters, Active Nodes:
   a. Click on "Select all nodes"
3. Welcome:
   a. Select "Listener configuration"
4. Listener Configuration, Listener:
   a. Select "Add"
5. Listener Configuration, Listener Name:
    a. Listener Name: LISTENER
6. Listener Configuration, Select Protocols:
   a. Selected Protocols: TCP
7. Listener Configuration, TCP/IP Protocol:
   a. Select "Use the standard port number of 1521"
8. Listener Configuration, More Listeners?:
   a. Select "No"
9. Listener Configuration Done:
a. Click on "Finish"

3e. Verify status of services

On node 1:

[oracle@salmon1]$ srvctl status nodeapps -n salmon1
VIP is running on node: salmon1
GSD is running on node: salmon1
Listener is running on node: salmon1
ONS daemon is running on node: salmon1

On node 2:

[oracle@salmon2]$ srvctl status nodeapps -n salmon2
VIP is running on node: salmon2
GSD is running on node: salmon2
Listener is running on node: salmon2
ONS daemon is running on node: salmon2

3f. listener.ora file

On node 1:

LISTENER_SALMON1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = salmon1-vip)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.184)(PORT = 1521)(IP = FIRST))
    )
  )
SID_LIST_LISTENER_SALMON1 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )

On node 2:

LISTENER_SALMON2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = salmon2-vip)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.185)(PORT = 1521)(IP = FIRST))
    )
  )
SID_LIST_LISTENER_SALMON2 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )