ORACLE

In Oracle databases, over time, indexes are fragmented and cause serious performance issues. We should check the indexes regularly and rebuild them if necessary. Determine an index needs to be …

If the password file format in the 12c databases is same with the format in the 11g databases, you receive the error “ORA-28017: The password file is in the legacy …

You may see this error in the database alert log file during upgrade from 11.2 to 12.2. [crayon-5f9a26ad0246c554197727/] The reason for this error is that the resource_manager_plan value was set …

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 for oracle user. Error The …

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, if there is a database …

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 be seen during database connections. …

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 management. This causes problems with …

When you want to disable the diagsnap feature that introduced with Oracle 12c Grid Infrastructure, ologgerd causes an error like “LoggerD –> Error connecting with node” [crayon-5f9a26ad02e9e110424415/] In the above …

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, the corresponding home value of …

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 and deduplication and encryption, are …