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 »ORACLE
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 »How To Check Undo Tablespace Usage in Oracle
Undo tablespace is extremely used during peak times. There is a possibility that some operations may be interrupted if you go uncontrolled. You should regularly …
Read More »Are You Ready for the Oracle Database 19c Administration Certification?
Why DBA should pass the Oracle Database 19c OCP exam? DBA should get ready for new features & they should test themselves through latest certification. …
Read More »How To Setup Passwordless ssh in Exadata Using dcli
Although passwordless ssh connection is established between compute node and cell nodes in the Exadata installation, this connection can be broken due to some problems. …
Read More »How To Find Wasted Space in Table in Oracle
Gaps occur in the blocks due to deletion operations in the tables. These spaces remain as wasted space. These spaces should be determined and shrink …
Read More »