Upgrading Oracle Grid Infrastructure 11gR2 to 12cR2

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) Grid Infrastructure to Oracle 12cR2 (12.2.0.1) on the same server. This upgrade process was done on Linux 6 (x86_64). 1. Before the GI upgrade backup the OCR manually. This could be used in downgrading the GI from 12.2.0.1 to 11.2.0.4 later one. If you […]

Read More

Scenario 1 – Recover a Member of a Multiplexed Online Redo Log Group

Please follow the below steps. Steps : 1. Shutdown immediate; 2. Physically remove redo log member(no redo log group) by using OS level command. 3. Startup; 4. SELECT GROUP#, STATUS, MEMBER FROM v$LOGFILE WHERE STATUS=’INVALID’; 5. Check alert log file. Steps for Recovery : 1. Drop the damaged member ALTER DATABASE DROP LOGFILE MEMBER ‘D:\app\admin\oradata\orcl\REDO01.LOG’; […]

Read More

dbaascli database start

The database start subcommand of the dbaascli utility can be used to start the database instance and open the database. Execute this command as the oracle user. dbaascli database start

Read More

dbaascli database changepassword

The database changepassword subcommand of the dbaascli utility is used to change the password of a database user. Execute this command as the oracle user. dbaascli database changepassword Enter the user name and new password when prompted.

Read More

dbaascli database bounce

The database bounce subcommand of the dbaascli utility can be used to shut down and restart the database. Execute this command as the oracle user. dbaascli database bounce

Read More

dbaascli listener stop

The listener stop subcommand of the dbaascli utility is used to stop the listener. Execute this command as the oracle user. dbaascli listener stop

Read More

dbaascli listener bounce

The listener bounce subcommand of the dbaascli utility is used to stop and restart the listener. Execute this command as the oracle user. dbaascli listener bounce

Read More

dbaascli listener start

The listener start subcommand of the dbaascli utility is used to start the listener. Execute this command as the oracle user. dbaascli listener start

Read More

dbaascli listener status

The listener status subcommand of the dbaascli utility is used to obtain information about the status of the listener. Execute this command as the oracle user. dbaascli listener status

Read More