Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
On an Oracle RAC server, you may receive an error as follows when you want to create a new database with runinstaller. INS-35354: The …
Read More »ORACLE
RMAN-08137 archived log not deleted, needed for standby or upstream capture process
When the “AVDF transaction log audit trail” is created and deleted, the archive logs cannot be deleted normally, depending on bug 23217905. The problem …
Read More »How To Delete Trace Files, listener log etc with ADRCI
With ADRCI, it is possible to delete files such as “log, trace, incident, cdump” created before a certain day. Instead of manually deleting individual files, …
Read More »There is a slowness problem when you query dba_free_space or tablespace in 12c
There may be a slowdown when you query dba_free_space or tablespaces via Toad on 12C databases. The slowness is due to the fact that …
Read More »WARNING: AQ_TM_PROCESSES is set to 0
You can see “WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.” warnings at certain intervals in the database alert log file. …
Read More »Rman restore process hangs with “Starting implicit crosscheck backup” error
If the RMAN restore hangs with the “starting implicit crosscheck backup” error and has not been completed for a long time, you may have …
Read More »kjzdattdlm: Can not attach to DLM(instance crash)
Because the cluster_interconnects parameter is set incorrectly in the database instances on Exadata, one or more of the instances can be closed with the …
Read More »ORA-14404 error during the drop tablespace operation
If the tablespace that is dropped is empty, but is the default storage space for any partition, the drop operation will cause the ORA-14404 …
Read More »How To See Running Queries in Oracle Without TOAD
It is easy to find queries that have been running and that have executed previously during the session using TOAD in the Oracle database. …
Read More »Oracle Database Architecture Part 3
I will continue to explain Oracle database architecture in this article. I’m adding the following image to be memorable. If you didn’t read the previous …
Read More »