Mir Sayeed Hassan – Oracle Blog

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..			

emcli login failed in OEM 13.5C

This error occur while login to the emcli on OMS

[oracle(oemsw)@cloudctl bin]$ ./emcli login -username=sysman
Enter password ***********

Error: Connection to the current OMS could not be established. Check the log files for further details.
Log file location is : /u02/OEM13.5C/gc_inst/em/EMGC_OMS1/sysman/emcli/setup/.emcli/.emcli.log

[oracle(oemsw)@cloudctl... 
Read more..			

ORA 01665 control file is not a standby control file

This error occour while starting the recovery process on standby database.

Check the status of database

SQL> select instance_name,open_mode,status from V$instance, v$database;

INSTANCE_NAME      OPEN_MODE       STATUS
---------------- -------------------- ------------
testdb-std1         MOUNTED       MOUNTED

SQL>... 
Read more..			

How to Auto Start CRS after on Reboot Server

I wanted to restart the CRS automatically after reboot the server., By default the CRS AUTO_START is never.

You need to configure the AUTO_START=always., Fallow the below steps.

Check the current status of CRS on server

[root@pri-db bin]# ./crsctl stat res ora.cssd -p | grep AUTO_START
AUTO_START=never

[root@pri-db... 
Read more..			

ORA-04031: unable to allocate ** bytes of shared memory and could not startup the database

This ORA error occur due the less shared memory allocated in shared pool.

Start up database failed

SQL> startup
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0

Check the current available memory assign to this server

[oracle@pri-db... 
Read more..