Home > TNS > Listener can’t write log file

Listener can’t write log file

Symptoms

Listener can’t write log file. The log file has no log

[oracle@wplodb03 log]$ ls -al
total 28841972
drwxr-x—   2 oracle oinstall        4096 Jul 18 14:06 .
drwxr-x—  12 oracle oinstall        4096 May  7  2007 ..
-rw-r–r–   1 oracle oinstall           0 Aug 18 14:39 listener_wplodb03.log

Fixed

Set log_status of Listeners on/off as below

LSNRCTL> show log_status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter “log_status” set to ON
The command completed successfully
LSNRCTL> set log_status off
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter “log_status” set to OFF
The command completed successfully
LSNRCTL> show log_status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter “log_status” set to OFF
The command completed successfully
LSNRCTL> set log_status on
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter “log_status” set to ON
The command completed successfully
LSNRCTL> show log_status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter “log_status” set to ON
The command completed successfully
LSNRCTL> exit
[oracle@wplodb03 log]$ ls -lrt
-rw-r–r–  1 oracle oinstall     4972026 Aug 17 23:10 sqlnet.log
-rw-r–r–  1 oracle oinstall        1759 Aug 18 14:44 listener_wplodb03.log

After on/off, the log file grows

Advertisements
Categories: TNS
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: