Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

listener.log & alert._XXXX.log

kamilpMay 10 2012 — edited Jun 13 2012
Hello !

is there way how to disable logging into listener.log and alter_XXXX.log while keeping the booth alert/log.xml ?


Thank you & Regards

Comments

unknown-698157
What did you read in the documentation?
Your question doesn't make sense to me.
-------------
Sybrand Bakker
Senior Oracle DBA
Think_dba
Why do you want the same?

Anyways,.. below link would help you

1089481
kamilp
oracle has created 10GB log file - that is non sense for any developer. joke. xml files are rotated after 10M.
i setup adr to purge 336 hours, and I want to disable the .log because it is duplicate information to .xml

my question is if it is possible and how
839439
>
kamilp
ln -sf /dev/null alert_$ORACLE_SID.log
this solution explains much about oracle developers and support team. LoL
kamilp
I think this thread will go to my golden internet LOL resources
LMAO, oracle experts :)
Think_dba
 LMAO, oracle experts :)
Please refrain from putting such things here.It is a professional forum.
kamilp
It is a professional forum.
I haven't got a SINGLE professional answer in this thread, just post hunting.
So please anyone, who can ANSWER the question, please give me answer. Thanks.
unknown-698157
I will give you the short professional answer.

Obviously you didn't consult the documentation to see whether it is possible.
Most people here abuse this forum as a free documentation lookup service, disqualifying themselves as 'professional'
You seem to be no exception to this rule.
Because if you would have looked up documentation you would have known the answer is NO.
Your question is 100 percent redundant and unprofessional.

-------------
Sybrand Bakker
Senior Oracle DBA
kamilp
Thanks for answer, altought it could be put in first reply and altought it could be more polite way.
Obviously, I have checked documentation. And for me it seems logical to have such option, therefore I am asking - still there is chance I have misunderstand or not found something.
Think_dba
So please anyone, who can ANSWER the question, please give me answer. Thanks.
Nobody here is bound to give you answer. Don't comment on anyone like this what you did.
kamilp
Nobody here is bound to give you answer. Don't comment on anyone like this what you did.
you are not bound to post "spam" to thread. so pleas stop doing it. post if you can answer.
Aman....
kamilp wrote:
Hello !

is there way how to disable logging into listener.log and alter_XXXX.log while keeping the booth alert/log.xml ?

Please mention your db version in 4 digits with every question along with the o/s information as well. Question for you, why you want to disable this logging ? How you are going to find the reason of some happening in the db if the alert log is not going to have any info recorded for it?

Aman....
kamilp
I have Oracle 11.2.0.1.0, running on SuSE Linux 11. I can still find the information in alert/log.xml files - at least I hope so. All information in .log is also in .xml file, isnt it ?
I need to disable logging to listener.log it because it is growing fast, it is written twice (xml and log as well - lowers performance) and oracle software does not purge it or rotate logs by default.

Edited by: kamilp on May 10, 2012 1:42 AM
793965
i think u can stop the logging to listener.log by issuing the following command...

lsnrctl set log_status off

try it...
kamilp
lsnrctl set log_status off
this will stop logging both to trace/listener.log and alert/log.xml
Aman....
kamilp wrote:
lsnrctl set log_status off
this will stop logging both to trace/listener.log and alert/log.xml
Please read the documentation. The file under the folder ALert is not the listener's log but is the alert log only which is given in the XML format from 11g onwards.
http://docs.oracle.com/cd/E11882_01/server.112/e25494/diag001.htm#ADMIN11262

Aman....
793965
kamilp...

the alert log doesn't store information about the users connecting to it. It is the function of listener.log.
kamilp
I wonder if we talk about same files, I mean these files - full path

/opt/oracle/diag/tnslsnr/orcl/listener/trace/listener.log
/opt/oracle/diag/tnslsnr/orcl/listener/alert/log.xml

and I really think it has same content i.e.

trace/listener.log
10-MAY-2012 12:25:23 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.150.104)(PORT=58605)) * establish * orcl * 0


alert/log.xml
<msg time='2012-05-10T12:25:23.133+02:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='orcl-cluster'
host_addr='192.168.51.32'>
<txt>10-MAY-2012 12:25:23 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.150.104)(PORT=58605)) * establish * orcl * 0
</txt>
</msg>


Exactly from the documentation link you have pasted

subdirectory name content
alert XML-formatted alert log
trace text-formatted alert log


so what I want is to stop text-formated alert log and keep the xml-formated for any ADR home

Edited by: kamilp on May 10, 2012 3:35 AM
Aman....
Kamlip,

Check the documentation and in that, the parameter logging_listener_name .
http://docs.oracle.com/cd/E11882_01/network.112/e10835/listener.htm#NETRF1914

Aman....
713555
turn off ADR logging

http://docs.oracle.com/cd/E11882_01/network.112/e10835/cman.htm#CACEDJIC

then rotate the main log whenever you want.
Aman....
But Deebee, isn't this going to disable the entire logging happening in ADR?

Regards
Aman....
Karan
As mentioned above you can disable listener logging by refering the doc... It would be taking lot of space because of the fact it contains client connection requests, listener direct hand off information, also listener control utility commands, service registration events like register,update, died ... in oracle 11g by default listener log will go ADR which is set by ADR_BASE... listener log defaults to $ORACLE_BASE/diag/tnslsnr/hostname/listener/alert/log.xml.... you may for logging can toggle options in listener.ora like log_file_listener_name is the name for logfile.. by the way what is the LOG_DIRECTORY_listener_name value ??? btw it looks clearly tracing and logging both are enabled so it is inevitable it would eat space.. for recycling you may use any os config..

Regards
Karan
1 - 23
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 11 2012
Added on May 10 2012
23 comments
11,937 views