Non-default listening and port configuration for placing an instance in the Oracle11gRAC Environment

If you use dbca to create a single-instance database in the Oracle11gRAC environment, Oracle automatically registers it to the default port 1521 and listener. In most cases, we use

If you use dbca to create a single-instance database in the Oracle 11g RAC environment, Oracle automatically registers it to the default port 1521 and listener. In most cases, we use

If you use dbca to create a single-instance database in the Oracle 11g RAC environment, Oracle automatically registers it to the default port 1521 and listener. In most cases, we use non-default listeners and non-default listening ports. In the Oracle 11g RAC environment, the cluster Listener Configuration is taken over by the grid user. In this case, how should I configure non-default listeners and ports for a single instance? This article provides a solution and uses static and dynamic registration methods.

For configurations of non-default listeners and ports under a single instance, refer to the following article. In fact, you can still configure non-default listeners and ports for an instance in the RAC environment by referring to the following articles. However, the environment in the RAC environment is somewhat different from that in the previous single instance environment, so we recorded these small differences.

Configure dynamic service registration for non-default ports

Configure sqlnet. ora to restrict IP Access to Oracle

Configure and manage Oracle listener logs

Set the Oracle LISTENER password (LISTENER)

Configure the Oracle client to connect to the database

1. dbca listener after creating a single instance Database

-- Environment
[Grid @ linux1 ~] $ Cat/etc/issue
Enterprise Linux Server release 5.5 (Carthage)
Kernel \ r on an \ m
[Grid @ linux1 ~] $ Crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.1.0]

-- The instance cnbo is created using dbca In the RAC environment and is currently in the offline status.
[Oracle @ linux1 ~] $ Crsstat | grep cnbo
Ora. cnbo. db database c offline (linux1) 0 Instance Shutdown

-- The default listener is offline.
[Oracle @ linux1 ~] $ Crsstat | grep Listener | grep OFFLINE
Ora. LISTENER. lsnr Listener l offline (linux1) 0

-- Start the instance and listen
[Oracle @ linux1 ~] $ Srvctl start database-d cnbo
[Oracle @ linux1 ~] $ Srvctl start listener-l LISTENER
PRCC-1014: LISTENER was already running.

[Oracle @ linux1 ~] $ Export ORACLE_SID = cnbo
[Oracle @ linux1 ~] $ Sqlplus/as sysdba
SQL> set linesize 190
SQL> show parameter cluster_d ---> this instance is a single instance in the RAC Environment

NAME TYPE VALUE
---------------------------------------------------------------------------------------------------
Cluster_database boolean FALSE
Cluster_database_instances integer 1

-- The following lsnrctl status shows that the instance is registered with the default port 1521. After dbca creates the instance cnbo, it does not configure a listener for it.
-- The instance is indeed registered to the default listener, which should be automatically added by dbca.
-- Note: Starting from Oracle 11g RAC, the cluster listener Configuration is taken over by the grid user. Therefore, you can find the corresponding listener. ora file in the $ ORA_CRS_HOME/network/admin/directory.
[Grid @ linux1 ~] $ Lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0-Production on 16-AUG-2013 12:35:43
.............
Listening Endpoints Summary...
(DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = LISTENER )))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.7.21) (PORT = 1521 )))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.7.31) (PORT = 1521 )))
Services Summary...
Service "+ ASM" has 1 instance (s ).
Instance "+ ASM1", status READY, has 1 handler (s) for this service...
Service "cnbo.orasrv.com" has 1 instance (s). ---> this Service is provided by a single instance cnbo
Instance "cnbo", status READY, has 1 handler (s) for this service...
Service "cnboXDB.orasrv.com" has 1 instance (s ).
Instance "cnbo", status READY, has 1 handler (s) for this service...
The command completed successfully

2. Configure non-default listeners and Implement Dynamic Registration

-- Switch to the Oracle user and clear the listener. ora and tnsnames. ora
[Oracle @ linux1 ~] $ Cat/dev/null> $ ORACLE_HOME/network/admin/listener. ora
[Oracle @ linux1 ~] $ Cat/dev/null> $ ORACLE_HOME/network/admin/tnsnames. ora

-- Use netca to configure listeners and tnsnames. ora.
[Oracle @ linux1 ~] $ Export DISPLAY = 192.168.7.20.: 0.0
[Oracle @ linux1 ~] $ Netca

-- Author: Robinson Cheng
-- Blog:

--> The following is the result of netca configuration, including listener. ora and tnsnames. ora.
[Oracle @ linux1 ~] $ More $ ORACLE_HOME/network/admin/listener. ora
# Listener. ora Network Configuration File:/u01/app/oracle/db_1/network/admin/listener. ora
# Generated by Oracle configuration tools.

ADR_BASE_LISTENER_CNBO =/u01/app/oracle

LISTENER_CNBO = # -- the listener name is LISTENER_CNBO, and the port number is 1522.
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.7.21) (PORT = 1522 ))
)
)