Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In this article I will tell you about Recyclebin which is one of the beautiful features announced with Oracle 10g version. With the Recyclebin …
Read More »
ORACLE
ORA-00245: control file backup failed; target is likely on a local file system
When backup is taken with Rman, it creates the snapshot of the control file and uses it as backup file. The name of the …
Read More »Data Pump Export process waiting with the message “wait for unread message on broadcast channel”
During the DataPump export process, if the relevant session is waiting for the following message, you can resolve this issue by doing the following …
Read More »How To Increase Incremental Backup Speed with Block Change Tracking
You can increase the incremental backup speed with Block Change Tracking, which is one of the features that introduced with 10G. When we enable …
Read More »What is Network Access Control List and How To Use It
From 11gR1, access to external network services in Oracle databases is done through the Access Control List (ACL). It is possible to perform operations …
Read More »Oracle Data Pump Query Parameter
With the data pump, you can use the query parameter to export only the records that are returned from the query in a table. …
Read More » /bin/rm: Argument list too long. Error for deletion of Audit files
Description: Sometimes when we try to delete the large numbers of audit files, we get the error “/bin/rm: Argument list too long“. Solution : Run …
Read More »Connect With the Oracle User Whose Password You Don’t Know
If you have DBA privileges, you can connect with that user without knowing a user’s password, then you can set the old password. In …
Read More »RMAN-06091: no channel allocated for maintenance
When we get the RMAN-06091 error during operations with RMAN, we need to open a new channel for maintenance. You can use the following command. …
Read More »How to Start Oracle Database Automatically When Linux Server Is Started
In this article, I will share linux scripts with you for staring database automatically when operating system is started. My environment is: Oracle 11.2.0.4 …
Read More »