ORA errors

ERROR: Cannot find component oracle.jdk. ERROR: Cannot find components specified in JRE_COMPONENT=oracle.jdk, oracle.jre. ERROR: Installer execution failed (1). during OEM upgrade from 13.3 to 13.4

Dear Reader, Recently I was upgrading OEM from 13.3 to 13.4. Running em13400_<OS>_ppc64.bin was failing with below error: my-emserver1:./em13400_aix_ppc64.binERROR: Temporary directory /tmp does not have enough free space. At least 12289 MB of free space are required.Please input another directory or [Exit]: /nfs/db_config/oem/tmpcaution: excluded filename not matched: sfx.iniERROR: Cannot find […]

Drop empty tablespace fails with ORA-14404 or ORA-144047 partitioned table contains partitions/subpartitions in a different tablespace

Recently I was performing database reorg operation on one of pre-prod environment with traditional way of table/lob movement followed by index rebuild. After moving all segments from current tablespace to new, I was ready to drop original one. SQL> select count(0) from dba_segments where tablespace_name=’MY_TABLESPACE’;   COUNT(0) ———-      […]

ORA-01450: maximum key length (6398) exceeded while creating index

Interesting issue happened today, while creating index in database(running DB on Linux), I got ORA-01450: maximum key length (6398) exceeded. Connected to: Oracle Database 11g Enterprise Edition Release – 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> CREATE INDEX […]

OUI-67073:UtilSession failed: Prerequisite check “CheckActiveFilesAndExecutables” failed on Windows server

Few days back, I was applying OPatch on one of the database residing on windows server. I tried it multiple times without any luck as everytime when I tried applying patch, I was getting below error: OUI-67073:UtilSession failed: Prerequisite check “CheckActiveFilesAndExecutables” failed. This was due to some of the DLL […]