listener hung

[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?