ORACLE

With a feature that introduced with 12c R2, we can see the history of Sqlplus and run the commands we have run without rewriting. By …

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 …

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 …

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 …

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, …

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 …

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 …

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 …

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 …

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 …