Update Oracle patch

[Former Member]

Dear ,

Right now my Oracle patch Release 10.2.0.1.0 now i want update to 10.2.0.2.0 .

I have dump of this patch.

How I installed this patch .

Because right now my SAP and Oracle is running and my dump is /sapdump/oracle/orapatch/HPUX_IA64/ship.patch/Disk1/install/

total 1048

-rwxr-xr-x 1 root sys 273004 Apr 27 2006 .oui

-rwxr-xr-x 1 root sys 168 Apr 27 2006 addLangs.sh

-rwxr-xr-x 1 root sys 76 Apr 27 2006 addNode.sh

-rwxr-xr-x 1 root sys 276 Apr 27 2006 attachHome.sh

-rwxr-xr-x 1 root sys 8064 Apr 27 2006 clusterparam.ini

-rwxr-xr-x 1 root sys 182 Apr 27 2006 detachHome.sh

-rwxr-xr-x 1 root sys 6732 Apr 27 2006 oraparam.ini

drwxr-xr-x 3 root sys 1024 Apr 27 2006 resource

drwxr-xr-x 2 root sys 96 Apr 27 2006 response

-rwxr-xr-x 1 root sys 753 Apr 27 2006 runConfig.sh

-rwxr-xr-x 1 root sys 62 Apr 27 2006 runInstaller.sh

-rwxr-xr-x 1 root sys 47 Apr 27 2006 runInstaller.var

-rwxr-xr-x 1 root sys 239416 Apr 27 2006 unzip

What is prerequest of installed Oracle patch ? mean saposcol ,lsnrctl ...all services.

Should I stop All services i.e SAP & Oracle

can I installed via telnet or in windows Xmanager?

How I update my patch level .I am new in Unix . plz help

raj

[Former Member · Accepted solution]

Hi

Kindly look into the below link

1. http://www.iselfschooling.com/mc4articles/mc4orapatch.htm

Run rootpre.sh

As root

/oracle/stage/102_64/database/Disk1/rootpre/ro

otpre.sh

At the end you should see

Checking if group services should be

configured....

Nothing to configure.

33. Copy .Xatuhority file from your home

directory to /oracle/SID and change

ownership to ora<sid>:dba.

As ora<sid>

Set DISPLAY variable

setenv DISPLAY <value set in your env>

Set TMP and TEMP variables, only if you

are not using /tmp.

setenv TMP /instdir_4upg/oratmp

setenv TEMP /instdir_4upg/oratmp

Set UMASK

umask 022

Start runInstaller

As ora<sid>

/cddvd_4upg/mnt1/DVD_ORACLE_10.2.0.2_Pat

ches_WIN_AIX_SOL/AIX_64/Disk1/runInstaller

Now you will see Welcome screen

popping up on you pc.

Press Next

Check/correct values (if necessary)

Make sure all space requirements are

met and press Install

run root.sh

As root

/oracle/SID/102_64/root.sh

Running Oracle10 root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oraSID

ORACLE_HOME= /oracle/SID/102_64

Press n for following queries.

Enter the full pathname of the local bin directory:

[/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin.

Overwrite it? (y/n) [n]: n

The file "oraenv" already exists in /usr/local/bin.

Overwrite it? (y/n) [n]: n

The file "coraenv" already exists in /usr/local/bin.

Overwrite it? (y/n) [n]: n

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as

needed by

Database Configuration Assistant when a

database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be

performed.

Press OK on the installer screen.

Hope this may help you

Regards

Sirigiri

[Former Member · Accepted solution]

Thanks for your nice reply.

Regards

RAJ

[Former Member]

Wrongly it got posted for more than once. Please ignore rest of the replies.

Edited by: Sushil Suryawanshi on Jul 1, 2009 5:17 PM

[Former Member]

Raj,

Just to add, check below link. it may help you

Thanks

Sushil

[Former Member]

Raj,

Just to add, check below link. it may help you

Thanks

Sushil

[Former Member]

Raj,

Just to add, check below link. it may help you

Thanks

Sushil

[Former Member]

Raj,

Just to add, check below link. it may help you

Thanks

Sushil

[Former Member]

Raj,

Just to add, check below link. it may help you

Thanks

Sushil

[Former Member]

Raj,

Just to add, check below link. it may help you

Thanks

Sushil

[Former Member]

Hi,

Please refer SAP Note-871096,871735

For upgrading the Oracle Patch lavel u have to down SAP but do not need to down Oracle and Listner.

Thanks

[markus_doehr2]

> For upgrading the Oracle Patch lavel u have to down SAP but do not need to down Oracle and Listner.

of course you have to shutdown the database. You can't patch a running program.

Markus

[markus_doehr2]

> Because right now my SAP and Oracle is running and my dump is /sapdump/oracle/orapatch/HPUX_IA64/ship.patch/Disk1/install/

If you check the "Readme.htm" in the Disk1 directory you will find a step-by-step documentation.

I also suggest you read

Note 839187 - Oracle 10.2.0: Applying patch set/patches/patch collection

Also be aware that just installing patch 10.2.0.2 is not enough, you need to add a bunch of single/interim patches after your update to 10.2.0.2:

Note 871096 - Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.2

Depending on how you use the system and which features you plan to use up to 59 patches have to be installed on top.

Markus