Showing posts with label lsnrctl. Show all posts
Showing posts with label lsnrctl. Show all posts

Saturday, June 18, 2011

How to clean listener log on oracle 9i and 10g

Let, our database name is LIST_MYDB and listener for this database is LIST_MYDB.

If needed doe below:
open "listener.ora" and put ADMIN_RESTRICTIONS_l[istener_name]=off and RELOAD [listnere_name]"
then proceed as below:

1. stop logging
$ lsnrctl
LSNRCTL> set CURRENT_LISTENER LIST_MYDB
Current Listener is LIST_MYDB

LSNRCTL> set Log_status off

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MYHOST)(PORT=1533)))
LIST_MYDB parameter "log_status" set to OFF
The command completed successfully

2. move the current log
$ mv list_mydb.log mv list_mydb.log_old

3. start logging
$ lsnrctl
LSNRCTL> set CURRENT_LISTENER LIST_MYDB

LSNRCTL> set Log_status on

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MYHOST)(PORT=1533)))
LIST_MYDB parameter "log_status" set to ON
The command completed successfully

LSNRCTL> exit

If forgot to stop logging [step 1] then logging may stop automatically.
In this case after completing step 2, do as step 1 and then step 3.

Now do below if needed:
open "listener.ora" and put ADMIN_RESTRICTIONS_l[istener_name]=on and RELOAD [listnere_name]"