Warring in the alert log of primary:
Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=port))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBSID_DGB)(CID=(PROGRAM=oracle)(HOST=hostname)(USER=oracle))))
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.2.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production
Time: 01-JUN-2015 11:12:47
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Solution:
When checking the service in DR using lsnrctl status, you are not able to see the service "DBSID_DGB".
so logged in to the Standby db and modify the parameter,
SQL> alter system set "__dg_broker_service_names" = 'DBSID_DGB' scope=both;
System altered.
++Check the values.
SELECT
a.ksppinm "Parameter",b.ksppstvl "Session Value",c.ksppstvl "Instance Value" FROM
x$ksppi a,
x$ksppcv b,
x$ksppsv c
WHERE a.indx = b.indx
AND a.indx = c.indx
AND a.ksppinm LIKE '/__dg%' escape '/'
/
------------------
__dg_broker_service_names
DBSID_DGB
DBSID_DGB
++ Then check the lsnrctl status,You can see the services("DBSID_DGB").
$lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 01-JUN-2015 11:11:26
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 01-JUN-2015 10:29:23
Uptime 0 days 0 hr. 42 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/diag/tnslsnr/za-fdbs-dr-03/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=prot)))
Services Summary...
Service "DBSID" has 1 instance(s).
Instance "DBSID", status READY, has 1 handler(s) for this service...
Service "DBSID_DGB" has 1 instance(s).
Instance "DBSID", status READY, has 1 handler(s) for this service...
++ Now in Primary alert log we are not getting any more warnings.
Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=port))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBSID_DGB)(CID=(PROGRAM=oracle)(HOST=hostname)(USER=oracle))))
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.2.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production
Time: 01-JUN-2015 11:12:47
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Solution:
When checking the service in DR using lsnrctl status, you are not able to see the service "DBSID_DGB".
so logged in to the Standby db and modify the parameter,
SQL> alter system set "__dg_broker_service_names" = 'DBSID_DGB' scope=both;
System altered.
++Check the values.
SELECT
a.ksppinm "Parameter",b.ksppstvl "Session Value",c.ksppstvl "Instance Value" FROM
x$ksppi a,
x$ksppcv b,
x$ksppsv c
WHERE a.indx = b.indx
AND a.indx = c.indx
AND a.ksppinm LIKE '/__dg%' escape '/'
/
------------------
__dg_broker_service_names
DBSID_DGB
DBSID_DGB
++ Then check the lsnrctl status,You can see the services("DBSID_DGB").
$lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 01-JUN-2015 11:11:26
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 01-JUN-2015 10:29:23
Uptime 0 days 0 hr. 42 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/diag/tnslsnr/za-fdbs-dr-03/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=prot)))
Services Summary...
Service "DBSID" has 1 instance(s).
Instance "DBSID", status READY, has 1 handler(s) for this service...
Service "DBSID_DGB" has 1 instance(s).
Instance "DBSID", status READY, has 1 handler(s) for this service...
++ Now in Primary alert log we are not getting any more warnings.
1 comment:
Hi ,
what is this CID in the tns entry ? [ CID=(PROGRAM=oracle) ]
i am getting the same error in my alertlog of the database and the tns entry mentioned in the alertlog with the error contains 2 different host entries . can you please explain ?
Fatal NI connect error 12519, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=100.0.2.159)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SID=THOR)(CID=(PROGRAM=oracle)(HOST=hostname1)(USER=TEST))))
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 17-SEP-2017 08:30:25
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Post a Comment