ORA-00600 With kgassg_2 Parameter

Today appeared the following error in the alert.log;

10-JUL-2015 08:00:14.83:
Errors in file $1$DGA352:[ORCL.][USER]JUPITER_ORCL_FG_ORACLE_337.TRC;:
ORA-00600: cdigo de error interno, argumentos: [kgassg_2], [], [], [], [], [],?

10-JUL-2015 08:01:08.84:
Errors in file $1$DGA352:[ORCL.][USER]JUPITER_ORCL_FG_ORACLE_337.TRC;:
ORA-00600: cdigo de error interno, argumentos: [kgassg_2], [], [], [], [], [],?
ORA-20000: No se ha podido enviar el mensaje de correo.

10-JUL-2015 08:01:18.63:
Errors in file $1$DGA352:[ORCL.][USER]JUPITER_ORCL_FG_ORACLE_337.TRC;:
ORA-12012: error en la ejecucin automtica del trabajo 5322610
ORA-20000: No se ha podido enviar el mensaje de correo.
ORA-06512: en "MARK.PRCDR_SEND_MAIL", lnea 57
ORA-06512: en "MARK.PRCDR_REFRESH_DATA_TO_TEST", lnea 123
ORA-06512: en lnea 1

It is a bug, namely 821373, in this case is specific to the OpenVMS platform. It occurs when job is sending multiple emails. The solution is to apply the patch. As a workaround dbms_job must not use the fact this package tends to disappear, you must use DBMS_SCHEDULER.

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s