For manual upgrade guide from 11g to 12c, click here. Same guide can also be followed to manually upgrade from 12.1.0.1 to 12.1.0.2.
Before going through this upgrade guide, you may be interested to view the guide to patch/upgrade standalone Grid Infrastructure from 12.1.0.1 to 12.1.0.2.
Before going through this upgrade guide, you may be interested to view the guide to patch/upgrade standalone Grid Infrastructure from 12.1.0.1 to 12.1.0.2.
In this guide, you will see how we patch/upgrade our existing Oracle RDBMS software form 12.1.0.1 to 12.1.0.2. This would be an out-of-place upgrade and hence we would be installing new software in a new home.
As we know that Oracle now provides full installation binaries for patchset releases so the binaries are required to be downloaded from MOS. You would need to download Patch 17694377 disk 1 and 2. This upgrade was done on Oracle Linux 6 (x86-64) running on Oracle Virtual Box. There is a 12.1.0.1 (cdb) database and an 11.2.0.4 (db11g) database running on this host having files on ASM.
To install RDBMS software, log in as “oracle” (RDBMS software owner) and unset ORACLE_BASE and ORACLE_HOME environment variables. After this initiate the installer.
Unset ORACLE_HOME, ORACLE_SID and ORACLE_BASE environment variables
$unset ORACLE_BASE
$unset ORACLE_HOME
$./runInstaller
Click Next
$unset ORACLE_HOME
$./runInstaller
Click Next
Select “Install database software only”, and click Next
Make sure you have selected first option. Click Next
Click Next
Click Next
Specify path for Oracle Base and Oracle Software Home directories. Click Next
Make necessary changes if required. Click Next
Click Install
When prompted, execute root.sh by opening a new terminal window and logging in as root
Installation is complete. Click Close
Now you should update your .bast_profile for “oracle” user to reflect new ORACLE_BASE and ORACLE_HOME directories.
Now it is time to upgrading existing 12.1.0.1 database to 12.1.0.2. Here I will be using DBUA to upgrade the database which is the recommended way to do an upgrade.
Same method can be used to upgrade any database with version 11.2.0.2 or above (for 11G R2), 11.1.0.7 or 10.2.0.5. Otherwise you would need to use some other method to upgrade your database. Please see this white paper for the details.
Same method can be used to upgrade any database with version 11.2.0.2 or above (for 11G R2), 11.1.0.7 or 10.2.0.5. Otherwise you would need to use some other method to upgrade your database. Please see this white paper for the details.
Open DBUA by executing command dbua. Select first option to upgrade the Oracle database. Click Next.
Select your source database for upgrade. Click Next
If this is a container database, all pluggable databases would also be upgraded automatically. Click Next
Make sure there is not error or warning on this screen. If you see any error or warning, resolve it before moving further. Click Next
Select upgrade parallelism carefully. I selected 4 with my single processor Virtual Machine and it took several hours to finish. Your parallelism should never go beyond the number of processors. Click Next
Specify the port on with OEM is needed to be configured. Click Next
Click Next
Select the Listener to which this database will be registered. Or if you want to create a new Listener. local_listener entry in the parameter file would be updated to register the database with the specified listener. Click Next
Select if you either want RMAN to create a new backup before upgrade, or if you want to create or use an existing guaranteed restore point to revert back the database in case of a failed upgrade. Or if you don’t want to take any backup because you already have backed up your database before starting the upgrade. Click Next
Click Finish
Monitor the progress
Click on the Upgrade Results button to see the details. Ignore the Time taken for upgrade, in bellow screen shot because for my case it took quite a long time to finish because of limited resources I had for my virtual machine.
Now you many click on Close to DBUA interface.
DBUA would automatically register database in grid infrastructure from new ORACLE_HOME (12.1.0.2), as can be seen bellow
[grid@salman1 ~]$ srvctl config database -d cdb
Database unique name: cdb
Database name: cdb
Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/cdb/spfilecdb.ora_1418278365037
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA
Services: pdb_srv
OSDBA group:
OSOPER group:
Database instance: cdb
|
No comments:
Post a Comment