Oracle Listener (Parallel Thread for Fred)

[Adrian Sobers2]

attached is the listener.log file

do you need anything else?

[Fred Ruffet]

bloup :)

This is the listener.ora file. I would have like the listener.log file wich is probably in $ORACLE_HOME/network/log.

Regards,

Fred

[Adrian Sobers2]

attached is a zip file containing all the log files from the log directory...

[Fred Ruffet]

log doesn't seem to show a crash but only asked stop (maybe your script)

I may also need to see sqlnet.ora (there may be options for timeouts in it).

Have you got lines concerning local_listener in init.ora file ?

Regards,

Fred

[Adrian Sobers2]

Fred,

The sqlnet.ora is attached.

As for the local_listener in the init.ora the entry reads:

(ADDRESS=(PROTOCOL=tcp)(HOST=inland8)(PORT=1521))

[Adrian Sobers2]

oops, now it's attached ;)

[Fred Ruffet]

Would you mind removing the local_listener entry in your init.ora file, restart with this init.ora, and comment your script in crontab ? Maybe you can do that out of users hours (in case it continues to crash).

It works well in 9i, but I don't know for 8i. local_listener parameter makes oracle to redeclare itself to the listener periodically, and this may cause problems...

Regards,

Fred