ORA errors

Applying OJVM July 2021 patch(32876380) on GI HOME fails with “ArchiveAction: Destination File “$GI_HOME/lib/lib*****.a” does not exists or is not writeable” & “ApplySession::apply failed: mv: 0653-401 Cannot rename $GI_HOME/lib/lib*****.so”

Dear Readers, In this post, I am going to write about the issue I faced while patching GI HOME with July 2021 OJVM patch(32876380) post applying July 2021 GI RU patch(32904851). I had a requirement to apply patch 32900083 (GI RU & OJVM Combo July 2021) on GI HOME, which […]

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 11.2.0.4 DB on Linux), I got ORA-01450: maximum key length (6398) exceeded. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 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 […]