Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Orcale listner problem hang on status

Richard Ace
Frequent Advisor

Orcale listner problem hang on status

This server has just been regressed fro 11.0 to 10.20, the version of Oracle is V7.3.4.

I su - oracle then run lsnrctl status and it just hangs and then returns TNS timeout and errors.

All four istances of oracle are up i.e.

############################################
$ ps -ef |grep -i pmon
testmgr 3639 1 0 Jun 26 ? 0:10 ora_pmon_TEST
qamgr 4290 1 0 Jun 26 ? 0:10 ora_pmon_QA
ohtest 5944 1 0 Jun 26 ? 0:10 ora_pmon_OHTEST
oh31mgr 7887 1 0 Jun 26 ? 0:10 ora_pmon_OH31
oracle 23190 20683 0 09:58:53 ttyp1 0:00 grep -i pmon
$
$ ps -ef |grep -i smon
testmgr 3647 1 0 Jun 26 ? 0:18 ora_smon_TEST
root 1527 1 0 Jun 26 ? 0:00 /etc/opt/resmon/lbin/emsagent
root 2480 1 0 Jun 26 ? 0:05 /etc/opt/resmon/lbin/p_client
qamgr 4299 1 0 Jun 26 ? 0:03 ora_smon_QA
oracle 23204 20683 0 09:59:05 ttyp1 0:00 grep -i smon
ohtest 5955 1 0 Jun 26 ? 0:03 ora_smon_OHTEST
oh31mgr 7895 1 0 Jun 26 ? 0:03 ora_smon_OH31
###############################################
The lsnr is up now but was not yesterday when I was looking at it.

$ ps -ef |grep -i lsnr
oracle 1811 1 0 Jun 26 ? 0:00 /oracle/v7.3.4/bin/tnslsnr LISTt
oracle 23445 20683 4 10:00:38 ttyp1 0:00 grep -i lsnr


###############################################

I su - oracle then run lsnrctl status and it just hangs and then returns TNS timeout and errors.



$ lsnrctl status

LSNRCTL for HPUX: Version 2.3.4.0.0 - Production on 27-JUN-02 09:42:19

Copyright (c) Oracle Corporation 1994. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=BONNIE)(PORT=1521))
TNS-12203: TNS:unable to connect to destination
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
HPUX Error: 238: Connection timed out



I have checked tnsnames.ora but dont quite know what to look for. I have checked port 1521 in the services file which exists.

Any Idea

Cheers

Rich
9 REPLIES
Tom Geudens
Honored Contributor

Re: Orcale listner problem hang on status

Hi,
What does $ORACLE_HOME/network/log/listener.log tell you ?
There should be errors in there if you are experiencing problems.
Can you connect to the databases (using @) ?
Have you tried stopping/starting the listener ?

Let me know ...
Tom
A life ? Cool ! Where can I download one of those from ?
Richard Ace
Frequent Advisor

Re: Orcale listner problem hang on status

The listner log says the same info costant

Stopping the lisner it just hangs and produce
the message I inserted prior TNS

See below:

26-JUN-02 16:29:42 * (CONNECT_DATA=(SID=QA)(CID=(PROGRAM=C:\Program Files\Micros
oft Office\Office\MSACCESS.EXE)(HOST=DK011942)(USER=mcgregf))) * (ADDRESS=(PROTO
COL=tcp)(HOST=181.128.3.51)(PORT=4363)) * establish * QA * 0
26-JUN-02 16:54:18 * (CONNECT_DATA=(SID=test)(CID=(PROGRAM=C:\Program Files\Micr
osoft Office\Office\EXCEL.EXE)(HOST=DK011942)(USER=mcgregf))) * (ADDRESS=(PROTOC
OL=tcp)(HOST=181.128.3.51)(PORT=1263)) * establish * test * 0
27-JUN-02 09:00:53 * (CONNECT_DATA=(SID=test)(CID=(PROGRAM=C:\Program Files\Micr
osoft Office\Office\EXCEL.EXE)(HOST=DK011942)(USER=mcgregf))) * (ADDRESS=(PROTOC
OL=tcp)(HOST=181.128.3.51)(PORT=1056)) * establish * test * 0
27-JUN-02 10:58:22 * (CONNECT_DATA=(SID=test)(CID=(PROGRAM=EXCEL.EXE)(HOST=DK013
915)(USER=Penrit_P))) * (ADDRESS=(PROTOCOL=tcp)(HOST=181.128.2.86)(PORT=1244)) *
establish * test * 0
27-JUN-02 10:58:29 * (CONNECT_DATA=(SID=test)(CID=(PROGRAM=EXCEL.EXE)(HOST=DK013
915)(USER=Penrit_P))) * (ADDRESS=(PROTOCOL=tcp)(HOST=181.128.2.86)(PORT=1245)) *
establish * test * 0

