Skip to main content

CRS Upgrade from 11g to 12c



Complete Steps:
=============

1. Pre Health checks

 Take following command output by login as ororacrs user to one of the CRS node

    crs_stat -t
    crs_stat -t |grep vip
    crs_stat -t |grep ons
    crsctl query crs activeversion

    crsctl query crs softwareversion
    ocrcheck
    ocrcheck -config
    crsctl query css votedisk

    crsctl check crs
    crsctl check cluster -all
    crsctl stat res -t -init


 2. Set black out and perform pre health checks


 3. Stop services


    Stop all web services   
    Stop all app services   

    Stop db services using following commands
   

    login as ortest on one DB node only - and run:
   


        $ORACLE_HOME/bin/srvctl status database -d test
        $ORACLE_HOME/bin/srvctl stop database -d test
        $ORACLE_HOME/bin/srvctl stop listener -l test
   
 
4. Take Cold backup.


5. Run following command to check the readiness of the current grid home to upgrade.


    cd /softwares/12102BIT64/grid/

    ./runcluvfy.sh stage -pre crsinst -upgrade -rolling -src_crshome /oracrs/oracle/product/11204 -dest_crshome /oracrs/oracle/product/12102 -dest_version 12.1.0.2.0
   

    Go to /tmp/CVU_12.1.0.2.0_ororacrs
    Ask SA to run "runfixup.sh" script as root user.


   
    Once done, run the "runcluvfy.sh" again & make sure All checks should be passed.

   

6. Proceed 12C Grid installation

    crsctl query crs softwareversion node1
    crsctl query crs softwareversion node2

    crsctl check cluster -all

    $unset ORACLE_BASE
    $unset ORACLE_HOME


    ***** Login to the host "node1" as "ororacrs" user  & make sure CRS services are up ****
   

    cd /softwares/12102BIT64/grid/
    $./runInstaller


    ==> skip software updates
    ==> Select 3rd option for upgrade and Click Next
    ==> English
    ==> Select two nodes
    ==> Next
    ==> provide new software location - /oracrs/oracle/product/12102
    ==> Next
    ==> Install
    ==> promt you to run rootupgrade.sh
    ==> exit


7.     Post Checks:


    cd /autofs/upgrade/ebso/linux/SOURCE/ORACLE12C/12102BIT64/grid

    ./runcluvfy.sh stage -post crsinst -upgrade -rolling -src_crshome /oracrs/oracle/product/11204 -dest_crshome /oracrs/oracle/product/12102 -dest_version 12.1.0.2.0
   
    OR

    ./runcluvfy.sh stage -post crsinst -n node1,node2
   


    crsctl query crs releaseversion
    crsctl query crs softwareversion

    crsctl query crs activeversion -f


    ps -ef |grep pmon


    ./oclumon manage -get reppath
    ./srvctl status mgmtdb -verbose
    ./srvctl config mgmtdb
   
   


            ****** CRS Upgrade Completed to 12c *********   

Comments

Popular posts from this blog

CLSRSC-430: Failed to start rolling patch mode

############################################################ GRID PSU Failed on Node2: =========================== [root@server1 tmp]# /oracrs/oracle/product/12102/OPatch/opatchauto apply /path1/patches/23273629 -oh /oracrs/oracle/product/12102 -ocmrf /tmp/ocm.rsp OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI Version        : 12.1.0.2.0 Running from       : /oracrs/oracle/product/12102 opatchauto log file: /oracrs/oracle/product/12102/cfgtoollogs/opatchauto/23273629/opatch_gi_2016-11-25_06-13-44_deploy.log Parameter Validation: Successful Configuration Validation: Successful Patch Location: /path1/patches/23273629 Grid Infrastructure Patch(es): 21436941 23054246 23054327 23054341 DB Patch(es): 23054246 23054327 The following patch(es) are duplicate patches with patches installed in the Oracle Home.  [ 20299023] You hav...

SQL Plan Management [ SPM ]

============================================= SQL> SHOW parameter baselines NAME                                 TYPE        VALUE ------------------------------------ ----------- ------- optimizer_capture_sql_plan_baselines boolean     FALSE optimizer_use_sql_plan_baselines     boolean     TRUE SQL> ============================================= Connect as SPM user and create a table as follows. -------------------------------------------------- SQL> CREATE TABLE EMPLOYEE (code number,dept char(100),address char(1000)); Table created. SQL> ============================================= Populate some rows in the table =================================== declare c1 number; begin for c1 IN 1..10000 ...