Local Connections Are Not Working ORA-12157 "TNS:internal network communication error"
(Doc ID 399342.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.2 [Release 8.1.7 to 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
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: using <localhost IP>
[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: <localhost IP>
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |