SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-06512: at "SYS.DBMS_IJOB",

458485Oct 13 2005 — edited Oct 14 2005

I am running a package in TEST it runs sucessfullky but in production is giving my this error

12:57:04 Info: Job #725 could not be executed. ORA-12011: execution of 1 jobs failed
ORA-06512: at "SYS.DBMS_IJOB", line 406
ORA-06512: at "SYS.DBMS_JOB", line 272
ORA-06512: at line 1

log
More info from alert log:

Errors in file /u01/app/oracle/admin/CONN/udump/conn_ora_22774.trc:
ORA-12012: error on auto execute of job 725
ORA-29282: invalid file ID
ORA-06512: at "SYS.UTL_FILE", line 714
ORA-06512: at "CONNMAN.CC_ADM_PROSPECT_PKG", line 2675
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 449
ORA-29283: invalid file operation
ORA-06512: at line 1

It looks like this started happening on Tuesday. The first of these errors occurred Tue Oct 11 10:00:06 2005.

Still working on it...

Any ideas?

Why it is okay in test and not in production, the job was running successfully until two days ago

I will appreciate any help

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 11 2005

Added on Oct 13 2005

6 comments

4,136 views