patch 10.2.0.3

[yotot]

How to apply the 10g Release 2 (10.2.0.3) Patch set 2 with a Oracle Home directory like ORACLE_HOME=/u01/app/oracle/product/10.2.0.1.0
and after the patch i want to use a new home directoty to
ORACLE_HOME=/u01/app/oracle/product/10.2.0.3.0

create a symbolic link ? move 10.2.0.1.0 to 10.2.0.3.0 ?

Is someone have an idea?

[davey23uk]

create a new oracle_home and patch it to the level you want

[hrishy]

Hi

You need to create the directory
/u01/app/oracle/product/10.2.0.3.0

tar and copy the software from /u01/app/oracle/product/10.2.0.1.0 to
/u01/app/oracle/product/10.2.0.3.0

Apply the ne wpatch to 10.2.0.1.0 so now the software is at 10.2.0.3.0.

Stop the database

point your oracle home to /u01/app/oracle/product/10.2.0.3.0

restart the database

Did i forget to say read the patchme and first try this methodology on a development environment first :-)

regards
Hrishy

[davey23uk]

Hi

You need to create the directory
/u01/app/oracle/product/10.2.0.3.0

tar and copy the software from /u01/app/oracle/product/10.2.0.1.0 to
/u01/app/oracle/product/10.2.0.3.0

Apply the ne wpatch to 10.2.0.1.0 so now the software is at 10.2.0.3.0.

Stop the database

point your oracle home to /u01/app/oracle/product/10.2.0.3.0

restart the database

Did i forget to say read the patchme and first try this methodology on a development environment first :-)

regards
Hrishy

that isnt going to work as it will mess up the inventory and wontr know about the 10.2.0.3.0 directory

[abhaysk]

that isnt going to work as it will mess up the inventory and wontr know about the 10.2.0.3.0 directory

not only inventory.. its going to mess at all other places where ORACLE_HOME (hard coded paths) is reffered.


rgds
abhay.

[hrishy]

Hi Abhay

You are right i messed (look what one month of bench could do to a DBA hehe)

Try this instead

Install new Oracle Home at 
/u01/app/oracle/product/10.2.0.3.0
  
Apply the patch to the new Home 
  
Shut down the database 
  
Change Oracle Home to the new location 
  
Start the database

My advise which abhay has stressed still remains :-)

regards
Hrishy

[abhaysk]

Did i forget to say read the patchme and first try this methodology on a development environment first :-)

stressing hard??

[abhaysk]

Well i was thinking if a link would work?.. if it does then he dont need to do all the circus..

Something like Link ../10.2.0.1 to ../10.2.0.3

[hrishy]

Hi

Hmm if he can afford the downtime probably yes the link way makes the matters simple.

regards
Hrishy

[abhaysk]

Hi

Hmm if he can afford the downtime probably yes the link way makes the matters simple.

regards
Hrishy

I dont understand why does he need downtime for this?