ADADMIN With Error "PLS-00201: identifier 'AD_JAR.GET_JRIPASSWORDS' must be declared"
While running ADOP / ADPATCH the below error occurs:
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] : *****
AutoPatch is verifying your username/password.
Connecting to APPS......Connected successfully.
Error: Unable to execute statement <
Begin
ad_jar.get_jripasswords(:l_storepass, :l_keypass);
End;
> len = 63
AutoPatch error:
ORA-06550: line 3, column 1:
PLS-00201: identifier 'AD_JAR.GET_JRIPASSWORDS' must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored
AutoPatch error:
Unable to get passwords from Vault
Possible Reasons:
The AD_JAR object not available in apps schema.
SQL> desc AD_JAR
ERROR:
ORA-04043: object AD_JAR does not exist
Solution:
1. Please login as applmgr (Unix user that own application binaries )
2. Source the application environment file . (APPS.env)
3. cd $AD_TOP/patch/115/sql/
4. Login to database as apps database user and run below 2 SQL's
@ADJRIS.pls
@ADJRIB.pls
5. Run the below SQL to see whether objects are valid
select owner,object_type,status from dba_objects where object_name='AD_JAR';
