oracle patch installation

[Former Member]

Any one send oracle patches installation step

[Former Member · Accepted solution]

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

[Former Member]

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

[markus_doehr2]

Which patch are you trying to install?

--

Markus

[Former Member]

e.g. operating system

[Former Member]

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: <map drive>:\db\opatch\perl\5.00503\bin\Mswin32-x86\perl <map drive>:\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 😧 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 😧 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"

[markus_doehr2]

So from his question you know, that he's on Windows, he wants to patch Oracle 9 and that he uses a Windows cluster?

--

Markus