ORA-12157: Tns:Internal Network Communication Error
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