Fatal NI connect error 12518 in ORACLE 11g Data Guard
Hi all,
We are getting "Fatal NI connect error 12518" while performing switch over. In alert log shows below error message,
**************************************************************************************************************
***********************************************************************
Fatal NI connect error 12518, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=mmsr18)(PORT=1521)))(CONNECT_DATA=(SID=DEV)(SERVICE_NAME=DEV_mmsr18)(CID=(PROGRAM=d:\oracle\dev\11203\bin\ORACLE.EXE)(HOST=MMDT0172)(USER=SYSTEM))))
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production
Time: 17-AUG-2015 18:08:59
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
***********************************************************************
Fatal NI connect error 12518, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=mmsr18)(PORT=1521)))(CONNECT_DATA=(SID=DEV)(SERVICE_NAME=DEV_mmsr18)(CID=(PROGRAM=d:\oracle\dev\11203\bin\ORACLE.EXE)(HOST=MMDT0172)(USER=SYSTEM))))
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production
Time: 17-AUG-2015 18:08:59
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
***********************************************************************
Fatal NI connect error 12518, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=mmsr18)(PORT=1521)))(CONNECT_DATA=(SID=DEV)(SERVICE_NAME=DEV_mmsr18)(CID=(PROGRAM=d:\oracle\dev\11203\bin\ORACLE.EXE)(HOST=MMDT0172)(USER=SYSTEM))))
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production
Time: 17-AUG-2015 18:08:59
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
Error 12518 received logging on to the standby
FAL[server, ARC0]: Error 12518 creating remote archivelog file 'dev_mmsr18'
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
Please suggest if anyone face such problem
Regards,
Jithin