@ORACLE_SID ? do know But I have a DBA going to run it.

tnsnames.ora ???

listner.ora ????????




Tom Geudens
Honored Contributor

Re: Orcale listner problem hang on status

Hi,
Mmm ... could the problem be that the host "BONNIE" can not be reached ? Is this a remote host ... or the host you are on right now ? If it is a remote host, can you ping it ?

Regards,
Tom
A life ? Cool ! Where can I download one of those from ?
steven Burgess_2
Honored Contributor

Re: Orcale listner problem hang on status

Hi Rich

We are just converting our databses to oracle and have found issues with the listener -

The problems we have been having are with the socket connections not receiving complete connection/disconnections from the application

Check your open sockets - I can't remember which the listener runs on. You may find the listener port is in a FIN_WAIT state and waiting for a connection acknowledgement.

Check with

netstat -an | more ( port 50 ish I think)

To change the settings on 10.20 you will have to use nettune. Again I do have a required setting at work but can't remember the values or the actual parameter

Forgive me for being a little vague

Hope this helps

Steve
take your time and think things through
Richard Ace
Frequent Advisor

Re: Orcale listner problem hang on status

I can ping and telent bothe ways from Bonnie server to another server and visa virsa.

I have check the netstat to no avail
There is nothing in FIN_WAIT and nothing around port 50 ish my port is 1521

I have had the DBA to look the tnsnames.ora
and the listener.ora file to no avail.

?????

Rich
Dave Chamberlin
Trusted Contributor

Re: Orcale listner problem hang on status

can you attach a copy of the tnsnames.ora file? Are you using DNS or etc/hosts for name resolution?
Dave Chamberlin
Trusted Contributor

Re: Orcale listner problem hang on status

Also - did you reinstall Oracle after the OS change?
Aashish Raj
Valued Contributor

Re: Orcale listner problem hang on status

oracle 7.3.4 for HP-UX 11.0 will not work with HP-UX 10.2.
You need to install oracle 7.3.4 for HP-UX 10.2

Thanks
AR
Richard Ace
Frequent Advisor

Re: Orcale listner problem hang on status

Thanks all for the guidance!!

It turns out that the only thing I did not check first off was the Internal ping.

When I checked it obviously did not work.

So I checked the routing tables netstat -rn only to find that the following was missing!!!!

127.0.0.1 127.0.0.1 UH 8 390 lo0 4608
181.130.3.31 127.0.0.1 UH 4 1226 lo0 4608

So I added them

But..... When rebooted never guess theve gone.

When regressing from 11.0 to 10.20 the:-

/sbin/init.d/net scripts are different

I ammended this and then ran:-

/sbin/init.d/net stop ; /sbin/init.d/net start

Loopback and Host are still in the routing tables. YEEPEEEE!

NOTES FOR PEEEPS THAT HAVE THE SAME PROBLEM
###############################################
IN THE FUTURE
###############################################

Oracle did not need Relinking

Oracle v7.3.4 is compatable for 11.0 & 10.20

Oracle was Recovered and not Installed

Oracle does not need reinstalling