Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Problem: If a disk previously included in an ASM disk group is attempted to be used for another disk group, it will fail with the …
Read More »
ORACLE
ORA-12546 TNS:permission denied TNS-12546: TNS:permission denied
Error: When creating an Oracle database in Windows operating system: ORA-12546 TNS: permission denied ORA-12560 TNS protocol adpater error ORA-516 Permission denied From SQL * …
Read More »RMAN DBGMISC: ENTERED krmkmrsr
ERROR: In Oracle 11g r2 database rman crashes during exit and gives error like DBGMISC: ENTERED crmkmrsr. REASON: Inconsistency in NLS settings. (This is specified …
Read More »RMAN : ORA-01008: not all variables bound
Error: When trying to connect with rman “ORA-01008: not all variables bound” error is occured. Reason: Bug 10306699 Solution: You need to set the cursor_sharing …
Read More »Enterprise Manager : java.lang.Exception: Exception in sending Request :: null
Error : When we logged in to EM, there was an error “java.lang.Exception: Exception in sending Request :: null” and the page was not displayed …
Read More »Unable to start Enterprise Manager Database Control
Error: When the database is upgraded to version 10.2.0.4 or 10.2.0.5, the Enterprise Manager configuration ends with an error and fails to start manually. Reason: …
Read More »RMAN : PLS-00201: identifier ‘DBMS_BACKUP_RESTORE.SET_CHARSET’ must be declared
Error: When connecting to rman, “PLS-00201: identifier ‘DBMS_BACKUP_RESTORE.SET_CHARSET’ must be declared” error and connection could not be established. Reason: Problematic DBMS_BACKUP_RESTORE package or invalid sys …
Read More » How to purge sysaux tablespace
Sysaux tablespace is an auxiliary tablespace to the SYSTEM tablespace. If SYSAUX tablespace becomes unusable database functionality will remain operational. Occupants of the SYSAUX tablespace …
Read More »The DBSNMP user is locked after a certain period of time
Error : The DBSNMP user is locked after a certain period of time. Reason: An application (possibly an application in EM) is trying to login …
Read More »How To Make IMPDP Faster Using Oracle 12c New Feture
12c R1 Has a New Feature to suppress the generation of redo during Data Pump import. This feature not only suppresses the redo generation …
Read More »