OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ALERT.LOG

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

ALERT.LOG [message #179894]

Thu, 29 June 2006 04:20

murtuja_oracle
Messages: 5
Registered: December 2005

Junior Member

all the errors and messages and events happeing in database are been recorded in database alert_log file....how is this happening which process is resonsible for this....?

Report message to a moderator

Re: ALERT.LOG [message #179897 is a reply to message #179894]

Thu, 29 June 2006 04:22

prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan

Member

SMON process

Report message to a moderator

Re: ALERT.LOG [message #179951 is a reply to message #179894]

Thu, 29 June 2006 06:43

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

Senior Member
Account Moderator

Not just SMON.
Any process can write to alert log and to it's own associated trace file.

sys@9i > !tail -3 $ORACLE_BASE/admin/mu*/bd*/al*
Wed Jun 28 15:44:06 2006
Thread 1 advanced to log sequence 212
  Current log# 2 seq# 212 mem# 0: /u01/app/oracle/oradata/mutation/redo02.log

sys@9i > exec dbms_system.ksdwrt(2,'Hello there. This is my message');

PL/SQL procedure successfully completed.

sys@9i > !tail -3 $ORACLE_BASE/admin/mu*/bd*/al*
  Current log# 2 seq# 212 mem# 0: /u01/app/oracle/oradata/mutation/redo02.log
Thu Jun 29 07:46:17 2006
Hello there. This is my message

Report message to a moderator

Re: ALERT.LOG [message #179953 is a reply to message #179951]

Thu, 29 June 2006 06:46

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Mahesh Rajendran wrote on Thu, 29 June 2006 06:43

sys@9i > exec dbms_system.ksdwrt(2,'Hello there. This is my message');

This can come in handy, thanks Mahesh !

Report message to a moderator

Re: ALERT.LOG [message #179956 is a reply to message #179953]

Thu, 29 June 2006 06:59

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

Senior Member
Account Moderator

yes it is~.
Destination can take a value of 1 (for trace file),2 (alert log),3 (both).

Report message to a moderator

Re: ALERT.LOG [message #179991 is a reply to message #179894]

Thu, 29 June 2006 10:47

tedd
Messages: 13
Registered: June 2006

Junior Member

can u plz give the abbreviation ksdwrt

Report message to a moderator

Re: ALERT.LOG [message #180025 is a reply to message #179991]

Thu, 29 June 2006 19:56

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

Senior Member
Account Moderator

>> can u plz give the abbreviation ksdwrt
I am sorry, i do not understand you.
ksdwrt is just a procedure with dbms_system (used to write to oracle alert log file).
If you are looking for rationale behind the naming convention, you should probably ask the folks at oracle.

http://www.google.com/search?complete=1&hl=en&q=dbms_system.ksdwrt&btnG=Google+Search

[Updated on: Thu, 29 June 2006 19:59]

Report message to a moderator

Previous Topic:	dbms_stats.gather_system_stats
Next Topic:	Unable to install oracle 9i database (R2)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:26:34 CDT 2024