EasyReliableDBA: RAC database upgrade from 11.2.0.3 to 11.2.0.4

RAC DATABASE UPGRADE

Check Oracle home mount point free space (approx 30 GB) and database size and backup configuration

select sum(bytes/1024/1024/1024) from dba_segments;

select sum(bytes/1024/1024/1024) from dba_data_files;

1). Download the Patchset 13390677 from My Oracle support

https://updates.oracle.com/download/13390677.html

There are 7 .zip files, to install Oracle db server download 1of7 and 2of7 -->>>>>>> are for database

2). Transfer both files in both nodes and Unzip the files in the same directory (do not create separate directories for each zip file)

[Node1:fusppt:install] ls -ltr

drwxr-xr-x 8 fusppt dba 4096 Oct 9 2013 database

-rwxrwxrwx 1 fusppt dba 1170882875 Jan 5 12:35 p13390677_112040_AIX64-5L_2of7.zip

-rwxrwxrwx 1 fusppt dba 1801653734 Jan 5 12:51 p13390677_112040_AIX64-5L_1of7.zip

unzip above patches using instance owner ( fusppt user)

unzip p13390677_112040_AIX64-5L_2of7.zip

unzip p13390677_112040_AIX64-5L_1of7.zip

4). Go through the note 169706.1 and install necessary OS patches/packages.

5). Make new folder in both node with same permission and take tar backup of oracle home from both node and inventory

--inventory backup---------

cd /u02/oracle/oraInventory

tar -cvf /staging/11.2.0.4_software/install_log/oracle_inventory_Node1.tar .

Oracle home backup from instance owner user (TESTDB)

----------------------------------

cd /u01/oracle/TESTDB/product/11.2.0.4

tar -cvf /staging/11.2.0.4_software/install_log/TESTDB11204eepdec2015.tar .

[Node1:fusppt:install]

mkdir -p /u05/oracle/TESTDB/product/11.2.0.4

chmod -R 750 /u05/oracle/TESTDB/product/11.2.0.4

[Node1:fusppt:product] ls -ltr

total 16

drwxr-x--- 80 fusppt dba 4096 Feb 8 16:31 11.2.0

drwxr-xr-x 74 fusppt dba 4096 Feb 8 16:52 11.2.0.4 ----new folder

[Node1:fusppt:product] cd 11.2.0.4

[Node1:fusppt:11.2.0.4] pwd

/u05/oracle/TESTDB/product/11.2.0.4

[Node1:fusppt:11.2.0.4]

6. Install 11.2.0.4 in a separate Oracle home ( /u05/oracle/TESTDB/product/11.2.0.4 )

Starting with the first patch set for Oracle Database 11g Release 2 (11.2.0.2), Oracle Database patch sets are full installations of the Oracle Database software. You can refer to Note 1189783.1 for more information.

Installation documentation - http://docs.oracle.com/cd/E11882_01/install.112/e24346/toc.htm

a) check whether GUI is configured or not ,

ps -ef|grep vnc

check port no

if vnc already running but GUI is not working ,then kill vnc as below

To stop the VNC server simpy run the following command:

vncserver -kill :2

vncserver -kill :20

run the VNC again

$ vncserver

password= oracle@1234

and check GUI connectivity by vncviewer

b) unset all oracle related path on both node

export IGNORE_PREADDNODE_CHECKS=Y(optinal)

$ unset ORACLE_BASE

$ unset ORACLE_HOME

$ unset ORACLE_HOSTNAME

$ unset ORACLE_SID

$ unset ORACLE_UNQNAM

c) run ./runInstaller

[Node1:fusppt:database] ls -ltr

total 144

drwxr-xr-x 2 fusppt dba 256 Oct 9 2013 sshsetup

-rwxr-xr-x 1 fusppt dba 10305 Oct 9 2013 runInstaller

drwxr-xr-x 2 fusppt dba 256 Oct 9 2013 rpm

-rwxr-xr-x 1 fusppt dba 14047 Oct 9 2013 rootpre.sh

drwxr-xr-x 3 fusppt dba 256 Oct 9 2013 rootpre

drwxr-xr-x 2 fusppt dba 256 Oct 9 2013 response

drwxr-xr-x 4 fusppt dba 4096 Oct 9 2013 install

drwxr-xr-x 14 fusppt dba 4096 Oct 9 2013 stage

-rw-r--r-- 1 fusppt dba 500 Oct 9 2013 welcome.html

-rw-r--r-- 1 fusppt dba 30016 Oct 9 2013 readme.html

[Node1:fusppt:database] pwd

/oswatcher/install/database

[Node1:fusppt:database] run ./rootpre.sh from root on both node

Carefully give the path of oracle base and oracle home

New home= /u05/oracle/TESTDB/product/11.2.0.4

Oracle base =/u05/oracle/TESTDB

6). Verify the installation by going through installAction<time stamp>.log, check there are no errors

Once software has been installed, Start upgradation of database as below

Pre Implementation

[Node1:fusppt:database_upgrad] ps -ef|grep pmon

orappt 15990972 1 0 Feb 04 - 2:05 ora_pmon_PPT1

fusppt 30081072 1 0 Jan 06 - 12:41 ora_pmon_TESTDB1

orauat 38863102 1 0 Jan 06 - 11:20 ora_pmon_UAT1

oracrs 60227780 1 0 Jan 06 - 5:55 asm_pmon_+ASM1

fusppt 65814 48103614 0 17:34:04 pts/3 0:00 grep pmon

[Node1:fusppt:database_upgrad]

[Node1:fusppt:database_upgrad] srvctl config database -d TESTDB -a

Database unique name: TESTDB

Database name: TESTDB

Oracle home: /u05/oracle/TESTDB/product/11.2.0

Oracle user: fusppt

Spfile: +DATA2/TESTDB/spfileTESTDB.ora

Domain: retail2u.trcg.co.uk

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: TESTDB

Database instances: TESTDB1,TESTDB2

