Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Error: [crayon-67d426a5e5c5d922947072/] Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name. Solution: It should be set as follows. ORACLE_UNQN average = XXXX …
Read More »
ORACLE
Hadoop-3.1.0 Multi Node Connection and Configuration in easiest way
HADOOP MULTI NODE INSTALLATION PROCESS [ Note: I am creating multi node in most easiest way by creating and using everything in root mode on …
Read More »ORA-13716: Diagnostic Package License is needed for using this feature
You can get the below error when you run the ADDR AWR report in the Oracle Standard edition database. “ORA-13716: Diagnostic Package License is …
Read More »ASM: Device is already labeled for ASM disk
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 »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 »