Return
-
Title
ORA_SETUP fails on Linux due to Failed to create compare package. -
Description
Ora_setup fails with the following message:
Loading Compare Package from "/u01/app/shareplex/prod/.app-modules/../util/sp_deq_pkg.plb".../u01/app/shareplex/prod/.app-modules/ora_setup: --Failed to create compare package.
SQL> DROP USER splex CASCADE
OCIStmtExecute: Oracle error ORA-01940: cannot drop a user that is currently connected -
Cause
Shareplex oracle user did not have execution privilege against DBMS_LOB -
Resolution
Steps to find out the root cause:
1. cd $SP_SYS_PRODDIR/util
2. sqlplus <splex_user>/<splex_password>
3. @sp_deq_pkg.plb
4. show error
>> DBMS_LOB will be reported as invalid identifier.
5. Query: select object_name, object_type, owner from dba_objects where object_name='DBMS_LOB';
6. grant execute DBMS_LOB to <shareplex_user>
7 run ora_setup again