ORACLE Upgradation 11.2.0.1.0 to 11.2.0.4.0

in Windows server

Major steps:

Step 1.       Download the software Oracle 11.2.0.4.0

Step 2.       Create New Home ( to download new Oracle software )

Step 3.       Change the environment variable to 11.2.0.4

Step 4.       Run the setup.exe using Run as administrator from 11.2.0.4

Step 5.       Run DBUA.bat from 11.2.0.4 Oracle_home

Step 6.       Run Post installation processes

Details in Below


Step 1.  Download the software Oracle 11.2.0.4.0

from oracle support or from SAP marketplace

Step 2. Create New Home inside the folder where dbhome_1  

             Is situated

For e.g.    .     D:/u01/app/oracle/product/11.2.0.4/dbhome_1 (Old Home)

                   D:/u01/app/oracle/product/11.2.0.4/dbhome_2 (New Home)

Step 3. Change the environment variable Path to 11.2.0.4                

(New Oracle Software)

                     ORACLE_HOME= D:/u01/app/oracle/product/11.2.0.4/dbhome_2

Step 4. Run the setup.exe using Run as administrator from

            11.2.0.4

https://static.wixstatic.com/media/916743_3887630d0a3c4aa591dc45f2d5b2006a~mv2.png/v1/fill/w_882,h_365,al_c,lg_1/916743_3887630d0a3c4aa591dc45f2d5b2006a~mv2.png

Here we are selecting the the security updates.  Depending upon your requirement select the check box and then click on Next

https://lh5.googleusercontent.com/OIxMbg0QBNGEJo8UuZ07kKQhHZ502qYyWOph7NTYenFEryFVHQFluRJAELsz3DcGGdltyD_7ObHQ7-XFFLYE1tQwLgSV7rWOJ1699bQhPr-44hAgLIcRU36hBu47OwIwZsKLsuWVFJw

Select Skip Software updates and click on next

https://lh3.googleusercontent.com/WlJ-B7ZpYmCzntX6lAKK6s-kdT32sdAdIS5AmYLGySj_I6u2ujqi-be-uYTan2OKzdW6qbTYvsevzDKEwni4O3jkTDNp5NH8SxrkxGZnZwqLL38OUlwPjlkXr3h--DocEa0hXcf9o9o

Click on yes

https://static.wixstatic.com/media/916743_51574f6191544e46bd95b3e6e072f7b7~mv2.png/v1/fill/w_718,h_241,al_c,lg_1/916743_51574f6191544e46bd95b3e6e072f7b7~mv2.png

Note : Here we are installing the database software only because once the database software is installed we use Database upgrade assistant to upgrade the database from 11.2.0.1.0  to 11.2.0.4.0

https://lh3.googleusercontent.com/hRgae329iglKv5XHaaJOG6dX3Z8EhHbcXPsltKIXFa_2Ks26TmFJ8Y7nHdZBI5jF2VHKkQn-NgdR2ZIGQBfGoQPG2tylXNeLPZifq9BcSYxbmu2YtnOgEUhhYtST8oUGcoTSeHOB76k

Select Single Instance Database Installation and click on Next

https://lh4.googleusercontent.com/QcsQnxynQH-a_gKLR0geIDCZhrdf44j5e6I_QxThvmGh-aw8efeHYkSuR6sdIkplTTMvXMolIiEKLrPdEiASsgdqGIIUq8JnnwNReMCW8yAp1KJutL49AYTWJFyKtwDjE7AV1KbOXhk

Select the Language then click on Next

https://static.wixstatic.com/media/916743_d83abcf3f78f4a419e951316ce7830ab~mv2.png/v1/fill/w_797,h_596,al_c/916743_d83abcf3f78f4a419e951316ce7830ab~mv2.png

Select Enterprise Edition and click on Select Options

https://static.wixstatic.com/media/916743_c418781b0f294d63bff516151f64bb13~mv2.png/v1/fill/w_797,h_597,al_c/916743_c418781b0f294d63bff516151f64bb13~mv2.png

Select only Oracle Partitioning if analytic calculations are not performed in your organization i.e.  not have

BI (Business Intelligence) Server .Otherwise, no need to change

Enter the Installation path and click on Next

https://lh6.googleusercontent.com/i_7gRUeItNHMuHvlpdX_SAqkFIG4ouazx5cgEn7hDQk1tGk3hYIa-zwCrsNShL6_Htl3ac0QXetyGldNgMnVBIzb6IV1jpeZwITvaGnGvqcQ_ROKGxSfVwdCEyzJe-J6ScKUJy94208

