Home » RDBMS Server » Enterprise Manager » EM SCHEMA TABLE UPDATE AND INSERT ERROR
EM SCHEMA TABLE UPDATE AND INSERT ERROR [message #303472] Fri, 29 February 2008 08:28 Go to next message
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 #303494 is a reply to message #303472] Fri, 29 February 2008 10:28 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Is any body there, who could share the information regarding the above error
Re: EM SCHEMA TABLE UPDATE AND INSERT ERROR [message #303570 is a reply to message #303472] Fri, 29 February 2008 17:14 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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

Re: EM SCHEMA TABLE UPDATE AND INSERT ERROR [message #304447 is a reply to message #303902] Wed, 05 March 2008 04:14 Go to previous message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
So anybody know the solution
Previous Topic: error on install: Encountered error 'Error in invoking target 'dm_on ioracle'
Next Topic: DBConsole Error
Goto Forum:
  


Current Time: Thu Mar 28 12:48:28 CDT 2024