Posted by Mir Sayeed Hassan on 22nd December 2021
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 Read More
Posted in ASM | Comments Off on How to Auto Start CRS after on Reboot Server
Posted by Mir Sayeed Hassan on 20th December 2021
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 Read More
Posted in ORA-Error | Comments Off on ORA-04031: unable to allocate ** bytes of shared memory and could not startup the database
Posted by Mir Sayeed Hassan on 15th December 2021
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 Read More
Posted in DataGuard (DR) | Comments Off on How to perform the Manual Data Guard Switchover on Oracle 19c Database
Posted by Mir Sayeed Hassan on 13th December 2021
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
Posted in ORA-Error | Comments Off on ORA-01665: control file is not a standby control file
