Listening for configuration independent of database servers resolves ORA-12520 and ORA-12545 errors
Listening for configuration independent of database servers resolves ORA-12520 and ORA-12545 errors
I. Environment:
1. linux host ocm (192.168.217.130) as a database
Sys @ OCM> select * from v $ version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
2. linux host ocp (192.168.217.htm) as an independent remote listener
Sys @ OCP> select * from v $ version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
3. windows host (192.168.217.2) as the client
Windows 7
2. operate on the ocm host (192.168.217.130:
1. With tnsnames. ora
LISTENER_OCP =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.217.htm) (PORT = 1521 ))
)
2. configuration parameters
Sys @ OCM> alter system set remote_listener = LISTENER_OCP;
3. Check listening
[Oracle @ ocm ~] $ Lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0-Production on 29-MAY-2013 21:13:28
Copyright (c) 1991,200 9, Oracle. All rights reserved.
Connecting to (ADDRESS = (PROTOCOL = tcp) (HOST =) (PORT = 1521 ))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0-Production
Start Date 29-MAY-2013 20:34:42
Uptime 0 days 0 hr. 38 min. 47 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File/u01/app/oracle/product/11.2.0/network/admin/listener. ora
Listener Log File/u01/app/oracle/diag/tnslsnr/ocm/listener/alert/log. xml
Listening Endpoints Summary...
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = ocm.example.com) (PORT = 1521 )))
Services Summary...
Service "ocm" has 1 instance (s ).
Instance "ocm", status READY, has 1 handler (s) for this service...
Service "ocmXDB" has 1 instance (s ).
Instance "ocm", status READY, has 1 handler (s) for this service...
The command completed successfully
3. operate on the ocp host (192.168.217.htm:
1. Check listening
[Oracle @ ocp ~] $ Lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0-Production on 29-MAY-2013 20:49:22
Copyright (c) 1991,201 1, Oracle. All rights reserved.
Connecting to (ADDRESS = (PROTOCOL = tcp) (HOST =) (PORT = 1521 ))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0-Production
Start Date 29-MAY-2013 20:44:12
Uptime 0 days 0 hr. 5 min. 10 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File/u01/app/oracle/product/11.2.0/network/admin/listener. ora
Listener Log File/u01/app/oracle/diag/tnslsnr/ocp/listener/alert/log. xml
Listening Endpoints Summary...
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = ocp) (PORT = 1521 )))
Services Summary...
Service "ocm" has 1 instance (s ).
Instance "ocm", status READY, has 1 handler (s) for this service...
Service "ocmXDB" has 1 instance (s ).
Instance "ocm", status READY, has 1 handler (s) for this service...
Service "ocp" has 1 instance (s ).
Instance "ocp", status READY, has 1 handler (s) for this service...
The command completed successfully
2. Configure tnsnames. ora
Remote_130 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.217.htm) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = ocm)
)
)
3. connection test
[Oracle @ ocm admin] $ sqlplus hr/hr @ remote_130
SQL * Plus: Release 11.2.0.3.0 Production on Wed May 29 23:07:19 2013