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 […]
Monthly Archives: March 2017
How to check Cluster Name
To check the cluster name use, $ORA_CRS_HOME/bin/cemutlo -n
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’; […]
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
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.
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
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
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
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
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