OraFAQ Forum: Server Administration » Problems with ORA-XXXXX Messages not in alert.log

Home » RDBMS Server » Server Administration » Problems with ORA-XXXXX Messages not in alert.log

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problems with ORA-XXXXX Messages not in alert.log [message #111870]

Mon, 21 March 2005 07:33

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi all,

We got a strange behaviour in one of our Oracle 9i (9.2.0.5) Databases. Some ORA-XXXX Messages are not inserted into the alert<SID>.log.
We saw this with Messages like ORA-01502: index 'CUSJDTA.OCUSMA00' or partition of such index is in unusable state

Why is this message not in our alert ? any hints welcome.

Uwe

Report message to a moderator

Re: Problems with ORA-XXXXX Messages not in alert.log [message #111874 is a reply to message #111870]

Mon, 21 March 2005 08:01

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

THe index is in unusable state.
check the status of the concerned index.
May be becuase of direct sqlload or something like that.

Report message to a moderator

Re: Problems with ORA-XXXXX Messages not in alert.log [message #111876 is a reply to message #111870]

Mon, 21 March 2005 08:04

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi Mahesh,

I know that this index is in unsuable state.
My question is : Why is this message not written down to alert.log ?
We always look into alert log and react on entries, but messages on this error are not written into alert.log from oracle.
Is there a log-level which we need to set ?

Uwe

Report message to a moderator

Re: Problems with ORA-XXXXX Messages not in alert.log [message #111877 is a reply to message #111876]

Mon, 21 March 2005 08:08

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

My apologies.
I missed the question.
Not all error messages are reported in the alertlog (specifically operational messages like this).
Mostly only ORA-600 errors and other specific messages (log switch, trace / core dump / process failure) are written to the log.

Report message to a moderator

Re: Problems with ORA-XXXXX Messages not in alert.log [message #111882 is a reply to message #111870]

Mon, 21 March 2005 08:17

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Thanks,
but there's no way to get them in ? I guess its a bad situation if an index is not valid. We have had this before and parts of the software won't work properly. We got this message out of an java-log from the application. But I like to get it from oracle as well.
Uwe

Report message to a moderator

Re: Problems with ORA-XXXXX Messages not in alert.log [message #111883 is a reply to message #111882]

Mon, 21 March 2005 08:29

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

pl/sql Builtin package ksdwrt ( which strictly internal to Oracle corp / OSS ) is supposed to that.
I beleive , it is already been requested to oracle to expose the package.

if you use the application frequently and you want to monitor those logs, there are two options that i always use.
1. a very simple shell script to scan the logs for all ORA messages
with include and exclude options and send an email.
This what you must be already doing.
2. make use of external tables.
you can treat the log file as an external oracle table.
frequently scan this table for messages.

Jared Still has written a great article about the same.
I have already posted it orafaq.com please search for it.

Report message to a moderator

Re: Problems with ORA-XXXXX Messages not in alert.log [message #111893 is a reply to message #111882]

Mon, 21 March 2005 10:47

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Just an update.
Seems ksdwrt is open to public now.

sys@mutation_mutation > exec dbms_system.ksdwrt(2,'My Message for customizatoin');

PL/SQL procedure successfully completed.

sys@mutation_mutation > !tail -2 alert_mutation.log
Mon Mar 21 10:41:27 2005
My Message for customizatoin

Report message to a moderator

Re: Problems with ORA-XXXXX Messages not in alert.log [message #111894 is a reply to message #111870]

Mon, 21 March 2005 10:51

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

But how will we force Oracle to put the message 1502 into the alert if it occurs ?
I am not sending this message on hand - it will be affected from Oracle ....

Report message to a moderator

Re: Problems with ORA-XXXXX Messages not in alert.log [message #111895 is a reply to message #111894]

Mon, 21 March 2005 11:25

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

this is not a server error.
so, the calling application needs to call this.
Else i beleive it is not possible.

Report message to a moderator

Re: Problems with ORA-XXXXX Messages not in alert.log [message #111948 is a reply to message #111870]

Tue, 22 March 2005 01:13

Frank
Messages: 7901
Registered: March 2000

Senior Member

You can tell Oracle to trace events. In the occasion one of the predefined (by you) events occurs, a dump-file is generated. See here for a short example.
Note: I don't know whether this is supported by Oracle. Setting events is usually meant to be guided by Support Staff personnel.

hth

Report message to a moderator

Re: Problems with ORA-XXXXX Messages not in alert.log [message #111959 is a reply to message #111870]

Tue, 22 March 2005 01:55

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Thanks Mahesh and Frank,

I will look what I could do here.
I think it will be not that easy to let the application raise the error. It is an "very" poor ERP System which normally deals with DB2 on AS/400 and the code is only parsed to Java and Oracle. So any programcode will not be developed by now.
But I will talk to the development guys
Thanks again
Uwe

Report message to a moderator

Previous Topic:	the way DBMS_METADATA.GET_DDL can get the object's ddl from sybase database ?
Next Topic:	When is a extent added?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 03:51:15 CST 2025