ORACLE

  The problem was that the UNDO table space had several data files in recover mode. SOLUTION : Problematic files are recovered from backup and …

  This document covers steps involved in refreshing an Oracle database schema where source and target both are AWS RDS databases   Prerequisites: RDS Instances …

  This error is taken when the archive log target directory is filled in databases that are in archive log mode. SOLUTION: As a solution, …

Error: [crayon-6742b2bb84bd2483139676/] 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 …

HADOOP MULTI NODE INSTALLATION PROCESS [ Note: I am creating multi node in most easiest way by creating and using everything in root mode on …

  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 …

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 …

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 * …

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 …

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 …