ORACLE

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 …

Error : The DBSNMP user is locked after a certain period of time. Reason: An application (possibly an application in EM) is trying to login …

  12c R1 Has a New Feature to suppress the generation of redo during Data Pump import. This feature not only suppresses the redo generation …

Error: During RMAN backup, you can see the following errors. ORA-00245: control file backup operation failed RMAN-08132: WARNING: can not update recovery area reclaimable file …

Error: When connecting to RMAN, it generates output when any command is given, but the command is not completed and is waiting. Reason: Disruption in …

Error: When we try to create a file in NFS mounted directory we get an error like this and we can not create the file …

Error: When clients attempts to connect to the database, they can not connect with the error “ORA-12502: TNS: listener received no CONNECT_DATA from client”. Reason: …

PROBLEM: The error “java.sql.SQLException: OALL8 is in an inconsistent state” is being retrieved when the query is executed. REASON: The database version is incompatible with …

Oracle uses Redo Logs and Archive Logs to ensure that the data written to the database will not be lost once it has been written …

The most important two components of Oracle Instance are SGA and Background Processes. Each Oracle Database process on the operating system is responsible for one …