RMAN> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK; If error still occurs, then try the below RMAN> CROSSCHECK COPY OF CONTROLFILE; rman> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE SBT; or…
Read MoreError: Below Oracle Homes are already registered in the global inventory: /u01/oracle/R122/fs1/FMW_Home/oracle_common /u01/oracle/R122/fs1/FMW_Home/webtier /u01/oracle/R122/fs1/FMW_Home/Oracle_EBS-app1 Cause: The above Oracle Homes are already registered from the global inventory Solution: Make sure that…
Read MoreProblem: If adoacorectl.sh,adformsctl.sh,adoafmctl.sh not coming up after start the application services adoacorectl.sh: exiting with status 150 adformsctl.sh: exiting with status 150 adoafmctl.sh: exiting with status 150 Check the log file…
Read MoreProblem details: The Concurrent program is getting completed successfully, able to view output & logfile. But in the log file, it shows below error. Oracle error 20100: java.sql.SQLException: ORA-20100: Error:…
Read MoreORA-02082: a loopback database link must have a connection qualifier Such error occurs when there is a db link which is a loop back database link i.e. points to itself…
Read MoreFix — ORA-19505: failed to identify file in RMAN RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ch00 channel at 01/17/2011…
Read Moresolution: ORA-65086: cannot open/close the pluggable database — Unplug a pluggable database SQL> ALTER PLUGGABLE DATABASE VELDB close immediate; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE VELDB UNPLUG INTO ‘/u01/DB/bkp_pdb/VELDB.xml’;…
Read MoreERROR: FRM-41830 FRM-41830 list of values contains no entries SOLUTION: I have changed the profile option for particular user at the site level so the changes…
Read MoreERROR: Gather Stats ORA-0000: normal, successful completion SOLUTION: Check to see what records will be backed up on the wf_queue_temp_jms_table backup table: set linesize 155; set pagesize 200; set verify…
Read MoreERROR: libdb.so.2: cannot open shared object file: No such file or directory CAUSE: While creating a new clone with R12.1.3 when starting the Apache i get the errors: error while…
Read More