https://lh4.googleusercontent.com/4VsztooklIX9tGhVQgb1oMjKxkGoNCkIzGQmVDSxgJ7LvdzMqo7QFvwJ1DvbDSxxiqE6FHJ94CWxAF99LgAKAQYd516gTXJvNk3qnnBIwkGz7bvaMhNvGEKicp2fssGZwWWf-P4xhMY

Verify the summary screen and then click on Install

https://lh6.googleusercontent.com/vudnIDhBpOHiBn3uuI5q1esrksbzULoBWytV2h7CME3tqNSI0BNNvhwCKi45orOSc-F548ENRNqPeo2U8ZLRYAK8KFWEWBNGHUqomEcfk7sjn1AC-grtsYOF4XdTZTvvbj7y4IV77KA

https://lh3.googleusercontent.com/TSS20KEd2VBzEeFA1RcxsL9Oub0hUFNkJe3fz6JiOMxdQfvpo9L6fy6YPXNJW5xwRuy9Q0j2eRduhNeGR30eO8k8-LAHCgl8YcJc1F6cBv8REX_0lFj_84u_38JDXBLhWVyIo_bNmzc

https://lh5.googleusercontent.com/WHs9mafIN82HJoESmYpUnIzpJCjpVWlql1YV1Dn7rr9Bko4z1SRTv-L3qmxBPtIzgeLSscqS90vwij_XcUTCwBxtTSk71R0O3OJjtb0k-iYT1XHdhe9rHfQzU0O_o4RXsZ0qq0GcJfM

https://lh4.googleusercontent.com/pXs7lKUhNznTl7XPXbx5iQmp19BbeJUZlMEzNRo-IxD-czGhYQ5iIrEsOQrbevZc1YW7ca8U1enRxJoOW-M8h23fzc9Mu9a-TDzjeqQdnYGXxJnxFhUs0G6w5vCPgac1asfsAZT6I4c

https://lh6.googleusercontent.com/Pcm-1AUuctVCkBx4-86nABPp5OqKgd--AuziAiD_lKb63j2XasBl_7MrI2Plq65a-EQL4eTQsft8I-r7rbf8Fi2MOClQxHZWUxyM0Zjpm_AqdYkVOEWT3JLasQJLeRKXZh1FY6d2ONs

Step 5. Run DBUA.bat from 11.2.0.4 Oracle_home

   e.g.    D:/u01/app/oracle/product/11.2.0.4/dbhome_2/bin

Database Upgrade assistant is identifying the Oracle Database 11.2.0.1.0

Kindly check the primary Instance which will be upgraded by executing this SQL command in cmd:

SQL> SELECT INSTANCE_NAME, HOST_NAME, VERSION, STARTUP_TIME, STATUS, INSTANCE_ROLE FROM v$instance;

Here our primary DB instance is orcl, so we select it.

https://lh6.googleusercontent.com/ZBgJQCBfqhowJwN3Z7UAVdvYTIE0eL5X5M8W5FXpdGWnfXE189KXypCJSyDlS0wsQ3QSGa0fDv-9juy4xAB4h3Rx__l-6El4736y_44CSuH3VJjg23noEPQTnV-JkqSlhHiUPynNHqQ

Click Next

It is not compulsory to select Upgrade Timezone Version & Backup Database. You can deselect them.

https://lh4.googleusercontent.com/6p5vBVxYOskN6FC-Xk0Y0Q3JzjMfiv6rxy5jtS8UN8G0jLibQVSdiSLDBdGZt9VNLMJQa6-02jZ4iGunx9zil0zhTsQpFF63Yi1v-KZ0YHFxAMiysAMVTCEEfSY7Ak_79fnhqDr-atI

https://static.wixstatic.com/media/916743_292b335d4dcc492ab37a9c64cd005f08~mv2.png/v1/fill/w_751,h_529,al_c/916743_292b335d4dcc492ab37a9c64cd005f08~mv2.png

Click Next

https://lh5.googleusercontent.com/ovIBpD-KAadGzV4B0IHiX_oTV14ZhSHRxSdiI8TNXwuOZBNVlPdY8s38eIXVaU_QvdARLt4Bx-nvBiW3EhcSKcVaw8nzdOLtE_6ILZggn42p9Vyu-F0ieyYI5UH49-9FeJDqZBn4Sug

Click Next

https://static.wixstatic.com/media/916743_6e6f45e2f3e94b1abbb55fc6d5b14bd2~mv2.png/v1/fill/w_752,h_528,al_c/916743_6e6f45e2f3e94b1abbb55fc6d5b14bd2~mv2.png

Keep the FRA Location as it is, you no need to change. Click Next

