Fatal NI connect error 12518 in ORACLE 11g Data Guard

[former_member186228]

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

[JamesZ]

Hi Jithin,

Are you able to connect the database via sqlplus directly?

Can you share the command output of "lsnrctl status" from standby host?

Best regards,

James

[former_member186228]

Hi James,

Our log shipping is working fine and switch over also working but inside alert log we are getting this error.

I am pasting lsnrctl status command output here.

On Primary System

>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 18-AUG-2015 12:29:14

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DEV.WORLD))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Production

Start Date                17-AUG-2015 14:10:22

Uptime                    0 days 22 hr. 18 min. 55 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   D:\oracle\DEV\11203\network\admin\listener.ora

Listener Log File         D:\oracle\diag\tnslsnr\MMDT0172\listener\alert\log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\DEV.WORLDipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\DEVipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mmdt0172)(PORT=1521)))

Services Summary...

Service "DEV_mmdt0172" has 1 instance(s).

  Instance "DEV", status UNKNOWN, has 1 handler(s) for this service...

Service "DEV_north_DGMGRL" has 1 instance(s).

  Instance "DEV", status UNKNOWN, has 1 handler(s) for this service...

Service "dev_north" has 1 instance(s).

  Instance "dev", status READY, has 1 handler(s) for this service...

Service "dev_north_DGB" has 1 instance(s).

  Instance "dev", status READY, has 1 handler(s) for this service...

The command completed successfully

On Physical Standby

> lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 18-AUG-2015 12:32:12

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DEV.WORLD))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Production

Start Date                17-AUG-2015 14:10:30

Uptime                    0 days 22 hr. 21 min. 44 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   D:\oracle\DEV\11203\network\admin\listener.ora

Listener Log File         D:\oracle\diag\tnslsnr\mmsr18\listener\alert\log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\DEV.WORLDipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\DEVipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MMSR18)(PORT=1521)))

Services Summary...

Service "DEV_mmsr18" has 1 instance(s).

  Instance "DEV", status UNKNOWN, has 1 handler(s) for this service...

Service "DEV_south_DGMGRL" has 1 instance(s).

  Instance "DEV", status UNKNOWN, has 1 handler(s) for this service...

Service "dev_south" has 1 instance(s).

  Instance "dev", status READY, has 1 handler(s) for this service...

Service "dev_south_DGB" has 1 instance(s).

  Instance "dev", status READY, has 1 handler(s) for this service...

The command completed successfully

Regards,

Jithin

[JamesZ]

Hi Jithin,

I think information below is the fatal ones:

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

You may need to check whether standby have physical access to the remote archived log directory.

Best regards,

James