Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jan 31, 2006

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

By DatabaseJournal.com Staff

by Vincent Chan

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
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
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:

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

On node 2:

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

Oracle Archives

Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM