Upgrade RAC database from 11.2.0.1 to 11.2.0.4

This article illustrates step-by-step upgrading of a RAC database from 11.2.0. to 11.2.0.4.

High Level steps:

1) Install 11.2.0.4 RDBMS software with RAC option
2) Perform full database backup of 11.2.0.1 database in mount stage
3) Run DBUA from 11.2.0.4 Oracle_home
4) Verify number of INVALID objects and version of database

1) Install 11.2.0.4 RDBMS software with RAC option

- Make sure that proper DISPLAY variable is configured and execute ./runInstaller

- Follow screen shots

- current version of database.

3) Run DBUA from 11.2.0.4 Oracle_home

Database has been successfully upgraded from 11.2.0.1 to 11.2.0.4.

thanks for reading.

regards,
X A H E E R

Comments

Anonymous said…

Does not work 11.2.0.1 to 11.2.0.4 installation database with rac option.
I dont know how you do it!

OUI does not permit because grid 11.2.0.1......

21 May 2015 at 17:59

Anonymous said…

In RAC setup, I want to upgrade database from 11.2.0.1 to 11.2.0.4

Please suggest can I upgrade the database without upgrading the grid

23 January 2017 at 05:13

Disable Firewall on Oracle Linux 8

In this blogpost we will see how we can stop/disable the firewall on Oracle Linux 8, the firewall command is same in both linux 7 an linux 8. The below listed is the procedure for stopping and disabling the firewall on Oracle Linux 8. - Here we can see the firewall deamon in active state - Here when we stop the firewall in previous command, now the firewall daemon is dead - For permanent disabling the firewall on server, we can use "disable" option The following commands will be helpful: #systemctl status firewalld #systemctl stop firewalld #systemctl disable firewalld #systemctl enable firewalld #systemctl start firewalld Hope it helps !! Thanks for reading :) regards, X A H E E R

Enable Desktop on Oracle Solaris 11.4

Oracle Solaris 11 installation has multiple options to choose for installation of an Operating Environment, but mostly Oracle Solaris text install media is used and this installation media doesn't offer the GUI Desktop Environment by default after the installation. This blog post will explain how we can enable the desktop for Oracle Solaris 11.4 operating system, after the completion of installation. We have to install "solaris-desktop" package and reboot the machine and GUI desktop will be enabled for the Operating System. In this blog post my virtual machine is connected to the internet and hence I am able to use available pupblic repository for package installation, if in case internet is not available for the server/machine then we have configure the local/Server repository for the installation. Follow the below steps for desktop package installation: After installation of dekstop package we are now able to login with GUI desktop environment...

Oracle AVDF Installation and Setup Document

This blogpost will provide you detailed information about Oracle Audit Vault and Database Firewall (Oracle AVDF) setup. Oracle AVDF is a comprehensive Database Activity Monitoring (DAM) solution that integrates with native audit data. Environment Setup: [oracrp@ebs-dev2-db01 ~]$ mkdir -pv /oradb/oracle/avcli mkdir: created directory ‘/oradb/oracle/avcli’ [oracrp@ebs-dev2-db01 ~]$ mkdir -pv /oradb/oracle/avagent mkdir: created directory ‘/oradb/oracle/avagent’ [oracrp@ebs-dev2-db01 ~]$ - Add these variables to the environment file vi DEV2CDB.env # AVS export AVCLI_HOME="/oradb/oracle/avcli" export AV_HOME="/oradb/oracle/avagent" export PATH="$PATH:$AV_HOME/bin" Download the JAR files: AVDF installation requires one network interface card on respective hosts. IP assigned to AV server NIC will communicate with target databases and IP assigned to DF server will connect to AV Download - Agent jar file: Login to AV console as avadmin user - Go t...

Apps DBA Workshop

Search This Blog