ORACLE

It is possible to forget the passwords of the users in the DB Links created for the communication between Oracle databases. These users’ passwords can be identified. You can follow …

Enable DDL Auditing in 11g It is possible to enable ddl auditing in a database or shema. In this way, we can monitor all DDL changes and we can undo …

This article describes how to change the id and name of a database that is running as RAC, what operations should be done before and after. In the examples, necessary …

When nfslock service is turned off, export ends with an ORA-27086 error when trying to backup on a NFS mounted directory. To resolve this error, the nfslock service must be …

For improved security, RMAN backups can be encrypted. Encrypted backups cannot be read by unauthorized persons. A password or wallet is required to return from Backup. If your backups are …

You can take advantage of the following views to find scheduled jobs and currently running jobs in Oracle databases. USER_SCHEDULER_JOBS, ALL_SCHEDULER_JOBS, DBA_SCHEDULER_JOBS views can be used for information about user-level …

While creating a database with DBCA, when “General_Purpose” template is selected, this error is received because the “compatible” parameter in the template is lower than the database_compatibility value of the …

When trying to open the console via ilom, the screen does not turn on due to the incompatibility in the java security settings. You can solve this problem with a …

In the event that the Exadata servers cannot be turned on from the operating system, we can turn on the systems from the rescue disk and make the necessary arrangements. …

To learn the Automatic Shared Memory Management, read the article titled “Oracle Memory Components(SGA and PGA)“. For databases that do not use Automatic Shared Memory Management, ASMM(Automatic Shared Memory Management) …