Oracle Database Discussions

What did you read in the documentation?
Your question doesn't make sense to me.
-------------
Sybrand Bakker
Senior Oracle DBA

Why do you want the same?

Anyways,.. below link would help you

1089481

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

>

this solution explains much about oracle developers and support team. LoL

I think this thread will go to my golden internet LOL resources
LMAO, oracle experts :)

 LMAO, oracle experts :)

Please refrain from putting such things here.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.

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

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.

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.

you are not bound to post "spam" to thread. so pleas stop doing it. post if you can answer.

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....

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

i think u can stop the logging to listener.log by issuing the following command...

lsnrctl set log_status off

try it...

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....

kamilp...

the alert log doesn't store information about the users connecting to it. It is the function of listener.log.

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

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....

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.

But Deebee, isn't this going to disable the entire logging happening in ADR?

Regards
Aman....

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