Orcale listner problem hang on status

[Richard Ace]

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

[Tom Geudens]

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

[Richard Ace]

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]

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

[steven Burgess_2]

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

[Richard Ace]

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]

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

[Dave Chamberlin]

Also - did you reinstall Oracle after the OS change?

[Aashish Raj]

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]

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