Beginners Guide to Oracle Database Initialization Parameters
About Initialization Parameters Managing an Oracle instance includes configuring parameters that affect the basic …
Oracle
WARNING: Exec(): 0509-036 Cannot Load Program /App/12.2.0.1/Grid/Bin/Kfod.bin Durin Grid 12.2 Install on AIX
The Problem During 12.2.0.1 GI install on AIX 7.1, at OUI screen “create ASM disks”, asm disks are not …
"ORA-28365: Wallet Is Not Open" - While Running "RMAN DUPLICATE"
The Problem RMAN DUPLICATE fails with: ORA-00283: recovery session canceled due to errors ORA-28365: wallet is not open …
ORA-00257: Archiver Is Stuck. CONNECT INTERNAL Only, Until Freed
The Problem Your database is in archive log mode and archiving works fine until suddenly connecting via SQLPLUS …
How to Disable Oracle Database Auditing
What is Oracle Database Auditing? Auditing is the monitoring and recording of selected user database actions. It can be …
How to Create an Ocfs2 Volume With the Global Heartbeat Feature
Since ocfs2-1.8, global heartbeat feature is available. Earlier versions of OCFS2 had its own heartbeat for each mounted …
"ORA-00911: Invalid Character" - Error While Dropping or Renaming Tablespace Due to Junk Chracters
The Problem Not able to drop or rename a tablespace which is having junk characters in the name. For example:
Oracle Interview Questions - Datafile Autoextend Feature
This post aims to provide basic oracle database interview questions for the Datafile Autoextend feature. 1. How to know …
Understanding SMCO (Space Management Coordinator) Background Process in Oracle Database
The post dives into the basics of SMCO (Space Management Coordinator) Background Process in Oracle 11g and how to enable …