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

[Steve Bear_1]

No lanscan works fine.

[Graham Cameron_1]

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

[Steve Bear_1]

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

[Steve Bear_1]

trace_level_listener = admin generates a 0 byte file.

[Graham Cameron_1]

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

[Steve Bear_1]

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

and couldnt find listener.ckp

[Yogeeraj_1]

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

regards
Yogeeraj

[T G Manikandan]

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

[Graham Cameron_1]

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

[Mark Grant]

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

[Steve Bear_1]

Yogeeraj-
no, lsnrctl>start just sat there, nothing in the listener.log and trace.
LSNRCTL> start
Starting /apps/oracle/product/7.3.2.2/bin/tnslsnr: please wait...

Graham--
no we havent tried yet reverting the IP address.

logging a TAR at metalink to see what they recommend.

Thanks,

[T G Manikandan]

What does your sqlnet.ora file have.

[Steve Bear_1]

$cat sqlnet.ora

NAMES.DIRECTORY_PATH= (TNSNAMES)

[T G Manikandan]

Can you attach your listener.ora,tnsnames.ora,sqlnet.ora files

[T G Manikandan]

Must be silly but do you have multiple ORACLE installations.
Is the ORACLE_HOME pointing to the right path and are the right network configuration files updated.
$ORACLE_HOME/network/admin