Home » RDBMS Server » Server Administration » renaming the listener log_file on 11gr2 (oracle 11gR2 on 64bit windows 2008 r2)
renaming the listener log_file on 11gr2 [message #570450] Fri, 09 November 2012 14:49 Go to next message
krish96
Messages: 26
Registered: October 2012
Junior Member
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 09-NOV-2012 19:55:06
Uptime 0 days 0 hr. 24 min. 26 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File c:\oracle\diag\tnslsnr\TESTQ51\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=NDCORCKSDQ51.global.loc)(PORT=1521)))
Services Summary...
Service "testdb" has 1 instance(s).
Instance "ksdtest", status READY, has 1 handler(s) for this service...
Service "testdbXDB" has 1 instance(s).
Instance "testdb", status READY, has 1 handler(s) for this service...
The command completed successfully

i am trying to rename the logfile
"c:\oracle\diag\tnslsnr\TESTQ51\listener\alert\log.xml" to "c:\oracle\diag\tnslsnr\TESTQ51\listener\alert\testdb.log"

so far i tried

LSNRCTL> set log_file testdb.log
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-01251: Cannot set trace/log directory under ADR
LSNRCTL>

any solution please ..


Re: renaming the listener log_file on 11gr2 [message #570451 is a reply to message #570450] Fri, 09 November 2012 14:52 Go to previous messageGo to next message
BlackSwan
Messages: 22470
Registered: January 2009
Senior Member
>i am trying to rename the logfile
>"c:\oracle\diag\tnslsnr\TESTQ51\listener\alert\log.xml" to "c:\oracle\diag\tnslsnr\TESTQ51\listener\alert\testdb.log"

do it at the OS level
Re: renaming the listener log_file on 11gr2 [message #570892 is a reply to message #570451] Sat, 17 November 2012 13:09 Go to previous messageGo to next message
Rasoul_57
Messages: 8
Registered: October 2012
Location: Iran
Junior Member
It is not done at the os level because it is used by another program or personn
First Disable services then rename it
Re: renaming the listener log_file on 11gr2 [message #570915 is a reply to message #570892] Sun, 18 November 2012 03:06 Go to previous message
John Watson
Messages: 4367
Registered: January 2010
Location: Global Village
Senior Member
It is good of you to try to help, Rasoul, but on this occasion you are wring (and so is the Black Swan!) I think the quesiton is not about how to rename an existing file, but how to cause the listener to generate a different file.

@krish, by default your listener uses ADR logging, which means te filename cannot be changed. If you want to use your own fule name, you must dust disable ADR logging with tis entry in your listener.ora file,
diag_adr_enabled_listener=false
and probably this in your sqlnet.ora
diag_adr_enabled=false
as well. Read up on ADR logging in the Net Services Admin Guide.

Previous Topic: Renaming Datafile
Next Topic: Unable To Connect to Oracle 11g EM
Goto Forum:
  


Current Time: Tue Jul 22 03:15:40 CDT 2014

Total time taken to generate the page: 0.12553 seconds