Home » RDBMS Server » Enterprise Manager » fake an alert log in EM
fake an alert log in EM [message #406929] Sun, 07 June 2009 16:44 Go to next message
casttree
Messages: 83
Registered: August 2008
Member
I hope to fake a alter log and monitor it in EM with "alert log" of "Diagnostic Summary" of DB home page.

Should I manually add some faked message like "ORA-00942 TEST" in work/alter_$SID.log? looks like it is not working.

Any suggestions for this?

Thanks
Re: fake an alert log in EM [message #406931 is a reply to message #406929] Sun, 07 June 2009 18:00 Go to previous messageGo to next message
BlackSwan
Messages: 21942
Registered: January 2009
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

>looks like it is not working.
"not working" is 100% not helpful & is not a valid Oracle message or response

http://www.oracle.com/technology/oramag/code/tips2003/011203.html

[Updated on: Sun, 07 June 2009 18:09]

Report message to a moderator

Re: fake an alert log in EM [message #406935 is a reply to message #406931] Sun, 07 June 2009 19:32 Go to previous messageGo to next message
casttree
Messages: 83
Registered: August 2008
Member
Following the link http://www.oracle.com/technology/oramag/code/tips2003/011203.html

I run
SQL> execute sys.dbms_system.ksdwrt(2,to_char(sysdate)|| 'ORA-06512: test for alert');

but I haven't found there is record for "Alert Log" in DB home page "Diagnostic Summary"

like below. Can I check some point to ensure the data is correct?


Diagnostic Summary
ADDM Findings 0
Alert Log No ORA- errors
Active Incidents 0
Re: fake an alert log in EM [message #406936 is a reply to message #406929] Sun, 07 June 2009 19:43 Go to previous messageGo to next message
BlackSwan
Messages: 21942
Registered: January 2009
Senior Member
PEBKAC

SQL> !tail -6 /u01/app/oracle/admin/v102/bdump/alert_v102.log
Database Characterset is AL32UTF8
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 2
replication_dependency_tracking turned off (no async multimaster replication found)
WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.
Completed: ALTER DATABASE OPEN

SQL>  execute sys.dbms_system.ksdwrt(2,to_char(sysdate)|| 'ORA-06512: test for alert');

PL/SQL procedure successfully completed.

SQL> !tail -6 /u01/app/oracle/admin/v102/bdump/alert_v102.log
where NUMA PG = 1, CPUs = 2
replication_dependency_tracking turned off (no async multimaster replication found)
WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.
Completed: ALTER DATABASE OPEN
Sun Jun  7 17:41:39 2009
07-JUN-09ORA-06512: test for alert


Those who live by the GUI, die by the GUI.

[Updated on: Sun, 07 June 2009 19:49]

Report message to a moderator

Re: fake an alert log in EM [message #406973 is a reply to message #406936] Mon, 08 June 2009 01:37 Go to previous message
casttree
Messages: 83
Registered: August 2008
Member
Yes, I can see the test message in my host alter log too, but can't see it from UI (EM DB home page). that is what I need to work with.

I hope to generate the alter log which can be shown in EM home page , under the section " Diagnostic Summary", and next to ADDM Findings.

Do they need special log to show on EM home page? (looks they need ORA-ERROR, that is I try to add some ORA message, but not sure if they require special format? )

The format in DB home page like below
Quote:

Diagnostic Summary


ADDM Findings 0
Alert Log No ORA- errors
Active Incidents 0



Thanks ,
Previous Topic: Need guide line creating Replicate via OEM step by step
Next Topic: How to create snmp_rw.ora
Goto Forum:
  


Current Time: Fri Apr 18 12:11:51 CDT 2014

Total time taken to generate the page: 0.08443 seconds