oratop is a utility that provides a general knowledge of database performance, similar to the top command in linux systems. When used with the Top …
Read More »ORACLE
kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
During the database shutdown process, this alert is written to the alert log file because the processes of the running jobs cannot be propagated. The …
Read More »SQL Plus History
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 …
Read More »How To Find Oracle DB Link User Password
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 …
Read More »How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging)
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 …
Read More »How To Change the database id and database name in RAC Databases
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 …
Read More »ORA-27086: unable to lock file – already in use
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, …
Read More »RMAN Encrypted Backup
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 …
Read More »Scheduled Job List in Oracle Databases
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 …
Read More »diskgroup is not compatible for database usage
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 …
Read More »