| fake an alert log in EM [message #406929] |
Sun, 07 June 2009 16:44  |
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 #406936 is a reply to message #406929] |
Sun, 07 June 2009 19:43  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
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 |
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 ,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
