Re: Job breaks after upgrade from 10.2.0.3 to 11.1.0.7
- From: Pavel Ermakov <ocp.pauler@xxxxxxxxx>
- To: peter.schauss@xxxxxxx
- Date: Thu, 29 Jul 2010 18:03:29 +0400
Hi
What is procedure do? Post code of procedure.
Best regards,
Pavel Ermakov.
2010/7/29 Schauss, Peter (IT Solutions) <peter.schauss@xxxxxxx>
> 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:
