ADJRIINITPASSWD.sql Fails With An ORA-01031 Error:
Error: Unable to execute statement <
Begin
ad_jar.get_jripasswords(:l_storepass, :l_keypass);
End;
> len = 63
AD Administration error:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 94
ORA-06512: at "APPS.AD_JAR", line 17
ORA-06512: at line 3
AD Administration error:
Unable to get passwords from Vault
Solution
Connect with apps schema.
[applmgr@oracle ~]$ sqlplus apps/******
SQL> create or replace context AD_JAR using AD_JAR;
Context created.
SQL> GRANT select on DBA_USERS_WITH_DEFPWD to SYSTEM with grant option;
Grant succeeded.
SQL> conn system/******
Connected.
SQL> GRANT select on DBA_USERS_WITH_DEFPWD to em_oam_monitor_role;
Grant succeeded.
Re-test issue.
No comments:
Post a Comment