The Oracle Database Security Assessment Tool (DBSAT) analyzes database configurations and security policies to help eliminate security risks and improve database security. Using the DBSAT …
Read More »ORACLE
ORA-19573: cannot obtain exclusive enqueue for datafile X
We use the incremental backup of the primary database to fix the gap that occurs in the standby databases. If the managed recovery is turned …
Read More »How To Use kfod and kfed on Exadata
kfed and kfod are under $ORACLE_HOME/bin. With these tools, we can learn about asm disks and edit the information in the disk headers. When using …
Read More »How To Find Serial Numbers of Exadata Servers and Components
The serial numbers and part codes of the compute nodes and cellnodes and components in these nodes in the Exadata are required to supply the …
Read More »READ Object Privilege in Oracle 12c
The READ object privilege introduced with the 12c (12.1.0.2) version. It allows us to read a table without locking. It is used to create read-only …
Read More »Oracle Direct NFS (dNFS)
Oracle Direct NFS (dNFS) is an optimized NFS client that provides faster and more scalable access to NFS storage in NAS storage devices. Direct NFS …
Read More »impdb disable_archive_logging usage
With the disable_archive_logging parameter, which is a feature introduced with Oracle 12c, we are able to import without producing redo in a database in archivelog …
Read More »Hidden Parameters in Oracle Database
There are many hidden parameters in Oracle databases. These parameters should be changed if required by Oracle. Unconscious change of these parameters can be a …
Read More »How To Use oratop For Monitoring Oracle Databases
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 »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 »