Disk Groups:

Services:

Database is enabled

Database is administrator managed

[Node1:fusppt:database_upgrad]

2) Execute pre-upgrade scripts

a. utlu112i.sql (copy this file from 11.2.0.4 $ORACLE_HOME/rdbms) or you can download latest script from "How to Download and Run Oracle's Database Pre-Upgrade Utility ( Doc ID 884522.1 )".

b. dbupgdiag.sql (to download the script refer to Note 556610.1 )

3). Follow the suggestions given by utu112i.sql script and verify that there are no INVALID components and INVALID objects owned by SYS/SYSTEM schema, if there are any, then do not proceed with upgrade, until all components, objects are VALID

4). collect statistics prior to performing the actual database upgrade

SQL> EXECUTE dbms_stats.gather_dictionary_stats;

sql> purge DBA_RECYCLEBIN;

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql ( to check invalid objects)

5). If the auditing is enabled and SYS.AUD$ table is large, it is suggested to take backup of the table, truncate the table and proceed the with upgrade. Refer to Note 979942.1 , Note 73408.1

sql> truncate table SYS.AUD$;

column object_name format a30

select object_name, object_type from dba_objects where OBJECT_NAME not in ('AQ$_SCHEDULES_PRIMARY', 'AQ$_SCHEDULES','DBMS_REPCAT_AUTH','DBMS_REPCAT_AUTH PACKAGE')

and object_name||object_type in (select object_name||object_type

from dba_objects where owner = 'SYS') and owner = 'SYSTEM';

SQL>@check_stale_s2.sql (To check stale schema mos note id-560336.1 to check the schema stale statistics )

IMPLEMENTATION

----------------------------

1. Shutdown source DB

srvctl stop database -d TESTDB

2. set appropriate ENV varliables like ORACLE_HOME, PATH, ORACLE_SID

3. cd $ORACLE_HOME (new oracle home)

export ORACLE_SID=TESTDB 1

export ORACLE_HOME=/u05/oracle/TESTDB/product/11.2.0.4/

4. copy init.ora parameter file to 11.2.0.4 ORACLE_HOME

create pfile='/u05/oracle/TESTDB/product/11.2.0.4/dbs/init_TESTDB.ora' from spfile

create pfile='/u01/oracle/fsprod/db/tech_st/11.2.0.4/dbs/init_FSPROD.ora' from spfile

copy pfile from old to new home on both node

louth[/u01/oracle/fsprod/db/tech_st/11.2.0]$ cd dbs

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/dbs]$ ls -ltr

total 45640

-rw-r--r-- 1 fusprod dba 2851 May 15 2009 init.ora

-rw-r----- 1 fusprod dba 40 Jul 13 2011 initFSPROD1.ora

drwxr-x--- 2 fusprod asmadmin 256 Nov 19 2011 core_64618668

-rw-r----- 1 fusprod dba 1536 Jun 08 2015 orapwFSPROD1

-rw-r--r-- 1 fusprod dba 960 Oct 18 2015 tdpoerror.log

-rw-r----- 1 fusprod asmadmin 23347200 Jul 23 20:10 snapcf_FSPROD1.f

-rw-rw---- 1 fusprod asmadmin 1544 Jul 23 22:53 hc_FSPROD1.dat

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/dbs]$ cat initFSPROD1.ora

SPFILE='+DATA1/FSPROD/spfileFSPROD.ora'

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/dbs]$

louth[/u01/oracle/fsprod/db/tech_st/11.2.0]$ cd dbs

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/dbs]$ ls -ltr

total 45640

-rw-r--r-- 1 fusprod dba 2851 May 15 2009 init.ora

-rw-r----- 1 fusprod dba 40 Jul 13 2011 initFSPROD1.ora

drwxr-x--- 2 fusprod asmadmin 256 Nov 19 2011 core_64618668

-rw-r----- 1 fusprod dba 1536 Jun 08 2015 orapwFSPROD1

-rw-r--r-- 1 fusprod dba 960 Oct 18 2015 tdpoerror.log

-rw-r----- 1 fusprod asmadmin 23347200 Jul 23 20:10 snapcf_FSPROD1.f

-rw-rw---- 1 fusprod asmadmin 1544 Jul 23 22:53 hc_FSPROD1.dat

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/dbs]$ cat initFSPROD1.ora

SPFILE='+DATA1/FSPROD/spfileFSPROD.ora'

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/dbs]$

cd u01/oracle/fsprod/db/tech_st/11.2.0/dbs

cp initFSPROD1.ora orapwFSPROD1 /u01/oracle/fsprod/db/tech_st/11.2.0.4/dbs/

buxton[/u01/oracle/fsprod/db/tech_st/11.2.0]$ cd dbs

buxton[/u01/oracle/fsprod/db/tech_st/11.2.0/dbs]$ ls -ltr

total 45640

-rw-r--r-- 1 fusprod dba 2851 Jul 13 2011 init.ora

-rw-rw---- 1 fusprod dba 1544 Jul 13 2011 hc_DBUA0.dat

-rw-r----- 1 fusprod dba 40 Jul 13 2011 initFSPROD2.ora

-rw-r----- 1 fusprod dba 1536 Jul 03 2013 orapwFSPROD2

-rw-r----- 1 fusprod asmadmin 23347200 Jul 10 08:54 snapcf_FSPROD2.f

-rw-rw---- 1 fusprod asmadmin 1544 Jul 23 23:03 hc_FSPROD2.dat

buxton[/u01/oracle/fsprod/db/tech_st/11.2.0/dbs]$ cat initFSPROD2.ora

SPFILE='+DATA1/FSPROD/spfileFSPROD.ora'

buxton[/u01/oracle/fsprod/db/tech_st/11.2.0/dbs]$

cd u01/oracle/fsprod/db/tech_st/11.2.0/dbs

cp initFSPROD1.ora orapwFSPROD1 /u01/oracle/fsprod/db/tech_st/11.2.0.4/dbs/

