Skip to Content
avatar image
Former Member

oracle patch installation

Any one send oracle patches installation step

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 14, 2007 at 01:58 PM

    Hi Ramesh..

    If its on Unix and Oracle 10 G platform then check the note <b>871096</b> for the latet intermin patches to be downloaded

    Copy all the patches to a folder under ur $ORACLE_HOME.

    When u unizp those patches u will get folders with the patch no as foldernames.

    U need to change directory to each folder and u have to execute the command

    <b>opatch apply</b>

    This u have to do for each and every folder.ie if there are 20 patches to be applied u will have 20 folders and u have to this opatch apply individually for each oneof them

    once u finish installation u can check the inventory using lsinventory..

    Hope it was useful...

    Regards

    Bharathwaj V

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 08, 2007 at 07:20 AM

    This document will be used by a qualified DBA to update Oracle patch

    Windows 64bit: Patch #5250981

    Windows 32bit: Patch #5250980

    Opatch Version: 1.0.0.0.55

    perl, version 5.005_03

    This Patch ONLY applies to an Oracle Database SERVER install

    Login into SIDADM User

    Step 1

    &#61656; Take Backup

    &#61656; Backup Oracle inventory under C:\Program files\oracle directory. This will help if there are problems applying the patch, and to restore the Inventory in case of an issue with the patch.

    Step 2

    Non-Clustered System:

    &#61656; Shutdown SAP

    From each Application server then the CI last:

    SAPMMC – select the <hostname> - right click – stop

    Clustered System:

    i. CLUADMIN Goto &#61664; Start &#61664; Run &#61664; cluadmin

    ii. Select the SAP R/3-<SID> group – right click – take offline

    Step 3

    &#61656; Check if there is any backup is running:

    a. Sqlplus /nolog

    b. Connect / as sysdba

    c. Select status from v$backup where status=’ACTIVE’;

    i. If anything shows up, either kill the backup or wait for it to complete based on your requirements.

    Select * from V$backup;

    Note: If anything shows up, either kill the backup or wait for it to complete based on your requirements.

    &#61656; Run the Following Script(SQL) to make it as Not Active Status

    @d: or o:\oracle\<sid>\920\scripts\cr8_alter_tablespace_endbackup.sql

    Step 4

    &#61656; Run the Drop Statistics script against the DB you will be patching to ensure the DB portion of patch will run quickly:

    b. CMD window

    c. cd d: or o:\oracle\<sid>\920\scripts\

    d. Sqlplus /nolog

    e. connect / as sysdba

    f. @d: or o:\oracle\<sid>\920\scripts\cr8_drop_statistics.sql

    g. Exit

    Step 5

    &#61656; Turn off the Password Verify Function:

    @d: or o:\oracle\<sid>\920\scripts\alter_profile_default_reset.sql

    Step 6

    Non-Clustered System:

    &#61656; Shut down the DB and reboot

    i. From the DB server:

    1. sqlplus /nolog

    2. connect / as sysdba

    3. shutdown immediate;

    ii. Reboot the DB server

    Clustered System:

    iii. Select the <SID>DB group – select <SID>.WORLD - right click – take offline

    iv. Move all cluster groups to the opposing node

    v. Reboot the node you are going to patch

    Step 7

    &#61656; Stop all of the Oracle Services, Quest Server Agent, Distributed Transaction Coordinator, EMC Control Center, Netbackup, NT Performance Data Collector, AUTOSYS Remote Agents and MOM on the systems you will be upgrading.

    &#61656; Using Taskmanager – End the MNRAGENT process if it is running.

    o Clustered System:

    &#61607; Stop Oracle<SID>920TNSListenerFsl<sid>db service

    o Non-Clustered:

    &#61607; Stop Oracle<SID>920TNSListener service

    &#61656;

    Step 8

    &#61656; Copy the latest Patch into c:\temp\9.2.0.7.12\5250980

    Step 9

    &#61656; Open a CMD window and type SET command : set o

    a. Check to make sure you have ORACLE_HOME set as a system variable and that it is set to the correct Oracle Home for your system.

    i. Usually d:\oracle\<sid>\920 OR o:\oracle\<sid>\920

    ii. If it is not set enter: set ORACLE_HOME=<d: or o:\oracle\<sid>\920>

    Step 10

    &#61656; In CMD window c:\temp\9.2.0.7.12\5250980

    d:\db\opatch\perl\5.00503\bin\Mswin32-x86\perl d:\db\opatch\opatch_1.0.0.0.55\opatch.pl lsinventory

    You should see a message like below:

    Patch 5188597 applied on Fri Jul 28 16:18:17 PDT 2006

    Step 11

    &#61656; In CMD window c:\temp\9.2.0.7.12\5250980

    d:\db\opatch\perl\5.00503\bin\Mswin32-x86\perl d:\db\opatch\opatch_1.0.0.0.55\opatch.pl apply

    Note:

    Read screen messages and make sure no issues were found during the install check.

    If no issues: Respond with a Y to continue with patch.

    Respond again with a Y to continue when system prompts with:Is this system ready for updating?

    Once the patch has been completed perform the inventory check again to verify: :\db\opatch\perl\5.00503\bin\Mswin32-x86\perl :\db\opatch\opatch_1.0.0.0.55\opatch.pl lsinventory

    b. You should see a message like below:

    Patch 5250981 applied on Mon Aug 28 19:20:28 PDT 2006

    Note: Alternatively, you can check either the inventory logs under C:\Program Files\Oracle\Inventory\logs (go to the bottom of the log file) or run installer to verify if the interim patch was applied successfully

    Step 12

    &#61656; In CMD window c:\temp\9.2.0.7.12\5250980

    d:\db\opatch\perl\5.00503\bin\Mswin32-x86\perl d:\db\opatch\opatch_1.0.0.0.55\opatch.pl lsinventory

    If working on a clustered pair: You must also perform this steps(7,8,9,10,11 &12) on Node B of your cluster to complete the patch.

    Reboot Node B

    Step 13

    Reboot OS

    Step 14

    &#61656; Enable all Services

    &#61656; Start all of the Oracle Services, Quest Server Agent, Distributed Transaction Coordinator, EMC Control Center, Netbackup, NT Performance Data Collector, AUTOSYS Remote Agents and MOM on the systems you will be upgrading.

    o Clustered System:

    &#61607; Start Oracle<SID>920TNSListenerFsl<sid>db service

    o Non-Clustered:

    &#61607; Start Oracle<SID>920TNSListener service

    Step 15

    &#61656; Reboot DB Server

    Shutdown immediate

    Startup migrate

    Step 16

    If clustered:

    a. Login to Node A as <sid>adm

    b. Move all clustered resources back to Node A

    c. Bring all DB Cluster group resources online except SID.World and OracleAgent

    d. start OracleService<SID> service

    &#61656; Cmd Window

    cd D: or O:\oracle\<sid>\920\cpu\CPUJul2006

    select * from v$instance; (to verify you are on the right system)

    Run the following script @catcpu.sql

    Step 17

    &#61656; Cd D: or O:\Oracle\<sid>\920\rdbms\admin

    Run the following script @utlrp.sql

    Step 18

    &#61656; Shutdown immediate

    Step 19

    &#61656; Once the Patch Set is successfully completed, update init<sid>.ora:

    Oracle\<sid>\920\database\initsid.ora

    Open the File – Edit

    Change Compatible : 9.2.0.7.12

    Save the file

    Step 20

    &#61656; Startup

    Step 21

    &#61656; Run a script to update statistics so DB02 will be properly updated:

    e. @o:\oracle\<sid>\920\scripts\ana_dict.sql

    Step 22

    &#61656; Run a script Turn the Password Verify Function back on:

    f. @%oracle_home%\scripts\intel_pwdmg.sql

    Step 23

    Non-Clustered System:

    &#61656; Shutdown immediate

    For clustered system:

    &#61656; shutdown immediate

    o exit

    o Stop OracleService<SID> service

    o Select the <SID>DB group – select <SID>.WORLD - right click – take online

    &#61656; If you are working on a Cluster – make sure you start Oracle on both nodes of the Cluster to ensure everything is working properly

    Step 24

    &#61656; Reboot OS

    Step 25

    &#61656; Startup

    Step 26

    Non-Clustered System:

    &#61656; Start SAP through MMC

    Clustered System:

    &#61607; CLUADMIN

    &#61607; Select the SAP R/3-<SID> group – right click – take online

    How to Download Oracles Patches from Service Market Place

    Go to service.sap.com

    Downloads

    Database Patches

    Oracle

    Oracle 32-Bit / Oracle 64-Bit

    Oracle 9.2.0.7

    NT_I386

    Regards.

    Kalenthirababu.p

    "Reward point it will always encourage me to answer more question"

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 08, 2007 at 12:45 PM

    Which patch are you trying to install?

    --

    Markus

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 11, 2007 at 06:14 AM

    hi ramesh ,

    for patching u should go with the read me that is provided with oracle path set .

    read that if u find any confusion then plz update the thread .

    Regards

    Deepesh

    Add comment
    10|10000 characters needed characters exceeded