Patch Fails With Ora-20001: Updating Pa_projects_all:Ora-04063: Package
ERROR
Patch fails with ora-20001: updating pa_projects_all:ora-04063: package
sqlplus -s APPS
sqlplus -s APPS/*****
&batchsize 1 8
DECLARE
*
ERROR at line 1:
ORA-20001: Updating pa_proj_elem_ver_structure:ORA-04063: package body
"APPS.PA_PROJ_TASK_STRUC_PUB" has errors
ORA-06512: at line 141
Cause:
The issue is the package PA_PROJ_TASK_STRUC_PUB was invalid.
*
ERROR at line 1:
ORA-04043: object PA_PROJ_TASK_STRUC_PUB does not exist
Solution:
To implement the solution, please execute the following steps:
1) Run APPSORA.env
2) Compile the package PA_PROJ_TASK_STRUC_PUB.
3) Run the sql's manually
$ sqlplus apps/apps @paupgr46.sql
SQL*Plus: Release 8.0.6.0.0 - Production on Wed Sep 13 10:29:31 2006
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Enter value for 3: 1
Enter value for 4: 1
Enter value for 1: PA
Enter value for 2: 100
PL/SQL procedure successfully completed.
$ sqlplus apps/apps @paupgr72.sql
SQL*Plus: Release 8.0.6.0.0 - Production on Wed Sep 13 10:29:31 2006
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Enter value for 3: 1
Enter value for 4: 1
Enter value for 1: PA
Enter value for 2: 100
PL/SQL procedure successfully completed.
Reference metalink Doc ID 391271.1
ERROR
Patch fails with ora-20001: updating pa_projects_all:ora-04063: package
sqlplus -s APPS
sqlplus -s APPS/*****
&batchsize 1 8
DECLARE
*
ERROR at line 1:
ORA-20001: Updating pa_proj_elem_ver_structure:ORA-04063: package body
"APPS.PA_PROJ_TASK_STRUC_PUB" has errors
ORA-06512: at line 141
Cause:
The issue is the package PA_PROJ_TASK_STRUC_PUB was invalid.
*
ERROR at line 1:
ORA-04043: object PA_PROJ_TASK_STRUC_PUB does not exist
Solution:
To implement the solution, please execute the following steps:
1) Run APPSORA.env
2) Compile the package PA_PROJ_TASK_STRUC_PUB.
3) Run the sql's manually
$ sqlplus apps/apps @paupgr46.sql
SQL*Plus: Release 8.0.6.0.0 - Production on Wed Sep 13 10:29:31 2006
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Enter value for 3: 1
Enter value for 4: 1
Enter value for 1: PA
Enter value for 2: 100
PL/SQL procedure successfully completed.
$ sqlplus apps/apps @paupgr72.sql
SQL*Plus: Release 8.0.6.0.0 - Production on Wed Sep 13 10:29:31 2006
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Enter value for 3: 1
Enter value for 4: 1
Enter value for 1: PA
Enter value for 2: 100
PL/SQL procedure successfully completed.
Reference metalink Doc ID 391271.1
No comments:
Post a Comment