5. make changes if any in init.ora file like removing hidden parameters, removing parameters related event tracking

if the db is in RAC setup, then CLUSTER_DATABASE should be false

CLUSTER_DATABASE=false

6. Start the database in upgrade mode from new ORACLE_HOME using newly parameter file (double check CLUSTER_DATABASE=false in new pfile)

7. execute "catupgrd.sql"

export ORACLE_SID=TESTDB 1

export ORACLE_HOME=/u05/oracle/TESTDB/product/11.2.0.4/

cd $ORACLE_HOME/rdbms/admin

$sqlplus "/as sysdba"

startup UPGRADE pfile=/u05/oracle/TESTDB/product/11.2.0.4/dbs/init_TESTDB.ora

spool cat.log

@$ORACLE_HOME/rdbms/admin/catupgrd.sql

spool off

startup upgrade

exit

echo $ORACLE_SID

echo $ORACLE_HOME

nohup sqlplus -S "/ as sysdba" @$ORACLE_HOME/rdbms/admin/catupgrd.sql &

Commit complete.

Database closed.

Database dismounted.

ORACLE instance shut down.

[1] + Done nohup sqlplus -S "/ as sysdba" @$ORACLE_HOME/rdbms/admin/catupgrd.sql &

it will take approx 1 hours

louth[/u01/oracle/fsprod/db/tech_st/11.2.0.4/dbs]$ mv init_FSPROD.ora init_FSPROD.ora.bk

louth[/u01/oracle/fsprod/db/tech_st/11.2.0.4/dbs]$ cp initFSPROD1.ora orapwFSPROD1 /u01/oracle/fsprod/db/tech_st/11.2.0.4/dbs/

louth[/u01/oracle/fsprod/db/tech_st/11.2.0.4/dbs]$ cd ..

louth[/u01/oracle/fsprod/db/tech_st/11.2.0.4]$ cd ..

louth[/u01/oracle/fsprod/db/tech_st]$ ls -ltr

total 14707944

-rw-r--r-- 1 fusprod dba 7510302720 Mar 07 2013 fsprdbkp_07032013.tar

-rw-r--r-- 1 fusprod dba 20152320 Mar 07 2013 Inventorybkp_07032013.tar

drwxr-xr-x 4 fusprod dba 256 Sep 14 2013 patches

drwxr-xr-x 81 fusprod dba 4096 Jul 23 21:12 11.2.0

drwxr-xr-x 75 fusprod dba 4096 Jul 23 22:42 11.2.0.4

louth[/u01/oracle/fsprod/db/tech_st]$ cd 11.2.0

louth[/u01/oracle/fsprod/db/tech_st/11.2.0]$ cd dbs

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/dbs]$ ls -ltr

total 45640

-rw-r--r-- 1 fusprod dba 2851 May 15 2009 init.ora

-rw-r----- 1 fusprod dba 40 Jul 13 2011 initFSPROD1.ora

drwxr-x--- 2 fusprod asmadmin 256 Nov 19 2011 core_64618668

-rw-r----- 1 fusprod dba 1536 Jun 08 2015 orapwFSPROD1

-rw-r--r-- 1 fusprod dba 960 Oct 18 2015 tdpoerror.log

-rw-r----- 1 fusprod asmadmin 23347200 Jul 23 23:05 snapcf_FSPROD1.f

-rw-rw---- 1 fusprod asmadmin 1544 Jul 23 23:32 hc_FSPROD1.dat

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/dbs]$ cp initFSPROD1.ora orapwFSPROD1 /u01/oracle/fsprod/db/tech_st/11.2.0.4/dbs/

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/dbs]$

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/dbs]$ cd ../..

louth[/u01/oracle/fsprod/db/tech_st]$ cd 11.2.0

louth[/u01/oracle/fsprod/db/tech_st/11.2.0]$ cd network/admin

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/network/admin]$ ls -ltr

total 80

-rw-r--r-- 1 fusprod dba 187 May 07 2007 shrept.lst

drwxr-xr-x 2 fusprod dba 256 Jul 13 2011 samples

-rw-r--r-- 1 fusprod dba 983 Feb 15 2013 tnsnames.ora_15022013

-rw-r--r-- 1 fusprod dba 982 Feb 15 2013 tnsnames.ora

-rw-r--r-- 1 fusprod dba 27269 Jul 23 18:57 pre_recycle.log

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/network/admin]$ cp tnsnames.ora /u01/oracle/fsprod/db/tech_st/11.2.0.4/network/admin/

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/network/admin]$

Step 27-Restart the database in normal mode

srvctl upgrade database -d db-unique-name -o oraclehome

srvctl upgrade database -d FSPROD -o /u01/oracle/fsprod/db/tech_st/11.2.0.4

srvctl start database -d FSPROD

IMP : Need to take database to ARCHIVE LOG MODE

Run the postupgrade script utlu112s.sql to display the results of the upgrade and run catuppst.sql to finish the upgrade.

@$ORACLE_HOME/rdbms/admin/utlu112s.sql

@$ORACLE_HOME/rdbms/admin/catuppst.sql

Finally run utlrp.sql to recompile any remaining stored PL/SQL and Java code and verify that all expected packages and classes are valid:

@?/rdbms/admin/utlrp.sql

POST IMPLEMETATION

Pre-upgrade checks should be run during your upgrade planning phase, the tool prompts you which version you are planning to upgrade to:

$ ./orachk –u –o pre

$ ./exachk –u –o pre

After performing your upgrade you should then run the post upgrade checks:

$ ./orachk –u –o post

$ ./exachk –u –o post

For more information about running in on demand mode, see On Demand Mode Operation.

1. Check upgrade logs and make sure catupgrd.sql run without any error.

2. execute dbupgdiag.sql in 11.2.0.4, verify that there are no INVALID components and INVALID objects owned by SYS/SYSTEM schema

SQL> set echo on

-- query registry

SQL> set lines 80 pages 100

