Mir Sayeed Hassan – Oracle Blog

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

How to perform the Manual Data Guard Switchover on Oracle 19c Database

To perform this data guard switchover operation., You need to planned according to the requirement.

In this case., your primary database role will be changed/converted as STANDBY DB., Standby database role will be changed/converted as PRIMARY DB & There is no loss of data in this method.

Consider...
Read more..

ORA-01665: control file is not a standby control file

Receive the below error after the configuration of standby database manually & started the recovery process on standby database.

SQL> alter database recover managed standby database using current logfile disconnect from session;
alter database recover managed standby database using current logfile disconnect from session
*
ERROR... 
Read more..