dbTalk Databases Forums  

ADRCI in oracle 11.2.0.2

comp.databases.oracle.server comp.databases.oracle.server


Discuss ADRCI in oracle 11.2.0.2 in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mladen Gogala
 
Posts: n/a

Default ADRCI in oracle 11.2.0.2 - 09-02-2011 , 08:35 AM






I issued "show alert" command and the result showed me that I need to
clean things up:

2011-04-23 18:28:38.255000 -04:00
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0

......

I executed "purge -age 1440 -type alert" but nothing happened. The
records in the alert file are still there from April the 23d. My
understanding is that this is supposed to purge from alert log all
records older than 1440 minutes (1 day)? This does work for cores and
traces.

--
http://mgogala.byethost5.com

Reply With Quote
  #2  
Old   
Mladen Gogala
 
Posts: n/a

Default Re: ADRCI in oracle 11.2.0.2 - 09-02-2011 , 09:54 AM






On Fri, 02 Sep 2011 13:35:40 +0000, Mladen Gogala wrote:

Quote:
I issued "show alert" command and the result showed me that I need to
clean things up:

2011-04-23 18:28:38.255000 -04:00
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0

.....

I executed "purge -age 1440 -type alert" but nothing happened. The
records in the alert file are still there from April the 23d. My
understanding is that this is supposed to purge from alert log all
records older than 1440 minutes (1 day)? This does work for cores and
traces.
Manual purge (using vi) of log.xml and alert.log works like a charm.
However, that's not what I expected from adrci. It seems that I will not
yet give up my logrotate configuration.



--
http://mgogala.byethost5.com

Reply With Quote
  #3  
Old   
joel garry
 
Posts: n/a

Default Re: ADRCI in oracle 11.2.0.2 - 09-02-2011 , 01:00 PM



On Sep 2, 7:54Â*am, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:
Quote:
On Fri, 02 Sep 2011 13:35:40 +0000, Mladen Gogala wrote:
I issued "show alert" command and the result showed me that I need to
clean things up:

2011-04-23 18:28:38.255000 -04:00
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0

.....

I executed "purge -age 1440 -type alert" but nothing happened. The
records in the alert file are still there from April the 23d. My
understanding is that this is supposed to purge from alert log all
records older than 1440 minutes (1 day)? This does work for cores and
traces.

Manual purge (using vi) of log.xml and alert.log works like a charm.
However, that's not what I expected from adrci. It seems that I will not
yet give up my logrotate configuration.

--http://mgogala.byethost5.com
That's not a bug... Bug 6800147: ADRCI PURGE COMMAND DOESN'T WORK WHEN
DELETE ALERTLOG USING AGE OPTION

‽

Even more entertaining: Bug 12426625: ORACLE 11.2.0.2 CONFIGURATION,
ADRCI "SET CONTROL" AND "PURGE" DO NOT WORK

jg
--
@home.com is bogus.
71830 upside down means "retard" in Polish.

Reply With Quote
  #4  
Old   
Mladen Gogala
 
Posts: n/a

Default Re: ADRCI in oracle 11.2.0.2 - 09-02-2011 , 01:23 PM



On Fri, 02 Sep 2011 11:00:09 -0700, joel garry wrote:

Quote:
On Sep 2, 7:54Â*am, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:
On Fri, 02 Sep 2011 13:35:40 +0000, Mladen Gogala wrote:
I issued "show alert" command and the result showed me that I need to
clean things up:

2011-04-23 18:28:38.255000 -04:00
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0

.....

I executed "purge -age 1440 -type alert" but nothing happened. The
records in the alert file are still there from April the 23d. My
understanding is that this is supposed to purge from alert log all
records older than 1440 minutes (1 day)? This does work for cores and
traces.

Manual purge (using vi) of log.xml and alert.log works like a charm.
However, that's not what I expected from adrci. It seems that I will
not yet give up my logrotate configuration.

--http://mgogala.byethost5.com

That's not a bug... Bug 6800147: ADRCI PURGE COMMAND DOESN'T WORK WHEN
DELETE ALERTLOG USING AGE OPTION

‽

Even more entertaining: Bug 12426625: ORACLE 11.2.0.2 CONFIGURATION,
ADRCI "SET CONTROL" AND "PURGE" DO NOT WORK

jg



Well, alert log can be safely rotated using logrotate, but log.xml will
require some parsing. The purge command had no effect on log.xml, either.
Thanks Larry for the pathologically eclectic rubbish lister.
--
http://mgogala.byethost5.com

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.