SQL> select substr(comp_id,1,15) comp_id,substr(comp_name,1,30)

comp_name,substr(version,1,10) version,status

from dba_registry order by modified;

3. Complete the post ugrade steps (refer Note 837570.1 )

4. Verify/test your application's functionality after db upgrade. Take a full backup, then you can decide to change COMPATIBLE parameter.

3) check the oracle registry and run post up gradation tool( utlu112s.sql)

4) run full database backup and statistics.

5) check the remotely connectivity and to which user database has been started and send mail to customer with screenshot.

6)Confirm Application/Ops team to start their application services

8) In-case of any issues again Application team has to stop their services and then Database team can stop and rollback the change and confirm back application team.

9) Make oracle home change in ORATAB

to copy enviroment variable

ls -ltr /u01/oracle/fsprod/db/tech_st/11.2.0/FSPROD_buxton.retail2u.trcg.co.uk.env

cp /u01/oracle/fsprod/db/tech_st/11.2.0/FSPROD_buxton.retail2u.trcg.co.uk.env

/u01/oracle/fsprod/db/tech_st/11.2.0.4/

-rw-r--r-- 1 fusprod dba 27 Aug 01 14:06 FSPROD2_buxton.env.bk

-rw-r--r-- 1 fusprod dba 178 Aug 01 14:11 FSPROD_buxton.retail2u.trcg.co.uk.env

buxton[/u01/oracle/fsprod/db/tech_st/11.2.0.4]$ cat FSPROD_buxton.retail2u.trcg.co.uk.env

export ORACLE_SID=FSPROD2

export ORACLE_BASE=/u01/oracle/fsprod

export ORACLE_HOME=/u01/oracle/fsprod/db/tech_st/11.2.0.4

export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch

buxton[/u01/oracle/fsprod/db/tech_st/11.2.0.4]$

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/network/admin]$ connect catalog rmc_fsprod/fsprod_rmc@rmcprd;

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/network/admin]$ rman

create soft link in new home

-rwxr-xr-x 1 fusprod dba 69456 Jul 13 2011 libnmcfhc.so

-rw-r--r-- 1 fusprod dba 1114 Jul 13 2011 nnfgt.o

-rw-r--r-- 1 fusprod dba 120 Jul 13 2011 ldflags

lrwxrwxrwx 1 fusprod dba 19 Sep 09 2011 libobk.a -> /usr/lib/libobk64.a

-rw-r--r-- 1 fusprod dba 9874049 Mar 07 2013 libpls11_pic.a

-rw-r--r-- 1 fusprod dba 10107895 Mar 07 2013 libpls11.a

-rw-r--r-- 1 fusprod dba 25582460 Mar 07 2013 libgeneric11.a

-rw-r--r-- 1 fusprod dba 4638861 Mar 07 2013 libcommon11.a

-rw-r--r-- 1 fusprod dba 897977 Mar 07 2013 libasmclnt11.a

-rw-r--r-- 1 fusprod dba 17864404 Mar 07 2013 liboraolap11.a

-rw-r--r-- 1 fusprod dba 941801 Mar 07 2013 libnro11.a

-rw-r--r-- 1 fusprod dba 4973846 Mar 07 2013 libordsdo11.a

-rw-r--r-- 1 fusprod dba 7650899 Mar 07 2013 libxml11.a

-rw-r--r-- 1 fusprod dba 2698059 Mar 07 2013 libztkg11.a

-rw-r--r-- 1 fusprod dba 73592 Mar 07 2013 libzt11.a

-rw-r--r-- 1 fusprod dba 12696784 Mar 07 2013 libnnz11.a

-rw-r--r-- 1 fusprod dba 37075 Mar 07 2013 clntsh.exp

-rwxr-xr-x 1 fusprod dba 48492701 Mar 07 2013 libclntsh.so

-rw-r--r-- 1 fusprod dba 270923 Mar 07 2013 clntsh.map

-rw-r--r-- 1 fusprod dba 49601511 Mar 07 2013 libclntsh.a

-rwxr-xr-x 1 fusprod dba 65985812 Mar 07 2013 libttsh11.so

lrwxrwxrwx 1 fusprod dba 53 Mar 07 2013 libclntsh.so.10.1 -> /u01/oracle/fsprod/db/tech_st/11.2.0/lib/libclntsh.so

-rwxr-xr-x 1 testdba dba 4943481 Mar 07 2013 libocci.so

-rw-r--r-- 1 testdba dba 6362835 Mar 07 2013 libocci.a

-rw-r--r-- 1 testdba dba 2246 Mar 07 2013 agtsh.exp

-rw-r--r-- 1 testdba dba 178761060 Mar 07 2013 libserver11.a

-rw-r--r-- 1 testdba dba 43485308 Mar 07 2013 libagtsh.a

Node1[/u01/oracle/testdb/db/tech_st/11.2.0/lib]$

--on both node

ln -s /usr/lib/libobk64.a libobk.a

you can copy this file as well from old now on both node

cp testdb1_Node1.env /u01/oracle/testdb/db/tech_st/11.2.0.4/

Node1[/u01/oracle/fsprod/db/tech_st/11.2.0.4]$ cat testdb1_Node1.env

export ORACLE_SID=testdb1

export ORACLE_BASE=/u01/oracle/testdb

export ORACLE_HOME=/u01/oracle/testdb/db/tech_st/11.2.0.4

export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch

Node1[/u01/oracle/testdb/db/tech_st/11.2.0.4]$

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 24 01:08:50 2016

RMAN> connect catalog rmc_testdb/testdb_rmc@catalogprd;

connected to recovery catalog database

PL/SQL package RMC_testdb.DBMS_RCVCAT version 11.02.00.01 in RCVCAT database is not current

PL/SQL package RMC_testdb.DBMS_RCVMAN version 11.02.00.01 in RCVCAT database is not current

RMAN> connect target;

connected to target database: testdb (DBID=2453172318)

RMAN>

