| EM SCHEMA TABLE UPDATE AND INSERT ERROR [message #303472] |
Fri, 29 February 2008 08:28  |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
I have trigger, which mail me whenever there is any error occured in database.
Whenever i activated this trigger it start giving me error ORA-1, uPDATE MGMT_HD sometihing (Tables of Sysman schema).
But neither i am inserting or updating any thing in EM schema. So how to stop This
Every thing is running fine
I am experiencing this problem in Oracle 10g relaease 2 (10.2.0.3 in 64 bit Linux) and also in (10.2.0.1 in 32 bit)
When i Stop the em controller from following command it stop sending this error
emctl stop dbconsole
|
|
|
|
|
|
| Re: EM SCHEMA TABLE UPDATE AND INSERT ERROR [message #303570 is a reply to message #303472] |
Fri, 29 February 2008 17:14  |
rhziaDBA
Messages: 17
Registered: February 2008
Location: Madrid
|
Junior Member |
|
|
Provide me the output of the comand
emctl status dbconsole
run the following query
SELECT OBJECT_NAME,OBJECT_TYPE,STATUS
FROM DBA_OBJECTS
WHERE OWNER='SYSMAN'
AND
OBJECT_TYPE='TRIGGER'
Send me the results of this query
Why you have a trigger?
What is the code of this trigger?
Regards
|
|
|
|
| Re: EM SCHEMA TABLE UPDATE AND INSERT ERROR [message #303902 is a reply to message #303570] |
Mon, 03 March 2008 03:31 |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
JOB_TARGET_INSERT_TRIGGER TRIGGER VALID
JOB_TARGET_DEL_TRIGGER TRIGGER VALID
MGMT_JOB_EXEC_INSERT TRIGGER VALID
MGMT_JOB_EXEC_UPDATE TRIGGER VALID
JOB_CMD_BLK_DELETE_TRIGGER TRIGGER VALID
JOB_EXEC_DELETE_TRIGGER TRIGGER VALID
JOB_EXEC_UPDATE_TRIGGER TRIGGER VALID
MGMT_JOB_PARAM_INSERT TRIGGER VALID
MGMT_JOB_PARAM_DELETE TRIGGER VALID
SEVERITY_DELETE TRIGGER VALID
METRICS_SEVERITY_DUPLICATES TRIGGER VALID
MGMT_SEVERITY_UPDATES TRIGGER VALID
SEV_ANNOTATION_INSERT_TR TRIGGER VALID
SEV_ANNOTATION_DELETE_TR TRIGGER VALID
MASTER_AGENT_CHANGE_TRIGGER TRIGGER VALID
METRICS_INSERT_TRIGGER TRIGGER VALID
METRICS_DELETE TRIGGER VALID
TARGET_PROP_DEFS_TR TRIGGER VALID
TARGETS_INSERT_TRIGGER TRIGGER VALID
TARGETS_AVAILABILITY_DEFAULT TRIGGER VALID
CHECK_DUPLICATE_TARGETS TRIGGER VALID
EM_TARGETS_DELETE TRIGGER VALID
RAW_METRICS_AFTER_INSERT TRIGGER VALID
METRIC_ERRORS_CUR_AND_DUPES TRIGGER VALID
BLACKOUT_CHANGE TRIGGER VALID
BLACKOUT_STATUS TRIGGER VALID
INSERT_FLAT_TARGETS TRIGGER VALID
UPDATE_SOURCE TRIGGER VALID
BLACKOUT_WINDOW_INSERT TRIGGER VALID
HANDLE_RELATED_TARGETS TRIGGER VALID
MGMT_METRIC_COLL_INS TRIGGER VALID
MGMT_METRIC_COLL_DEL TRIGGER VALID
MGMT_CREDS_UPD TRIGGER VALID
MGMT_CREDS_INS_UPD TRIGGER VALID
MGMT_TARGET_CREDS_DEL TRIGGER VALID
MGMT_HOST_CREDS_DEL TRIGGER VALID
MGMT_CONT_CREDS_DEL TRIGGER VALID
MGMT_ENT_CREDS_DEL TRIGGER VALID
MGMT_JOB_CREDS_DEL TRIGGER VALID
MEMBERSHIPS_INSERT_TRIGGER TRIGGER VALID
MEMBER_ADDITION_TRIGGER TRIGGER VALID
MEMBER_DELETION_TRIGGER TRIGGER VALID
EXECPLAN_DELETE_TRIGGER TRIGGER VALID
JOB_SUMM_INS_TRIGGER TRIGGER VALID
JOB_DELETE_TRIGGER TRIGGER VALID
SPACE_METRICS_PURGE_TRIGGER TRIGGER VALID
MGMT_DB_HDM_METRIC_TR TRIGGER VALID
MGMT_SQL_METRIC_TR TRIGGER VALID
Trigger is in SYS SCHEMA.
I am using trigger to have an email whenever there is any error in database.
It is sending me the error, following is the trigger contents
CREATE OR REPLACE TRIGGER mail_errors AFTER SERVERERROR ON DATABASE
declare
mail_conn utl_smtp.connection;
l_text ora_name_list_t;
--l_n number;
l_string long;
l_sql_text ora_name_list_t;
l_n number;
l_errcd number:= ora_server_error(1);
BEGIN
l_n := ora_sql_txt(l_sql_text);
for i in 1 .. l_n
loop
l_string := l_string || l_sql_text(i);
end loop;
mail_conn :=utl_smtp.open_connection(<SMTP IP>,25);
utl_smtp.helo(mail_conn,<SMTP IP>);
utl_smtp.mail(mail_conn,'m@ABC.com');
utl_smtp.rcpt(mail_conn,'m@ABC.com');
utl_smtp.data(mail_conn,'WARNING ORACLE DATABASE ERROR ORA-'||l_errcd||' ENCOUNTERED IN TEST DATABASE'||'Statement is: '||l_string);
utl_smtp.quit(mail_conn);
END;
Regards,
MIFI
[Updated on: Mon, 03 March 2008 03:41] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
