After installing ARI 14.0 got error login to RMS as schema user (RMS14DEV).
A pop up error message is coming as below
"Error ORA-04067 not executed stored procedure PUBLIC.ARI_INTERFACE_SQL does not exist returned by program unit ari_interface_lib.get_is_ari_user"
Solution:
Perform step 1 and 2 if not done during installation of ARI.
1) Log into SQL *Plus as <RMS Schema Owner>
SQL> drop package ARI_INTERFACE_SQL;
2) Log into SQL *Plus as <master schema owner>
SQL> @user_syns.sql
When prompted for the user name, use <RMS Schema Owner>.
--> Create or replace synonym RMS14DEV.ARI_INTERFACE_SQL for ARI140M.ARI_INTERFACE_SQL
Re-creating the SYSNONMS, the login to RMS will be successful.
****************************Done***********************
No comments:
Post a Comment