Wednesday, January 12, 2011

ORA-12157: TNS:internal network communication error

ORA-12157: TNS:internal network communication error

This error can happen if the network files not generated properly.

relink them using the below commands to fix the issue.

cd $ORACLE_HOME/network/lib
make -f ins_net_client.mk ntcontab.o
cd $ORACLE_HOME/bin
genclntsh
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk install
cd $ORACLE_HOME/sqlplus/lib
make -f ins_sqlplus.mk install

5 comments:

  1. I m facing the same problem... I tried this .. but its not working for me.. Is there any other solution

    [oracle@localhost ~]$ sqlplus /nolog
    SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 8 23:06:51 2011
    Copyright (c) 1982, 2005, Oracle. All rights reserved.
    SQL> conn sys/sys as sysdba
    ERROR:
    ORA-12157: TNS:internal network communication error

    ReplyDelete
  2. Thanks man. It worked for me.

    ReplyDelete
  3. Hi i followed the same above steps but still issue not resolved, please suggest me...

    -bash-3.1$ export ORACLE_SID=test
    -bash-3.1$ sqlplus / as sysdba

    SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 23 22:05:08 2012

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    ERROR:
    ORA-12157: TNS:internal network communication error

    ReplyDelete
  4. SQL> conn system
    Enter password:
    ERROR:
    ORA-12157: TNS:internal network communication error

    ayuda please

    ReplyDelete
  5. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete