This content has been marked as final. Show 3 replies
876149 wrote:There is no 'PROTOCOL=tcp' Endpoint.
I have static register listenerdb and it is up.
but when i want to connect from client pc it shows no listener.
Listener Parameter File /u02/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u02/app/oracle/diag/tnslsnr/drpdb1/listenerdb/alert/log.xml
Listening Endpoints Summary...
Service "drpdb.nblitd.com" has 1 instance(s).
Instance "drpdb1", status UNKNOWN, has 1 handler(s) for this service...
because it is in RAC.
# Generated by Oracle configuration tools.
(ORACLE_HOME = /u02/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = drpdb1)
(GLOBAL_DBNAME = drpdb.nblitd.com)
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENERDB))
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENERDB = ON
Edited by: 876149 on Apr 3, 2013 5:40 AM
>1 person found this helpful
because it is in RAC.In this case you should connect through scan_listener that listens on tcp.