cancel
Showing results for 
Search instead for 
Did you mean: 

listener hung

Steve Bear_1
Frequent Advisor

listener hung

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,
44 REPLIES
Dave Hutton
Honored Contributor

Re: listener hung

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

Pete Randall
Outstanding Contributor

Re: listener hung

Was DNS updated with the new ip info?


Pete

Pete
Mark Grant
Honored Contributor

Re: listener hung

How did you change the ip address and did you update /etc/hosts and or NIS/DNS?
Never preceed any demonstration with anything more predictive than "watch this"
Jeff Schussele
Honored Contributor

Re: listener hung

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
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
Graham Cameron_1
Honored Contributor

Re: listener hung

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
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Steve Bear_1
Frequent Advisor

Re: listener hung

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
Honored Contributor

Re: listener hung

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

Massimo
Steve Bear_1
Frequent Advisor

Re: listener hung

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
Honored Contributor

Re: listener hung

Steve

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

-- Graham
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Steve Bear_1
Frequent Advisor

Re: listener hung

No lanscan works fine.
Graham Cameron_1
Honored Contributor

Re: listener hung

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
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Steve Bear_1
Frequent Advisor

Re: listener hung

no, it does not even get to the log file.
Steve Bear_1
Frequent Advisor

Re: listener hung

trace_level_listener = admin generates a 0 byte file.
Graham Cameron_1
Honored Contributor

Re: listener hung

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
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Steve Bear_1
Frequent Advisor

Re: listener hung

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
Honored Contributor

Re: listener hung

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

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
T G Manikandan
Honored Contributor

Re: listener hung

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
Honored Contributor

Re: listener hung

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
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Mark Grant
Honored Contributor

Re: listener hung

This might sound a bit silly, but is NFS used anywhere on this machine?
Never preceed any demonstration with anything more predictive than "watch this"
Steve Bear_1
Frequent Advisor

Re: listener hung

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
Honored Contributor

Re: listener hung

What does your sqlnet.ora file have.
Steve Bear_1
Frequent Advisor

Re: listener hung

$cat sqlnet.ora

NAMES.DIRECTORY_PATH= (TNSNAMES)
T G Manikandan
Honored Contributor

Re: listener hung

Can you attach your listener.ora,tnsnames.ora,sqlnet.ora files
T G Manikandan
Honored Contributor

Re: listener hung

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