Posts by Kishore Kumar Ravichandran

How to resolve ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K 16K or 32K errors

APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.3 and later GOAL: This note helps in how to use multiple cache size for tablespaces with different block size i.e…

Read More

Autoconfig issue with s_applptmp after database upgrade to 19c

APPLIES TO: Oracle Applications DBA - Version 12.1.3 to 12.2.9 [Release 12.1 to 12.2] SYMPTOMS: Autoconfig failed in application tier node after upgrading database to 19c on setting s_applptmp context…

Read More

ASM Fails to Start with ORA-4031: unable to allocate 16416 bytes of shared memory (“shared pool”,”unknown object”,”sga heap(1,0)”,”dbktb: trace buffer”)

APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.1 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A…

Read More

OPatch Cannot Continue Because it Would not be Able to Load OUI Platform Dependent Library from the Directory “$ORACLE_HOME/oui/lib/linux”

APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.4 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version…

Read More

RMAN DUPLICATE without TARGET fails with RMAN-03002 / RMAN-06171

APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.1 and later SYMPTOMS: Database Names: UAT RMAN DUPLICATE without TARGET fails with RMAN-03002 / RMAN-06171 : $ rman auxiliary /…

Read More

R12 E-Business Suite Applications Manager Clone Process Fails With Error ‘AC-50006: Could not assign any APPL_TOP name to this instance’ When Running Adcfgclone.pl AppsTier On An Environment

APPLIES TO: Oracle Applications Manager - Version 12.1.3 and later SYMPTOMS: E-Business Suite R12 Applications Manager, Rapidclone related issues java.lang.Exception: AC-50006: Could not assign any APPL_TOP name to this instance.…

Read More

Opmnctl Process Hangs During Installation and Cloning Due to a Bug in the Opmnctl Script

Environment: Oracle Fusion Middleware - Version 10.1.3.1.0 to 10.1.3.3.0 [Release AS10gR3] Symptoms: The opmnctl process hangs and goes into a loop, executing opmnctl repeatedly and thereby increasing the number of…

Read More

Invalid OLAP Objects GENMETADATAPROVIDERINTERFACE

Environment: Oracle OLAP – Version 11.2.0.3 and later Symptoms: OLAP is valid in dba_registry but the following OLAP objects are invalid: SQL> select owner,object_name,object_type from dba_objects where status=’INVALID’ order by…

Read More

OCI VMDB Automatic Backup Failed With DCS-10434:Control file and/or spfile handles could not be retrieved from rman logs

APPLIES TO: Oracle Cloud Infrastructure - Database Service - Version N/A and later SYMPTOMS: OCI VMDB system automatic backup failed with DCS-10434:Control file and/or spfile handles could not be retrieved…

Read More

How to validate CATALOG And CATPROC in Multitenant environment

APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2] Oracle Database Cloud Schema Service - Version N/A and later Gen 1 Exadata Cloud…

Read More