Upgrades

Upgrades :


 http://edba.blogspot.in/2017/12/rac-rolling-upgrade-11203-to-11204.html

 http://edba.blogspot.in/2017/12/perform-gi-rolling-upgrade-1.html

http://oracle-help.com/oracle-rac/upgrading-oracle-grid-infrastructure-11gr2-12cr2/

http://oracle-help.com/oracle-12c/oracle-12cr2/upgrade-oracle-11gr2-11-2-0-4-database-12cr2-12-2-0-1/

http://oracle-help.com/oracle-12c/oracle-12cr2/manual-upgrading-oracle-database-11gr2-to-12cr2/

http://oracle-help.com/oracle-12c/oracle-12cr2/upgrade-oracle-12-2-dbupgrade-utility/

http://oracle-help.com/dataguard/standby-first-patch-apply-dataguard-rolling-patch-oracle-rac-12c/


Software Upgrade :

http://en.community.dell.com/techcenter/enterprise-solutions/w/oracle_solutions/5268.how-to-upgrade-oracle-11gr2-grid-infrastructure-to-oracle-12cr1

http://en.community.dell.com/techcenter/enterprise-solutions/w/oracle_solutions/5267.how-to-upgrade-oracle-11gr2-database-software-to-oracle-12cr1

11g upgrade main steps  :

1. utlu11i : Pre upgrade information script
   utlu11x

2. stratup upgrade pfile=$ORACLE_HOME/dbs/initoracl.ora
   @catupgrd

3. utlu11s : Post upgrade status script
   utlrp : Recompilation script


startup downgrade pfile=$ORACLE_HOME/dbs/initoracl.ora

@catdwgrd




Upgrade Scripts :

?/rdbms/admin/utlu112i.sql : Initila Pre-Upgrade Information Tool

?/rdbms/admin/utlrp.sql : Compile Invalid objects

?/rdbms/admin/catupgrd.sql : Actual upgrade script

?/rdbms/admin/catuppst.sql : perform upgrade actions that do not require the database to be in UPGRADE mode


?/rdbms/admin/utlu112s.sql : Summary of the upgrade at the end. Displays upgraded components with upgrade timings

?/home/oracle/dbupgdiag.sql: Components in dba_registry

?/rdbms/admin/utluiobj.sql : Invalid objects that were not invalid prior to upgrade




Rolling upgrades

Oracle Clusterware Rolling Upgrades
Note : Rolling upgrades cannot be peformed on a shared Oracle Clusterware home directory

Set a blackout in Grid Control.
Download patch in directory outside ORACLE_HOME or CRS_HOME

1. Create a backup of the Oracle software.

2. Stop all processes(IAN,LC) that use Clusterware

node1> srvctl stop instance -d racdba -i racdba1
node1> srvctl stop asm -n node1
node1> srvctl stop nodeapps -n node1
node1> lsnrctl stop LISTENER_racdba1
node1> crsctl stop crs

Stop all services

3. $ORA_CRS_HOME/upgrade/preupdate.sh -crshome $ORA_CRS_HOME -crsuser crs

4. Run OUI (downloaded with the patch update or inthe software) from this node and choose only the node which is currently prepared for the rolling upgrade.Complete all steps inclusing $ORA_CRS_HOME/install/rootupgrade.sh



 Oracle ASM Rolling Upgrades( 11g onwards )

NOTE : Upgrade will fail if there are any rebalance operations currently being performed.
       Before upgrading ASM , first fully upgrade clusterware on all nodes.


1. +ASM1 > alter system start rolling migration to '11.1.0.7'

2. Stop the first instance , asm and listener (IA-L)

     node1> srvctl stop instance -d racdba -i racdba1

    node1> sqlplus sys as sysasm ( You will see 11.1.0.6 here )
    SQL> shutdown immediate;

    node1> lsnrctl stop LISTENER_racdba1

    node1> srvctl status   service -d racdba -s rac1_service


3. Proceed with upgrading the +ASM1 to 11.1.0.7


4. Once ASM1 is upgraded , start listener, asm and instance

    node1> lsnrctl start LISTENER_racdba1
    node1> sqlplus sys as sysasm ( You will see 11.1.0.7 here )
   SQL> startup;
    node1> srvctl start instance -d racdba -i racdba1


5. Now stop the second instance and apply the patch on node 2 and then start the instance


6. After patch has been applied to all the ASM Oracle Home’s we will see a message if using GUI      and we can issue the following command

+ASM1 > alter system stop rolling migration;


7. Relocate the services back to original

    unix_serv2> srvctl relocate service -d racdba -s rac1_service  -i racdba2 -t racdba1 -f
    unix_serv2> srvctl status   service -d racdba -s rac1_service


Database rolling upgrades

1. Using Data Guard SQL Apply  ( 10.1.0.3 onwards )

   Pros  :

   Not all   datatypes supported by SQL Apply
   Data Guard Broker not supported
   Not supported by OEM Grid Control
   Data Guard protection cannot be “maximum protection”
   LOG_ARCHIVE_DEST_n for the logical standby must be OPTIONAL
   COMPATIBLE must be the lower version

   Crons : 
   If something goes wrong with the upgrade, you are safe



2. Using Physical Standby Databases and Transient Logical Standby 11g  ( 11g onwards )
    Logical Standby Upgrade




AutoStart 

[root]# /etc/init.d/init.cssd stop css
------------


/etc/init.d/init.cssd comes alive
+ASM warm started.



ASM :
======

Make dbora file in /etc/init.d/

/etc/init.d/dbora start |status | stop

chgrp dba /etc/init.d/dbora
chmod 755 /etc/init.d/dbora

chkconfig --add dbora
chkconfig --list dbora


ln -s /etc/init.d/dbora /etc/rc.d/rc0.d/K01dbora
ln -s /etc/init.d/dbora /etc/rc.d/rc3.d/S99dbora
ln -s /etc/init.d/dbora /etc/rc.d/rc5.d/S99dbora

edit /etc/initab and move last line  h1:35:respawn:/etc/init.d/init.cssd run </dev/null 2>&1 >/dev/null to line between l2: and l3

http://damir-vadas.blogspot.com/2014/03/install-oracle-11107-x64-asm-on-centos.html



DB Auto start and stop


11gR2

Make use of dbstart and dbshut in $OH/bin


$ chmod 750 /etc/init.d/oracle    oracle script calls dbstart and dbshut
$ chkconfig --add oracle          add oracle script as a service


$ service oracle stop
$ service oracle start

https://matthiashoys.wordpress.com/2012/04/20/automatically-start-oracle-11g-on-oracle-linux-6-2-after-server-reboot/