RMAN> upgrade catalog;

recovery catalog owner is RMC_testdb

enter UPGRADE CATALOG command again to confirm catalog upgrade

RMAN> upgrade catalog;

recovery catalog upgraded to version 11.02.00.04

DBMS_RCVMAN package upgraded to version 11.02.00.04

DBMS_RCVCAT package upgraded to version 11.02.00.04

RMAN>

Node1[/u01/oracle/fsprod/db/tech_st/11.2.0/network/admin]$

Node2[/u01/oracle/fsprod/db/tech_st/11.2.0/network/admin]$ srvctl config database -d testdb -a

Database unique name: testdba

Database name: testdba

Oracle home: /u01/oracle/fsprod/db/tech_st/11.2.0.4

Oracle user: testdba

Spfile: +DATA1/FSPROD/spfiletestdba.ora

Domain: retail.trcg.co.uk

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: testdb

Database instances: testdb2,testdb1

Disk Groups: DATA1,testdb_FRA1

Mount point paths:

Services:

Type: RAC

Database is enabled

Database is administrator managed

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/network/admin]$

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/network/admin]$ tnsping fusprod-scan:1522/FSPROD.retail2u.trcg.co.uk

TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production on 24-JUL-2016 02:07:26

Used parameter files:

Used HOSTNAME adapter to resolve the alias

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=FSPROD.retail2u.trcg.co.uk))(ADDRESS=(PROTOCOL=TCP)(HOST=10.160.32.40)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=10.160.32.41)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=10.160.32.42)(PORT=1522)))

OK (0 msec)

louth[/u01/oracle/fsprod/db/tech_st/11.2.0/network/admin]$

louth[/u01/oracle/fsprod/db/tech_st/11.2.0.4]$ sqlplus system/fsprod123@fusprod-scan:1522/FSPROD.retail2u.trcg.co.uk

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 24 02:48:59 2016

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL>

==========================================

If you are upgrading a cluster database from releases 10.2, 11.1, or 11.2, then upgrade the database configuration in Oracle Clusterware using the following command:

$ srvctl upgrade database -d db-unique-name -o oraclehome

Run catuppst.sql to perform upgrade actions that do not require the database to be in UPGRADE mode:

SQL> @catuppst.sql

Run utlrp.sql to recompile any remaining stored PL/SQL and Java code.

SQL> @utlrp.sql

· If you are upgrading a cluster database from releases 10.2, 11.1, or 11.2, then upgrade the database configuration in Oracle Clusterware using the following command:

$ srvctl upgrade database -d db-unique-name -o oraclehome

Upgrade/Downgrade 10gR2 <=> 11gR2

After I tested upgrade Oracle Database 10gR2 to 11gR2 by command-line. I just curious to downgrade Oracle Database 11gR2 to 10gR2. One thing, If we need to downgrade Database, don't change "compatible" parameter.

10G ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
11G ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1

Step: Upgrade Oracle Database 10.2.0.5 to 11.2.0.2

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
orcl

- Check "compatible" parameter

SQL> show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 10.2.0.5.0

- Check Oracle Version

- Check by pre-upgrade script

