Local Connections Are Not Working ORA-12157 "TNS:internal network communication error" (Doc ID 399342.1)

Last updated on NOVEMBER 02, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.2 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Feb-2013***

Symptoms

Every attempt to login locally to any database (using "sqlplus '/ as sysdba'") fails with the following error :
ORA-12157: TNS:internal network communication error

The truss output of the login attempt shows :

...

2899: brk(0x1002291B0) = 0
2899: brk(0x10022D1B0) = 0
2899: so_socket(2, 1, 0, "", 1) = 9
2899: setsockopt(9, 65535, 4, 0xFFFFFFFF7FFF7114, 4, 1) = 0
2899: bind(9, 0x10022C700, 16, 3) Err#126 EADDRNOTAVAIL
2899: close(9) = 0
2899: lseek(8, 0, SEEK_CUR) = 0
2899: lseek(8, 0, SEEK_CUR) = 0
2899: lseek(8, 0, SEEK_CUR)

...

SQL*NET trace shows :

[24-JUN -2009 15:06:02:212] nttbnd2addr: ip=loopback specified
[24-JUN -2009 15:06:02:212] nttbnd2addr: using 127.0.0.1
[24-JUN -2009 15:06:02:212] snlinGetAddrInfo: entry
[24-JUN -2009 15:06:02:212] snlinGetAddrInfo: exit
[24-JUN -2009 15:06:02:212] nttbnd2addr: using host IP address: 127.0.0.1

Truss confirms that the failure happens from Oracle Net system calls. The OS bind() function fails with an Err#126 EADDRNOTAVAIL. This suggests there is a problem with the local IP address or with the available sockets.

Changes

Configuration of IP settings on the host was done.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms