Job breaks after upgrade from 10.2.0.3 to 11.1.0.7
- From: "Schauss, Peter (IT Solutions)" <peter.schauss@xxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Jul 2010 08:53:38 -0500
I upgraded an instance of 10.2.0.3 (Windows 2003 sp2) to 11.1.0.7 by
creating a new instance, recreating users, and importing the application
schema. Now a job which ran under 10.2.0.3 breaks.
From DBA_JOBS:
log_user= SYSTEM
priv_user=SYSTEM
schema_user=<application schema>
what=<schema>.<package>.<procedure> (package is valid)
The job breaks with:
ORA-12012: error on auto execute of job 5
ORA-06550: line 1, column 102:
PLS-00904: insufficient privilege to access object <schema>.<package>
ORA-06550: line 1, column 96:
PL/SQL: Statement ignored
The package is owned by the job's schema_user.
What privilege am I missing?
Thanks,
Peter Schauss
--
//www.freelists.org/webpage/oracle-l
Other related posts:
