Oracle Database/ERP/Cloud/RAC/Misc Solutions

  ORA-20000: Unable to set values for index <INDEX_NAME> does not exist or insufficient privileges while importing schema from 12c to 19c Importing statistics failed for 1 object(s);  While importing Schema objects from 12c Oracle Database to 19c Oracle Database, we face the above issue CAUSE  This problem is fixed by unpublished BUG 27761685. SOLUTION To avoid the issue use the workaround: - Add include=index while executing expdp   and - Add include=statistics while executing impdp expdp USER_A/USER_A directory=test_dir dumpfile=exp_data.dmp include=statistics,index tables=btree_tbl reuse_dumpfiles=y impdp USER_B/USER_B directory=test_dir dumpfile=exp_data.dmp remap_schema=user_a:user_b include=statistics Reference: ORA-20000 Unable to Set Values for Index XX: Does Not Exist or Insufficient Priv is Raised While Executing Impdp (Doc ID 2176364.1)

 This blog will list the errors faced during Installation of Enterprise Manager 12c Cloud Control 1. :Error in invoking target 'install' of makefile '/u01/app/oracle/oms12cr3/oms/sqlplus/lib/ins_sqlplus.mk' INFO: End output from spawned process. INFO: ---------------------------------- INFO: Exception thrown from action: make Exception Name: MakefileException Exception String: Error in invoking target 'install' of makefile '/u01/app/oracle/oms12cr3/oms/sqlplus/lib/ins_sqlplus.mk'. See '/u01/app/oraInventory/logs/installActions2021-05-14_12-14-33-AM.log' for details. Exception Severity: 1 INFO: POPUP WARNING:Error in invoking target 'install' of makefile '/u01/app/oracle/oms12cr3/oms/sqlplus/lib/ins_sqlplus.mk'. See '/u01/app/oraInventory/logs/installActions2021-05-14_12-14-33-AM.log' for details. INFO: /usr/bin/ld: cannot find crt1.o: No such file or directory /usr/bin/ld: cannot find crti.o: No such file or directory /usr...