When running Database Configuration Assistant (dbca) on Exadata compute nodes, you will receive this error if all nodes cannot connect to each other without password …
Read More »ORACLE
How To Enable and Disable Unified Auditing Feature in Oracle
Enable Unified Auditing Relink is required to enable the new audit mechanism announced with Oracle database 12c (12.1). You can do this as follows. First, …
Read More »“gc buffer busy acquire” Wait Event in AUD$ insert operations
Because the segment space management of the tablespace of the AUD$ and FGA_LOG$ tables is not automatic, a “gc buffer busy acquire” wait event can …
Read More »How To Move AUD$ and FGA_LOG$ to a Different Tablespace
The AUD$ and FGA_LOG$ tables used for audit recordings are in the SYSTEM tablespace by default. SYSTEM tablespace is a tablespace with manual segment space …
Read More »Disabling Diagsnap Error “LoggerD Error connecting with node X”
When you want to disable the diagsnap feature that introduced with Oracle 12c Grid Infrastructure, ologgerd causes an error like “LoggerD –> Error connecting with …
Read More »OPatch failed with error code 134
In opatch operations, if the corresponding home is not included in the ORACLE_HOME parameter, all opatch related commands cause 134 errors. To avoid this error, …
Read More »How To Migrate From BasicFiles to SecureFiles
SecureFiles LOB storage is one of two storage types used with Oracle databases; the other type is BasicFiles LOB storage. Some advanced features, including compression …
Read More »What tasks remain for the DBAs After Oracle Autonomous Database(19c)?
These are the tasks for which DBAs required in a database industry. Defining the database architecture Creating data models Integrating new data sources Tuning business …
Read More »Oracle Autonomous Database Will Diminish DBAs Job? (Yes Or No)
Oracle Autonomous Database is the world’s only data management system to automatically patch, upgrade, and tune itself. It handles routine database maintenance tasks while the system …
Read More »How To Export a Table Without Blob Column in Oracle
It is possible to export a table containing BLOB data without data in the blob column. Starting with 11g r2, REMAP_DATA can be used with …
Read More »