Oracle Database/ERP/Cloud/RAC/Misc Solutions: May 2021

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/bin/ld: cannot find -lclntsh

/usr/bin/ld: cannot find -lc

/usr/bin/ld: cannot find crtn.o: No such file or directory

Solution:

Install glibc-devel package

[root@oel8a ~]# yum install glibc-devel*

Oracle Linux 8 EPEL Packages for Development (x86_64) 1.9 kB/s | 2.5 kB 00:01

Oracle Linux 8 EPEL Packages for Development (x86_64) 601 kB/s | 16 MB 00:27

Last metadata expiration check: 0:00:15 ago on Fri 14 May 2021 12:30:16 AM +03.

Package glibc-devel-2.28-42.0.1.el8.x86_64 is already installed.

Dependencies resolved.

==================================================================================================================================================================================================

Package Arch Version Repository Size

==================================================================================================================================================================================================

Upgrading:

glibc-devel x86_64 2.28-127.0.3.el8_3.2 ol8_baseos_latest 1.0 M

glibc-langpack-en x86_64 2.28-127.0.3.el8_3.2 ol8_baseos_latest 825 k

glibc-headers x86_64 2.28-127.0.3.el8_3.2 ol8_baseos_latest 477 k

libnsl x86_64 2.28-127.0.3.el8_3.2 ol8_baseos_latest 100 k

glibc-common x86_64 2.28-127.0.3.el8_3.2 ol8_baseos_latest 1.3 M

glibc x86_64 2.28-127.0.3.el8_3.2 ol8_baseos_latest 3.6 M

Transaction Summary

==================================================================================================================================================================================================

Upgrade 6 Packages

Total download size: 7.3 M

Is this ok [y/N]: y

Downloading Packages:

(1/6): glibc-headers-2.28-127.0.3.el8_3.2.x86_64.rpm 120 kB/s | 477 kB 00:03

(2/6): libnsl-2.28-127.0.3.el8_3.2.x86_64.rpm 238 kB/s | 100 kB 00:00

(3/6): glibc-langpack-en-2.28-127.0.3.el8_3.2.x86_64.rpm 165 kB/s | 825 kB 00:05

(4/6): glibc-devel-2.28-127.0.3.el8_3.2.x86_64.rpm 199 kB/s | 1.0 MB 00:05

(5/6): glibc-common-2.28-127.0.3.el8_3.2.x86_64.rpm 303 kB/s | 1.3 MB 00:04

(6/6): glibc-2.28-127.0.3.el8_3.2.x86_64.rpm 430 kB/s | 3.6 MB 00:08

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Total 549 kB/s | 7.3 MB 00:13

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

Preparing : 1/1

Upgrading : glibc-common-2.28-127.0.3.el8_3.2.x86_64 1/12

Running scriptlet: glibc-2.28-127.0.3.el8_3.2.x86_64 2/12

Upgrading : glibc-2.28-127.0.3.el8_3.2.x86_64 2/12

Running scriptlet: glibc-2.28-127.0.3.el8_3.2.x86_64 2/12

warning: /etc/nsswitch.conf created as /etc/nsswitch.conf.rpmnew

Upgrading : glibc-langpack-en-2.28-127.0.3.el8_3.2.x86_64 3/12

Running scriptlet: glibc-headers-2.28-127.0.3.el8_3.2.x86_64 4/12

Upgrading : glibc-headers-2.28-127.0.3.el8_3.2.x86_64 4/12

Upgrading : glibc-devel-2.28-127.0.3.el8_3.2.x86_64 5/12

Running scriptlet: glibc-devel-2.28-127.0.3.el8_3.2.x86_64 5/12

Upgrading : libnsl-2.28-127.0.3.el8_3.2.x86_64 6/12

Running scriptlet: glibc-devel-2.28-42.0.1.el8.x86_64 7/12

Cleanup : glibc-devel-2.28-42.0.1.el8.x86_64 7/12

Cleanup : libnsl-2.28-42.0.1.el8.x86_64 8/12

Cleanup : glibc-headers-2.28-42.0.1.el8.x86_64 9/12

Cleanup : glibc-common-2.28-42.0.1.el8.x86_64 10/12

Cleanup : glibc-langpack-en-2.28-42.0.1.el8.x86_64 11/12

Cleanup : glibc-2.28-42.0.1.el8.x86_64 12/12

Running scriptlet: glibc-2.28-42.0.1.el8.x86_64 12/12

Running scriptlet: glibc-common-2.28-127.0.3.el8_3.2.x86_64 12/12

Verifying : glibc-devel-2.28-127.0.3.el8_3.2.x86_64 1/12

Verifying : glibc-devel-2.28-42.0.1.el8.x86_64 2/12

Verifying : glibc-langpack-en-2.28-127.0.3.el8_3.2.x86_64 3/12

Verifying : glibc-langpack-en-2.28-42.0.1.el8.x86_64 4/12

Verifying : glibc-headers-2.28-127.0.3.el8_3.2.x86_64 5/12

Verifying : glibc-headers-2.28-42.0.1.el8.x86_64 6/12

Verifying : libnsl-2.28-127.0.3.el8_3.2.x86_64 7/12

Verifying : libnsl-2.28-42.0.1.el8.x86_64 8/12

Verifying : glibc-common-2.28-127.0.3.el8_3.2.x86_64 9/12

Verifying : glibc-common-2.28-42.0.1.el8.x86_64 10/12

Verifying : glibc-2.28-127.0.3.el8_3.2.x86_64 11/12

Verifying : glibc-2.28-42.0.1.el8.x86_64 12/12

Upgraded:

glibc-devel-2.28-127.0.3.el8_3.2.x86_64 glibc-langpack-en-2.28-127.0.3.el8_3.2.x86_64 glibc-headers-2.28-127.0.3.el8_3.2.x86_64 libnsl-2.28-127.0.3.el8_3.2.x86_64

glibc-common-2.28-127.0.3.el8_3.2.x86_64 glibc-2.28-127.0.3.el8_3.2.x86_64

Complete!

[root@oel8a ~]#

Reference:

EM 12c: Enterprise Manager 12c Cloud Control OMS Installation on SUSE Linux 11 Fails with Message: Error in invoking target 'install' of makefile (Doc ID 1503554.1)

I have installed the glibc-devel and also ignored the errors. I was able to successfully install the OEM 12c Cloud Control

Oracle Database/ERP/Cloud/RAC/Misc Solutions

Wednesday, 19 May 2021

ORA-20000: Unable to set values for index does not exist or insufficient privileges while importing schema from 12c to 19c

CAUSE

SOLUTION

Friday, 14 May 2021

Errors while Installing 12c EM Cloud Control

XX_XXXXXXX is not a valid responsibility for the current user. Please contact your System Administrator.

Report Abuse