SQL> @utlu112i.sql
Oracle Database 11.2 Pre-Upgrade Information Tool 12-29-2010 17:29:14
Script Version: 11.2.0.2.0 Build: 001.
**********************************************************************
Database:
**********************************************************************
--> name: ORCL
--> version: 10.2.0.5.0
--> compatible: 10.2.0.5.0
--> blocksize: 8192
--> platform: Linux x86 64-bit
--> timezone file: V4.
.
.
.
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Oracle Workspace Manager [upgrade] VALID
--> OLAP Analytic Workspace [upgrade] VALID
--> OLAP Catalog [upgrade] VALID
--> EM Repository [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Spatial [upgrade] VALID
--> Data Mining [upgrade] VALID
--> Expression Filter [upgrade] VALID
--> Rule Manager [upgrade] VALID
--> Oracle OLAP API [upgrade] VALID
.
.
.
**********************************************************************
Recommendations
**********************************************************************
Oracle recommends gathering dictionary statistics prior to
upgrading the database.
To gather dictionary statistics execute the following command
while connected as SYSDBA:

EXECUTE dbms_stats.gather_dictionary_stats;

**********************************************************************
Oracle recommends reviewing any defined events prior to upgrading.

To view existing non-default events execute the following commands
while connected AS SYSDBA:
Events:
SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2
WHERE UPPER(name) ='EVENT' AND isdefault='FALSE'

Trace Events:
SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2
WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'

Changes will need to be made in the init.ora or spfile.
**********************************************************************

- Gather stats and truncate AUD$ table

SQL> EXECUTE dbms_stats.gather_dictionary_stats;

SQL> truncate table SYS.AUD$ drop storage;

- Start to upgrade by "catupgrd.sql" script

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

$ cp /u01/app/oracle/product/10.2.0/db_1/dbs/orapworcl /u01/app/oracle/product/11.2.0/dbhome_1/dbs/
$ cp /u01/app/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora /u01/app/oracle/product/11.2.0/dbhome_1/dbs/
$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
$ /u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus /nolog

SQL> connect / as sysdba
Connected to an idle instance.
SQL>> startup upgrade;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 730714112 bytes
Fixed Size 2230080 bytes
Variable Size 205523136 bytes
Database Buffers 515899392 bytes
Redo Buffers 7061504 bytes
Database mounted.
Database opened.

SQL> spool upgrade.log
SQL> set echo on
SQL> set termout on
SQL> @?/rdbms/admin/catupgrd.sql
.
.
.
SQL> Rem Set errorlogging off
SQL> SET ERRORLOGGING OFF;
SQL>
SQL> Rem *********************************************************************
SQL> Rem END catupgrd.sql
SQL> Rem *********************************************************************

After run "catupgrd.sql", Instance should shutdown
- Step to run "catuppst.sql" script(This is post upgrade script: only necessary when upgrading from ≥ 10.1)

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 730714112 bytes
Fixed Size 2230080 bytes
Variable Size 360712384 bytes
Database Buffers 360710144 bytes
Redo Buffers 7061504 bytes
Database mounted.
Database opened.

SQL> show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 10.2.0.5.0

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

SQL> @?/rdbms/admin/catuppst.sql

- Generate fixed object stats

SQL> exec dbms_stats.gather_fixed_objects_stats;

PL/SQL procedure successfully completed.

- Recompile

SQL> @?/rdbms/admin/utlrp.sql

- Run post-Upgrade script

SQL> @?/rdbms/admin/utlu112s.sql

- Compare invalid objects scripts

SQL> @?/rdbms/admin/utluiobj.sql

- Adjust time zone data

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup upgrade
ORACLE instance started.

Total System Global Area 939495424 bytes
Fixed Size 2232088 bytes
Variable Size 251658472 bytes
Database Buffers 679477248 bytes
Redo Buffers 6127616 bytes
Database mounted.
Database opened.

SQL> exec dbms_dst.begin_upgrade(new_version => 11);

PL/SQL procedure successfully completed.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 939495424 bytes
Fixed Size 2232088 bytes
Variable Size 251658472 bytes
Database Buffers 679477248 bytes
Redo Buffers 6127616 bytes
Database mounted.
Database opened.

SQL> declare num_of_failures number;
begin
dbms_dst.upgrade_database(num_of_failures);
dbms_output.put_line(num_of_failures);
dbms_dst.end_upgrade(num_of_failures);
dbms_output.put_line(num_of_failures);
end;
/

- Check Oracle database after Upgrade

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

SQL> show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 10.2.0.5.0

Need to Downgrade !!! Don't change "compatible" parameter

Step: Downgrade Oracle Database 11.2.0.2 to 10.2.0.5

- Check Oracle version and "compatible" parameter

-- Make sure "compatible" parameter is not changed.
- Start Oracle database for downgrade (11gR2 Home)

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> STARTUP DOWNGRADE
ORACLE instance started.

Total System Global Area 939495424 bytes
Fixed Size 2232088 bytes
Variable Size 251658472 bytes
Database Buffers 679477248 bytes
Redo Buffers 6127616 bytes
Database mounted.
Database opened.

- If use EM, then drop EM user

SQL> DROP USER sysman CASCADE;

User dropped.

- Run "catdwgrd.sql" script to downgrade

SQL> SPOOL downgrade.log
SQL> @?/rdbms/admin/catdwgrd.sql
.
.
.
SQL> Rem ***********************************************************************
SQL> Rem END catdwgrd.sql
SQL> Rem ***********************************************************************

- Shutdown database

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

- Start Oracle database from 10gR2 Home and use "sqlplus" from 10gR2

$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
$ /u01/app/oracle/product/10.2.0/db_1/bin/sqlplus /nolog

SQL> connect / as sysdba
Connected to an idle instance.

SQL> STARTUP UPGRADE
ORACLE instance started.

Total System Global Area 734003200 bytes
Fixed Size 2099136 bytes
Variable Size 192940096 bytes
Database Buffers 532676608 bytes
Redo Buffers 6287360 bytes
Database mounted.
Database opened.

- Run "catrelod.sql" script reloads the appropriate version of all of the database components in the downgraded database

SQL> SPOOL reload.log

SQL> @?/rdbms/admin/catrelod.sql
.
.
.
COMP_NAME STATUS VERSION
----------------------------------- ----------- ----------
Oracle Database Packages and Types VALID 10.2.0.5.0
Oracle Database Catalog Views VALID 10.2.0.5.0
JServer JAVA Virtual Machine VALID 10.2.0.5.0
Oracle XDK VALID 10.2.0.5.0
Oracle Database Java Packages VALID 10.2.0.5.0
Oracle Text VALID 10.2.0.5.0
Oracle XML Database VALID 10.2.0.5.0
Oracle Workspace Manager VALID 10.2.0.5.0
Oracle Data Mining VALID 10.2.0.5.0
OLAP Analytic Workspace VALID 10.2.0.5.0
OLAP Catalog VALID 10.2.0.5.0
Oracle OLAP API VALID 10.2.0.5.0
Oracle interMedia VALID 10.2.0.5.0
.
.
.

SQL> SPOOL OFF

- Shutdown & Startup database and then recompile

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 734003200 bytes
Fixed Size 2099136 bytes
Variable Size 247466048 bytes
Database Buffers 478150656 bytes
Redo Buffers 6287360 bytes
Database mounted.
Database opened.

SQL> @?/rdbms/admin/utlrp.sql

- Check Oracle version

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production

SQL> show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 10.2.0.5.0

You could copy it from the tnsnames file in the old Oracle Home

/u05/oracle/TESTDB/product/11.2.0/network/admin

[Node1:testdba:admin] cd /u05/oracle/TESTDB/product/11.2.0/network/admin

[Node1:testdba:admin] ls -ltr

total 40

-rw-r--r-- 1 testdba dba 187 May 7 2007 shrept.lst

drwxr-xr-x 2 testdba dba 256 Jul 6 2011 samples

-rw-r--r-- 1 testdba dba 89 Jul 20 2011 afiedt.buf

-rw-r--r-- 1 testdba dba 187 Oct 23 2011 TESTDB1_Node1_ifile.ora

-rw-r--r-- 1 testdba dba 517 Feb 8 2013 tnsnames.ora_08022013

-rw-r--r-- 1 testdba dba 717 Feb 8 2013 tnsnames.ora

[Node1:fusppt:admin]

cd /var/opt/oracle/DBA/logs

cd /u05/oracle/TESTDB/product/11.2.0/network/admin

ls -ltr

pwd

cp -p tnsnames.ora tnsnames.ora_08022013 TESTDB1_Node1_ifile.ora /u05/oracle/TESTDB/product/11.2.0.4/network/admin/

ls -ltr /u05/oracle/TESTDB/product/11.2.0.4/network/admin/

crontab -l

RMAN> upgrade catalog;

rman target /

connect to the catalog user

then run upgrade catalog;

ps -ef|grep -i TESTDB|wc -l

-- backup rman check--

You could copy it from the tnsnames file in the old Oracle Home

/u05/oracle/TESTDB/product/11.2.0/network/admin

[Node1:testdb:admin] cd /u05/oracle/TESTDB/product/11.2.0/network/admin

[Node1:testdb:admin] ls -ltr

total 40

-rw-r--r-- 1 testdba dba 187 May 7 2007 shrept.lst

drwxr-xr-x 2 testdba dba 256 Jul 6 2011 samples

-rw-r--r-- 1 testdba dba 89 Jul 20 2011 afiedt.buf

-rw-r--r-- 1 testdba dba 187 Oct 23 2011 TESTDB1_Node1_ifile.ora

-rw-r--r-- 1 testdba dba 517 Feb 8 2013 tnsnames.ora_08022013

-rw-r--r-- 1 testdba dba 717 Feb 8 2013 tnsnames.ora

[Node1:testdb:admin]

cd /var/opt/oracle/DBA/logs

cd /u05/oracle/TESTDB/product/11.2.0/network/admin

ls -ltr

pwd

cp -p tnsnames.ora tnsnames.ora_08022013 TESTDB1_Node1_ifile.ora /u05/oracle/TESTDB/product/11.2.0.4/network/admin/

ls -ltr /u05/oracle/TESTDB/product/11.2.0.4/network/admin/

crontab -l

RMAN> upgrade catalog;

rman target /

connect to the catalog user

then run upgrade catalog;

ps -ef|grep -i TESTDB|wc -l

and create link in new home

------------------------

pwd

/u05/oracle/TESTDB/product/11.2.0/lib

-rwxr-xr-x 1 testdba dba 727656 Jul 8 2011 libasmclnt11.so

lrwxrwxrwx 1 testdba dba 19 Oct 26 2011 libobk.a -> /usr/lib/libobk64.a

-rw-r--r-- 1 testdba dba 9985523 Nov 2 2012 libpls11.a

9:24:09 PM: D: from Old HOME

9:24:38 PM: D: Go to new home

9:24:39 PM: DP: /u05/oracle/TESTDB/product/11.2.0.4/lib

ln -s /usr/lib/libobk64.a libobk

=======================================================

12c Grid Infrastructure Upgrade on Node1/Node2 from 11g

Preparation

Created 12102_Grid directory under /staging and copied the following files there:

aix.ppc64_12102_grid_1of2.zip

aix.ppc64_12102_grid_2of2.zip

p22191349_121020_AIX64-5L.zip (Jan 2016 Grid PSU)

Unzip each of the files.

cd /staging/12102_Grid/grid

Run CVU to validate readiness for Clusterware upgrade:

Created /staging12102_Grid/tmp because /tmp is too small on preston to hold the output.

export CV_HOME=/staging/12102_Grid/tmp

./runcluvfy.sh stage -pre crsinst -upgrade -rolling -src_crshome /u02/oracle/11.2.0.3/grid -dest_crshome /u02/oracle/12.1.0.2/grid -dest_version 12.1.0.2.0 -fixup -verbose

Check output for failures.

Also downloaded ORAchk (MOS Note:1268927.1) to /staging. Unzip the file and run (instructions say as RDBMS owner):

orachk -u -o pre

Check the output for failures.

Running the Upgrade

From an X Windows session logged on to preston as oracrs. Set DISPLAY

e.g. export DISPLAY=10.125.34.42:0.0

unset ORACLE_BASE

unset ORACLE_HOME

unset ORACLE_SID

./runInstaller

Prompted to run rootpre.sh on both nodes (copied the installation zip files over to upton and unzipped it to run rootpre.sh).

Click Next.

Click Next which gave the following warnings:

Click Yes.

Edit both locations as on the screenshot below.

This gave a warning that it couldn’t create /u02/oracle/12.1.0/grid due to permissions. Open a new session and sudo to root and create this directory manually on both nodes and change permissions on 12.1.0 and grid directories to 755 and the ownership on both to oracrs:dba.

Click Yes.

Click Next.

Tick Ignore All and click Next.

Click Yes.

Click Install.

Click Yes.

Check logs under /u02/oracle/oraInventory/logs:

INFO: Exception occured during spawning :Cannot run program "/u02/oracle/12.1.0/grid/perl/bin/perl": error=13, Permission denied

This directory didn’t have execute permissions.

A separate .err file indicates we ran out of space in /tmp prior to the above error which could be the root cause.

Aborted the install.

Increased /tmp to 6.75GB on preston and 5.5GB on upton and then reran.

[preston:root:/u02/oracle/12.1.0/grid:] ./rootupgrade.sh

Performing root user operation.

The following environment variables are set as:

ORACLE_OWNER= oracrs

ORACLE_HOME= /u02/oracle/12.1.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:

The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Performing root user operation.

The following environment variables are set as:

ORACLE_OWNER= oracrs

ORACLE_HOME= /u02/oracle/12.1.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:

The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Using configuration parameter file: /u02/oracle/12.1.0/grid/crs/install/crsconfig_params

2016/05/05 14:48:44 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.

2016/05/05 14:49:37 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.

2016/05/05 14:49:50 CLSRSC-464: Starting retrieval of the cluster configuration data

2016/05/05 14:50:22 CLSRSC-465: Retrieval of the cluster configuration data has successfully completed.

2016/05/05 14:50:22 CLSRSC-363: User ignored prerequisites during installation

2016/05/05 14:50:49 CLSRSC-515: Starting OCR manual backup.

2016/05/05 14:50:56 CLSRSC-516: OCR manual backup successful.

2016/05/05 14:51:14 CLSRSC-468: Setting Oracle Clusterware and ASM to rolling migration mode

2016/05/05 14:51:14 CLSRSC-482: Running command: '/u02/oracle/12.1.0/grid/bin/asmca -silent -upgradeNodeASM -nonRolling false -oldCRSHome /u02/oracle/11.2.0.3/grid -oldCRSVersion 11.2.0.3.0 -nodeNumber 1 -firstNode true -startRolling true'

ASM configuration upgraded in local node successfully.

2016/05/05 14:51:35 CLSRSC-469: Successfully set Oracle Clusterware and ASM to rolling migration mode

2016/05/05 14:51:35 CLSRSC-466: Starting shutdown of the current Oracle Grid Infrastructure stack

2016/05/05 14:53:47 CLSRSC-467: Shutdown of the current Oracle Grid Infrastructure stack has successfully completed.

User oracrs has the required capabilities to run CSSD in realtime mode

OLR initialization - successful

2016/05/05 15:13:33 CLSRSC-329: Replacing Clusterware entries in file '/etc/inittab'

CRS-4133: Oracle High Availability Services has been stopped.

CRS-4123: Oracle High Availability Services has been started.

2016/05/05 15:28:01 CLSRSC-472: Attempting to export the OCR

2016/05/05 15:28:01 CLSRSC-482: Running command: 'ocrconfig -upgrade oracrs dba'

2016/05/05 15:28:16 CLSRSC-473: Successfully exported the OCR

2016/05/05 15:28:39 CLSRSC-486:

At this stage of upgrade, the OCR has changed.

Any attempt to downgrade the cluster after this point will require a complete cluster outage to restore the OCR.

2016/05/05 15:28:39 CLSRSC-541:

To downgrade the cluster:

1. All nodes that have been upgraded must be downgraded.

2016/05/05 15:28:40 CLSRSC-542:

2. Before downgrading the last node, the Grid Infrastructure stack on all other cluster nodes must be down.

2016/05/05 15:28:40 CLSRSC-543:

3. The downgrade command must be run on the node preston with the '-lastnode' option to restore global configuration data.

2016/05/05 15:29:03 CLSRSC-343: Successfully started Oracle Clusterware stack

clscfg: EXISTING configuration version 5 detected.

clscfg: version 5 is 11g Release 2.

Successfully taken the backup of node specific configuration in OCR.

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'system'..

Operation successful.

2016/05/05 15:29:52 CLSRSC-474: Initiating upgrade of resource types

2016/05/05 15:30:56 CLSRSC-482: Running command: 'upgrade model -s 11.2.0.3.0 -d 12.1.0.2.0 -p first'

2016/05/05 15:30:57 CLSRSC-475: Upgrade of resource types successfully initiated.

2016/05/05 15:31:15 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

[upton:root:/u02/oracle/12.1.0/grid:] ./rootupgrade.sh

Performing root user operation.

The following environment variables are set as:

ORACLE_OWNER= oracrs

ORACLE_HOME= /u02/oracle/12.1.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:

The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Performing root user operation.

The following environment variables are set as:

ORACLE_OWNER= oracrs

ORACLE_HOME= /u02/oracle/12.1.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:

The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Using configuration parameter file: /u02/oracle/12.1.0/grid/crs/install/crsconfig_params

2016/05/05 15:33:37 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.

2016/05/05 15:34:31 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.

2016/05/05 15:34:37 CLSRSC-464: Starting retrieval of the cluster configuration data

2016/05/05 15:34:56 CLSRSC-465: Retrieval of the cluster configuration data has successfully completed.

2016/05/05 15:34:56 CLSRSC-363: User ignored prerequisites during installation

ASM configuration upgraded in local node successfully.

2016/05/05 15:35:30 CLSRSC-466: Starting shutdown of the current Oracle Grid Infrastructure stack

2016/05/05 15:37:36 CLSRSC-467: Shutdown of the current Oracle Grid Infrastructure stack has successfully completed.

User oracrs has the required capabilities to run CSSD in realtime mode

OLR initialization - successful

2016/05/05 15:38:26 CLSRSC-329: Replacing Clusterware entries in file '/etc/inittab'

CRS-4133: Oracle High Availability Services has been stopped.

CRS-4123: Oracle High Availability Services has been started.

2016/05/05 15:43:08 CLSRSC-343: Successfully started Oracle Clusterware stack

clscfg: EXISTING configuration version 5 detected.

clscfg: version 5 is 12c Release 1.

Successfully taken the backup of node specific configuration in OCR.

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'system'..

Operation successful.

Start upgrade invoked..

2016/05/05 15:44:52 CLSRSC-478: Setting Oracle Clusterware active version on the last node to be upgraded

2016/05/05 15:44:53 CLSRSC-482: Running command: '/u02/oracle/12.1.0/grid/bin/crsctl set crs activeversion'

Started to upgrade the Oracle Clusterware. This operation may take a few minutes.

Started to upgrade the OCR.

Started to upgrade the CSS.

The CSS was successfully upgraded.

Started to upgrade Oracle ASM.

Started to upgrade the CRS.

The CRS was successfully upgraded.

Successfully upgraded the Oracle Clusterware.

Oracle Clusterware operating version was successfully set to 12.1.0.2.0

2016/05/05 15:47:48 CLSRSC-479: Successfully set Oracle Clusterware active version

2016/05/05 15:48:01 CLSRSC-476: Finishing upgrade of resource types

2016/05/05 15:48:18 CLSRSC-482: Running command: 'upgrade model -s 11.2.0.3.0 -d 12.1.0.2.0 -p last'

2016/05/05 15:48:19 CLSRSC-477: Successfully completed upgrade of resource types

2016/05/05 15:49:42 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

Back in the X Windows session Click OK.

Click Close.

Took about 2 hours from restarting after the failure.

EasyReliableDBA

Friday 19 August 2022

RAC database upgrade from 11.2.0.3 to 11.2.0.4

Upgrade/Downgrade 10gR2 <=> 11gR2

No comments:

Post a Comment

Search This Blog