Oracle DB instance not coming UP

[Shwetang Buch]

Hi,

Facing problem with Oracle 11g  instance. The Database Instance is showing down.
If I try to perform recovery it yields with the following error:

Io exception: The Network Adapter could not establish the connection

Current Status - OPEN

Now, what I found on the server is, when I telnet localhost, 127.0.0.1 and hostname on 1521 port, it gets connected. But if I telnet to server Ip address, it says connection refused:

Same thing with the tnsping command. tnsping to localhost is successful and to IP address fails:



Seek your help here.

Thanks.

Shwetang Buch
System Admin
CIGNEX Datamatics Tech.

[Alok Thaker]

Hi,

Shwetang at the time of oracle installation did you binded with local ip address instead of localhost and if you have binded with ip address was the ipaddress changed then oracle instance would surely have a problem.

Might be this would be helpful http://docs.oracle.com/cd/B10464_05/core.904/b10376/host.htm#i1009484

Thanks & Regards,

Alok

--
--
Please read http://www.catb.org/~esr/faqs/smart-questions.html before posting.
You received this message because you are subscribed to the "Vibrant GNU/Linux User Group".
To stop receiving emails from this group, mail to VGLUG+un...@googlegroups.com
To post to this group, send email to VG...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/VGLUG
 
 
 

[Shwetang Buch]

Hi Alok,

Thanks. But problem is not with the hostname. The oracle listener status is UP.
The issue is the oracle instance can not be connected through server IP. It works fine with the hostname or localhost. See the tnsping command output in both the cases:

[oracle@ctplsrv093 admin]$ tnsping localhost

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 09-NOV-2012 22:35:54

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
OK (0 msec)


[oracle@ctplsrv093 admin]$ tnsping 192.168.102.200

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 09-NOV-2012 22:36:06

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.102.200)(PORT=1521)))
TNS-12541: TNS:no listener


Check the execution of nmap command in both cases. It is not showing oracle instance in second case.

[oracle@ctplsrv093 admin]$ nmap localhost

Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2012-11-10 00:03 IST
Interesting ports on ctplsrv093 (127.0.0.1):
Not shown: 1667 closed ports
PORT     STATE SERVICE
25/tcp   open  smtp
80/tcp   open  http
111/tcp  open  rpcbind
443/tcp  open  https
631/tcp  open  ipp
925/tcp  open  unknown
1158/tcp open  lsnr
1521/tcp open  oracle
3306/tcp open  mysql
5520/tcp open  sdlog
5802/tcp open  vnc-http-2
5902/tcp open  vnc-2
6002/tcp open  X11:2

Nmap finished: 1 IP address (1 host up) scanned in 0.163 seconds
[oracle@ctplsrv093 admin]$ nmap 192.168.102.200

Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2012-11-10 00:03 IST
Interesting ports on 192.168.102.200:
Not shown: 1670 closed ports
PORT     STATE SERVICE
80/tcp   open  http
111/tcp  open  rpcbind
443/tcp  open  https
925/tcp  open  unknown
1158/tcp open  lsnr
3306/tcp open  mysql
5520/tcp open  sdlog
5802/tcp open  vnc-http-2
5902/tcp open  vnc-2
6002/tcp open  X11:2

Nmap finished: 1 IP address (1 host up) scanned in 0.142 seconds


Check the telenet output below and see the difference:

[oracle@ctplsrv093 admin]$ telnet localhost 1521
Trying 127.0.0.1...
Connected to ctplsrv093.cignex.com (127.0.0.1).
Escape character is '^]'.




Connection closed by foreign host.
[oracle@ctplsrv093 admin]$ telnet 192.168.102.200 1521
Trying 192.168.102.200...
telnet: connect to address 192.168.102.200: Connection refused
telnet: Unable to connect to remote host: Connection refused


That is the problem. listener service is working fine but DB instance can not be connected when accessed through IP address.

[Alok Thaker]

Hi Shwetang,

I neve said that the problem is with hostname buddy it is just that I am asking that did you binded yourld local ip while oracle installation if yes oracle service would start with local eth0 ip if you have done it then was the ip changed later to new ip because if once oracle is binded with a local eth0 ip and if it gets changed listener would surely have a problem. So please follow the link I send you and let me know for the same

Thanks & Regards,

Alok