listener hung

[Steve Bear_1]

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,

[Dave Hutton]

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

[Pete Randall]

Was DNS updated with the new ip info?


Pete

[Mark Grant]

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

[Jeff Schussele]

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

[Graham Cameron_1]

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

[Steve Bear_1]

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.

[Massimo Bianchi]

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

Massimo

[Steve Bear_1]

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?

[Graham Cameron_1]

Steve

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

-- Graham