Wednesday, 10 November 2010

Error - PLS-00302: component ‘IS_PATCH_APPLIED2′ must be declared

When attempting to apply Patch 9935935 in 11i CU2 instance on Linux box, the following error occurs

AutoPatch error:
Error while executing statement

AutoPatch error:
ORA-06550: line 3, column 10:
PLS-00302: component ‘IS_PATCH_APPLIED2′ must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored

The issue is caused by the following setup:

Following package versions for package APPS.AD_PATCH are not created.
$AD_TOP/patch/115/sql adphpchb.pls   115.16
$AD_TOP/patch/115/sql adphpchs.pls   115.11

To implement the solution, please execute the following steps:
1. Go to $AD_TOP/patch/115/sql
2. Check the version of adphpchs.pls and adphpchb.pls
adident Header $AD_TOP/patch/115/sql/adphpch*.pls
It should be -
$AD_TOP/patch/115/sql/adphpchs.pls (version 115.11)
$AD_TOP/patch/115/sql/adphpchb.pls (version 115.16)

3. If it is not there, run them from /ad/patch/115/sql
4. Once the proper versions are available, run them from sqlplus as APPS user
SQL> @adphpchs.pls
SQL> @adphpchb.pls

5. Check the version and status once again
SQL> select status, object_type, owner from dba_objects where object_name = ‘AD_PATCH’;
SQL> select text from dba_source where line = 2 and name = ‘AD_PATCH’;

6. Retest adpatch from beginning
7. Migrate the solution to appropriate environment


SocialTwist Tell-a-Friend

Related Posts by Categories

No comments: