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 »ORACLE
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 »RMAN-08132: WARNING: cannot update recovery area reclaimable file list
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 …
Read More »RMAN Commands Hanging
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 …
Read More »ORA-27054: NFS file system where the file is created or resides is not
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 …
Read More »