Find the Useful OPATCH Commands for Oracle Database List inventory details of patch. [oracle@miroradb ~]$ $ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc OPatch… Read more..

ORA-30032: The Suspended (Resumable) Statement has Timed Out in Oracle Database 11gR2(11.2.0.4) Issue: This issue was occur while doing a transaction in real-time database & it’s was hung for few seconds & get the error SQL> select instance_name, version, status, open_mode from V$database, v$instance; INSTANCE_NAME VERSION STATUS OPEN_MODE —————-… Read more..