Skip to Content
0
Aug 17, 2015 at 12:57 PM

Fatal NI connect error 12518 in ORACLE 11g Data Guard

631 Views

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