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.
Step 1 Log in as a ORACLE user in RCA1 node and set following environment and invoke DBCA:
$export ORACLE_HOME=/export/oracle/oracle/product/10.2.0/db
$export PATH=$ORACLE_HOME/bin:$PATH
$netca
Step 2 Oracle Net Configuration Assistant: Real Application Clusters, Configuration:
Select “Cluster configuration”
Step 3 Oracle Net Configuration Assistant: TOPSNodes:
Click “Select all nodes”
Step 4 Oracle Net Configuration Assistant: Welcome:
Select “Listener configuration”
Step 5 Oracle Net Configuration Assistant: Listener Configuration, Listener:
Select “Add”
Step 6 Oracle Net Configuration Assistant: Listener Configuration, Listener Name:
Listener Name: LISTENER
Step 7 Oracle Net Configuration Assistant: Listener Configuration, Select Protocols
Selected Protocols: TCP
Step 8 Oracle Net Configuration Assistant: Listener Configuration, TCP/IP Protocol:
Select “Use the standard port number of 1521”
Step 9 Oracle Net Configuration Assistant: Listener Configuration, More Listeners?
Select “No”
Step 10 Oracle Net Configuration Assistant: Listener Configuration Done:
Click on “Next”
Step 11 Oracle Net Configuration Assistant: Welcome
Select “Naming Methods configuration”
Click on “Next”
Step 12 Oracle Net Configuration Assistant: Naming Methods Configuration, Select Naming:
Select “Local Naming”
Step 13 Oracle Net Configuration Assistant: Naming Methods Configuration Done:
Click on “Next”
Step 14 Oracle Net Configuration Assistant: Welcome
Click on “Finish”
Step 15 Verify status of services.
$/export/home/oracle/oracle/product/10.2.0/crs/bin/crs_stat –t
Responses