3 Replies Latest reply: May 29, 2008 5:59 AM by 19426 RSS

    ORA-12157: Tns:Internal Network Communication Error

    user454189
      Hi,

      OS:Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
      oracle:10.2.0.2.0
      [root@rhelia64 ~]# uname -a
      Linux rhelia64 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:32:02 EDT 2006 x86_64 x86_64 x86_64 GNU/Linux

      [root@rhelia64 ~]# cat /etc/hosts
      # Do not remove the following line, or various programs
      # that require network functionality will fail.
      127.0.0.1 localhost
      10.113.47.110 rhelia64 rhelia64.subex
      10.113.47.41 derby loghost

      cat /etc/sysctl.conf
      kernel.core_uses_pid = 1
      net.core.rmem_default = 262144
      net.core.rmem_max = 262144
      net.core.wmem_default = 262144
      net.core.wmem_max = 262144
      kernel.shmmax = 17179869184
      net.ipv4.ip_local_port_range = 1024 65000
      kernel.sem = 250 32000 100 128
      kernel.shmall=8589934592


      lsnrctl start

      LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 29-MAY-2008 12:16:33

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

      Starting /export/home/oracle/10.2.0/bin/tnslsnr: please wait...

      TNSLSNR for Linux: Version 10.2.0.2.0 - Production
      System parameter file is /export/home/oracle/10.2.0/network/admin/listener.ora
      Log messages written to /export/home/oracle/10.2.0/network/log/listener.log
      TNS-01150: The address of the specified listener name is incorrect
      TNS-01153: Failed to process string: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.113.47.110)(PORT=1521)))

      export ORACLE_HOME=/export/home/oracle/10.2.0
      export ORACLE_SID=ora10g
      export PATH=$ORACLE_HOME/bin:$PATH:.
      export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:.

      [oracle@rhelia64 admin]$ sqlplus '/as sysdba'

      SQL*Plus: Release 10.2.0.2.0 - Production on Thu May 29 12:16:17 2008

      Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

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

      Hi,
      This is my problem. I dont know why I face this bug. some document says the problem is with host with respect to listener and some says problem with respect to processes I have to increase

      this what the value set in initora10g
      *.processes=150

      I couldn't find any issue with these because I can able to ping to the host name and IP address


      this is how my listener is configured:

      LISTENER =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.113.47.110)(PORT = 1521))
      )

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (GLOBAL_DBNAME = ora10g)
      (ORACLE_HOME = /export/home/oracle/10.2.0)
      (SID_NAME = ora10g)
      )
      (SID_DESC =
      (GLOBAL_DBNAME = ora9i)
      (ORACLE_HOME = /storedge1/oracle/product/9.2.0.4.0)
      (SID_NAME = ora9i)
      )
      (SID_DESC =
      (GLOBAL_DBNAME = reliance)
      (ORACLE_HOME = /export/home/oracle/10.2.0)
      (SID_NAME = reliance)
      )
      )

      Can anyone help me to resove this issue

      With regards
      Boo