topic Re: listener hung in Operating System - HP-UX

listener hung

Steve Bear_1 — Wed, 17 Dec 2003 09:32:16 GMT

One of our hpux-10.20 with oracle 7.3.2.2 has had it ip address changed, since then oracle stops wokring on that box.

when i do
LSNRCTL> start
Starting /apps/oracle/product/7.3.2.2/bin/tnslsnr: please wait...

it just sat there and does nothing, i could not even kill it. kill or kill -9 does not actually kill it.

Even svrmgrl also gets hung.

Any suggestion ?

Thanks,

Re: listener hung

Dave Hutton — Wed, 17 Dec 2003 09:33:53 GMT

tnsnames.ora wasn't hard coded with an ip address, was it?

Re: listener hung

Pete Randall — Wed, 17 Dec 2003 09:34:28 GMT

Was DNS updated with the new ip info?

Pete

Re: listener hung

Mark Grant — Wed, 17 Dec 2003 09:34:55 GMT

How did you change the ip address and did you update /etc/hosts and or NIS/DNS?

Re: listener hung

Jeff Schussele — Wed, 17 Dec 2003 09:37:45 GMT

Hi,

Like Dave, I suspect the tnsnames.ora and/or the listener.ora file(s) had the IP coded within. If so they'll need to be changed to the new IP.

Rgds,
Jeff

Re: listener hung

Graham Cameron_1 — Wed, 17 Dec 2003 09:38:41 GMT

Your answer lies in this thread...

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=228084

You'll have to fix the problem and then reboot the box to get rid of the bad process.

-- Graham

Re: listener hung

Steve Bear_1 — Wed, 17 Dec 2003 09:40:38 GMT

tnsnames.ora has got a hostname in it and server doesnt use DNS.

Ip-address change was made through SAM and i have checked the hosts file , which has correct ipaddres for the server.

Re: listener hung

Massimo Bianchi — Wed, 17 Dec 2003 09:52:39 GMT

check the listener.ora , both in
/etc
and in
$ORACLE_HOME/network/admin
and in
$TNS_ADMIN

Massimo

Re: listener hung

Steve Bear_1 — Wed, 17 Dec 2003 10:07:54 GMT

Graham,

didnt remove setuid of any files in /usr/sbin.

-r-sr-xr-x 1 bin bin 49152 Apr 20 1999 /usr/sbin/lanscan

Any help?

Re: listener hung

Graham Cameron_1 — Wed, 17 Dec 2003 10:11:15 GMT

Steve

That's not quite what I meant.
Does lanscan hang since the IP address change? If so that's the problem.

-- Graham

Re: listener hung

Steve Bear_1 — Wed, 17 Dec 2003 10:11:53 GMT

No lanscan works fine.

Re: listener hung

Graham Cameron_1 — Wed, 17 Dec 2003 10:31:32 GMT

OK then, does it get as far as creating a log file, and if so, any clues in it?

Can you set
TRACE_LEVEL_{listener_name} = ADMIN
in the listener.ora, restart, and check for trace files?

-- Graham

Re: listener hung

Steve Bear_1 — Wed, 17 Dec 2003 10:32:47 GMT

no, it does not even get to the log file.

Re: listener hung

Steve Bear_1 — Wed, 17 Dec 2003 10:40:40 GMT

trace_level_listener = admin generates a 0 byte file.

Re: listener hung

Graham Cameron_1 — Wed, 17 Dec 2003 11:11:59 GMT

Steve

There's an article on metalink:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1061927.6

Basically the advice is to delete the "listener.ckp" file, which seems to be used when you have "USE_CKPFILE_LISTENER = TRUE" in listener.ora

Could this be it?

-- Graham

Re: listener hung

Steve Bear_1 — Wed, 17 Dec 2003 11:31:30 GMT

had a look at the metalink doc. Nothing like USE_CKPFILE_LISTENER = TRUE set in my listener.ora file.

and couldnt find listener.ckp

Re: listener hung

Yogeeraj_1 — Wed, 17 Dec 2003 13:31:50 GMT

hi,
can you post the output of your listener.ora?
Do you get any messages in your listener.log?

regards
Yogeeraj

Re: listener hung

T G Manikandan — Wed, 17 Dec 2003 22:13:34 GMT

you have to check three files for this

1.listener.ora
2.tnsnames.ora
3.sqlnet.ora

If you had changed the ip/hostname on the listener.ora ,do check the sqlnet.ora file as whether you have any nameserver defined in it for the order of resolution.

Just like nsswitch.conf file in unix for name resolution oracle has sqlnet.ora

Revert with the listener.log

Re: listener hung

Graham Cameron_1 — Thu, 18 Dec 2003 03:21:01 GMT

Like the others I'm running out of ideas, apart from stating the obvious that on such an old version of oracle you are f****d.

Also stating the obvious, have you tried reverting the IP address to see if the problem goes away?

-- Graham

Re: listener hung

Mark Grant — Thu, 18 Dec 2003 03:39:43 GMT

This might sound a bit silly, but is NFS used anywhere on this machine?