https://static.wixstatic.com/media/916743_4261d551cbb74f09bbbc7bb76f2f809f~mv2.png/v1/fill/w_755,h_531,al_c/916743_4261d551cbb74f09bbbc7bb76f2f809f~mv2.png

Click Next

https://static.wixstatic.com/media/916743_036855e5a5b24c6b88064ac6b45d8f0d~mv2.png/v1/fill/w_751,h_527,al_c/916743_036855e5a5b24c6b88064ac6b45d8f0d~mv2.png

Click Next

https://static.wixstatic.com/media/916743_4a99a2007a6541f9a6842da3ba1254c5~mv2.png/v1/fill/w_752,h_527,al_c/916743_4a99a2007a6541f9a6842da3ba1254c5~mv2.png

Verify the summary screen and then click on Finish

 Click Next

C:\Users\sap.basis\Desktop\vb vb.jpg

Database Upgrade in Progress

https://lh5.googleusercontent.com/IUFieoAJ1hRajT3jTc_kYlnLSOLxlzXTsaHSnGxRLbaanaDEtZ00vLEggEvIwWQiaA2qov90TIJ_Xi2UNikTk4Gd3rb-9lYtNshWSnaXUnbJxgV3XevxNYEdt0O5aoVMh_Zij9iwctQ

OLAP features, we are not using that errors can be ignore

https://lh4.googleusercontent.com/xXDPUEGBlFnkB8_ilRdxnXEbSxLVx2i4ZO78QlaVJpVEODNhkELLtjEeKIeCt7N-Rjr_0u0FBSJMWogOlTE6RiNTp3kigDnqB6xWZupwkqpx2sIwQJm2uSXV0p4SJrH0hvIzCxO_Uc4

Database Upgrade completed successfully! Click OK to see the results

https://lh4.googleusercontent.com/ESFYFd1gw9qQ4zwfX0B3GY-1YvjzAWpOsNeWqPxwTcOrL6N7sYPiC_AYnSWeXda9Be1KFHg9UMiAul3kElyVmlqf8waLhWM17If07Yqrlbb88ASJxOfe7rknR6jX9PGbOo0Qja-7-dI

https://lh6.googleusercontent.com/u4dzOHUULdmNcJ_iuYvQNdyGUpgirbdb_l3bCmbulsJP8eW66tIQ3owyzLgJu8oXstkZXTGKrRSnwldMZM7RSfaV5hP2NUYIMwC4XQrIOpZ_PLZ35hzdTIS-AVGvb8Sj2imB_pDUogM

Verify whether the upgrade is successful. Then click on close

https://static.wixstatic.com/media/916743_1daf2e4d886b49249ac849f934f4d635~mv2.png/v1/fill/w_655,h_598,al_c/916743_1daf2e4d886b49249ac849f934f4d635~mv2.png

Move the tnsname.ora & listener.ora from the 11.2.0.1.0 location to 11.2.0.4.0 installed location as shown in the screenshot below

https://static.wixstatic.com/media/916743_25237ce15e7448929952eaca2d18b5f7~mv2.png/v1/fill/w_1103,h_374,al_c,lg_1/916743_25237ce15e7448929952eaca2d18b5f7~mv2.png

Step 6. Post installation processes

Once Completed execute following commands:

These are universal commands for Windows Server and Linux Server.

  1. C:\User\Basis>lsnrctl stop; 

  1. C:\User\Basis >lsnrctl start:

 

  1. SQL> SELECT INSTANCE_NAME, HOST_NAME, VERSION, STARTUP_TIME, STATUS, INSTANCE_ROLE FROM v$instance;

 

  1. SQL>SELECT comp_name, version,status FROM dba_registry;

 

  1. SQL>SELECT comp_name, version,status FROM dba_registry WHERE status <> ‘VALID’;

 

  1. Now, we delete old home i.e. dbhome_1;

Got to home_1 location by using “Window Explorer” for e.g. D:/u01/app/oracle/product/11.2.0.4/dbhome_1/deinstall/deinstall and execute deinstall.  ( Same Path for window and Linux server )

 

Press Enter key

Press Enter

Press yes and then Enter key

  1. C:\User\Basis>lsnrctl status;

  1. Check Oracle services by typing ‘services’ in Run if need stop and start home_2 services manually

Or Repeat Step I. and II.

  1. C:\User\Basis>emctl status dbconsole;

 

  1. C:\User\Basis>sqlplus / as sysdba;

 

  1. SQL>SELECT name, open_mode FROM v$database;

 

  1. SQL> SELECT INSTANCE_NAME, HOST_NAME, VERSION, STARTUP_TIME, STATUS, INSTANCE_ROLE FROM v$instance;

 

Database successfully upgraded to 11.2.0.4