HOME > > Configure Oracle Listener

Configure Oracle Listener

Anup - Tuesday, October 4, 2022

 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


Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me