Monday, 1 June 2015

Primary database alertlog giving below error(TNS-12564) for DGMGRL data guard services DBSID_DGB.

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.

1 comment:

Unknown said...

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