ORA-12157: TNS:internal network communication error

ERROR

ORA-12157: TNS:internal network communication error 

SOLUTION

This error ussualy occurs when the network files are not generated properly. Relink them using the below commands to fix the issue.

Step 1. Go to Oracle Home

cd $ORACLE_HOME/network/lib

Step 2. Regenerate file by giving the following Command

$make -f ins_net_client.mk ntcontab.o

Step 3. Got to bin folder of Oracle Home

$cd $ORACLE_HOME/bin

Step 4. Run the following given command

$genclntsh

Step 5. Go to Lib folder

$cd $ORACLE_HOME/rdbms/lib

Step 5. Generate files through the given command

$make -f ins_rdbms.mk install

Step 6. Go to lib folder

$cd $ORACLE_HOME/sqlplus/lib

Step 7. Generate files through the given command.

$make -f ins_sqlplus.mk install