Friday, April 11, 2008

Patching Oracle RAC 10.2.0.1 on ASM with 10.2.0.4 Patch Set 3 for Linux x86

Using your oracle user, download and unzip the file p6810189_10204_Linux-x86.zip.







First of all, before applying the 10.2.0.4 patchset to the Oracle database you should verify if the DSTv4 (USA 2007) update included in the 10.2.0.4 patchset has implications on your database. Following the NoteId 553812.1 provided by Metalink the goal is to see if you have stored information that is affected and if you are already using a DST version higher then DSTv4 and what then to do.


Because I'm patching from a lower 10.2.0.X release to 10.2.0.4 I hav to execute the following query to check the current version of the Oracle time zone definitions:
SQL> SELECT version FROM v$timezone_file;

Becuse my current timezone version is lower then 4, I need to execute this other query to check if I'm storing *user* TZ (TSTZ and TSLTZ) data:
SQL> select c.owner || '.' || c.table_name || '(' || c.column_name || ') -' || c.data_type || ' ' col
from dba_tab_cols c, dba_objects o
where c.data_type like '%TIME ZONE'
and c.owner=o.owner
and c.table_name = o.object_name
and o.object_type = 'TABLE'
order by col
My output shows there is nothing outside the Data Dictionary (= other then SYS objects).


The following queries
SQL> SELECT object_name FROM dba_objects WHERE object_id IN (SELECT obj# FROM scheduler$_window);
SQL> SELECT object_name FROM dba_objects WHERE object_id IN (SELECT obj# FROM scheduler$_job);
show I have only 6 jobs defined and I have also no user TZ (TSTZ and TSLTZ) data, so there is no action to take for the Oracle time zone definitions, and I can simply upgrade from 10.2.0.1 to 10.2.0.4.


Now I have to stop one node because I need to patch first the clusterware software and it can be done using rolling updates.
Run the following commands from the first node of your RAC installation:
emctl stop dbconsole
isqlplusctl stop
srvctl stop service -d DWHDB -s DWHDB_TAF -i DWHDB1
srvctl stop instance -d DWHDB -i DWHDB1 -o immediate
srvctl stop asm -n bl3306
srvctl stop nodeapps -n bl3306


Go into the directory Disk1 and run ./runInstaller &


A Welcome screen appears.


Specify the home details for the clusterware home.


Click next on the cluster nodes screen.


It checks for product-specific prerequisites.


Click Install


And the Clusterware patching is starting.



Before click the EXIT button and complete the installation,login as root on the first node and execute the following command as suggested:




Run
/u01/app/oracle/product/10.2.0/crs_1/crsctl stop crs
/u01/app/oracle/product/10.2.0/crs_1/install/root102.sh


They stop and start the crs services on the first node.
Execute the same command on every nodes, I ru them only on my second node:
/u01/app/oracle/product/10.2.0/crs_1/crsctl stop crs
/u01/app/oracle/product/10.2.0/crs_1/install/root102.sh


Then execute as oracle user from one node:
crsctl query crs activeversion


Execute as oracle user from second node:
crsctl query crs activeversion


The clusterware software has been updated.

Click EXIT and then YES from the OUI interface.


Now execute the following command to completely stop the database (this patchset doesn't support rolling updates) from your first node:
emctl stop dbconsole
isqlplusctl stop
srvctl stop service -d database DWHDB -s DWHDB_TAF -i DWHDB1
srvctl stop database -d DWHDB -o immediate
srvctl stop asm -n bl3306
srvctl stop nodeapps -n bl3306


Execute the following command to completely stop the asm instance from your second node:
emctl stop dbconsole
isqlplusctl stop
srvctl stop asm -n bl3305
srvctl stop nodeapps -n bl3305


As oracle user run again the runInstaller


Click NEXT on Welcome screen.


Choose the Oracle home.


Click NEXT on cluster installation mode screen.


Click NEXT on prerequisite checks screen.


Enable and register your Oracle Configuration Manager.


Accept the license agreement


and test your registration


Click INSTALL on summary screen.


The installation is proceeding.


When asked execute as root user the following command on your first node
/u01/app/oracle/product/10.2.0/db_1/root.sh


and then again from your second node.


Clic EXIT on End of Installation screen



and the YES


Only from your first node, login as oracle user and execute:
srvctl start asm -n bl3306
srvctl start listener -n bl3306


Then run dbua


Click NEXT on Welcome screen.


Select Upgrade a Database and click NEXT.


Select your database and click NEXT, providing a user with sysdba privileges.


The upgrade of the database starts.


Choose the degree of parallelism to recompile any invalid objects, turn off archiving and click NEXT.


Specify your Flash Recovery Area and click NEXT.


Click FINISH on Summary screen.


Your database is now 10.2.0.4 patched.

20 comments:

Anonymous said...

Did you try the similar upgrade with Solaris? Cluster-ware and DB upgrade both with the single patch p6810189_10204_Linux-x86.zip?

Anonymous said...

I have 3 Homes

1) /opt/oracle/product/10.2.0/crs/
2) /opt/oracle/product/10.2.0/asm/
3) /opt/oracle/product/10.2.0/db_1/

How to patchset ASM ?

Rahul said...

Excellent article and thanks for sharing

Rajeshkumar Govindarajan said...

super article.. good work..clear article..even newbie can easily understand. thanks a lot for document.

Rajeshkumar,
Oracle DBA,
ConscientiaDBS.
www.oracleinstance.blogspot.com

Anonymous said...

Excelent :), thanks!

Satya Thirumani said...

Good article.
Thank you very much...

-Satya
http://satya-racdba.blogspot.com/

Anonymous said...



Here is my web site payday loans
Also visit my web page ... payday loans

Anonymous said...



Alsο visit my blog pοst: payday loan,
My blog ; payday loan online

Anonymous said...

ativan mg ativan 321 - ativan addiction warning signs

Anonymous said...

A huge solar flare caused a loss of nearly 10,000 mw which accounted for
almost half of the load being carried by Hydo-Quebec.
There is an incredible potpourri of hazardous weather underway or expected in the next 36 hours.
You may want to use a carpenter's square to verify this.

Feel free to visit my weblog http://mswebmedia.de

Anonymous said...

It appears it's actually the extract from the Chrysanthemum plant that is the effective component attributing to the pest control in gardens. Keep in mind that weeds spread many plant diseases as well as making the garden look untidy, they can also worsen the condition of your garden soil. Cut off the cilantro stalks and allow the plant and seeds to dry fully in a paper bag, then collect the seeds.

My web-site; Online Payment processing

Juragan Oracle said...
This comment has been removed by the author.
Anonymous said...

I go to see everyday some web sites and sites to read posts, except
this weblog gives feature based writing.

Feel free to visit my web-site: 47 Ronin Télécharger Film complet en Français

Anonymous said...

Hello mates, its enormous post on the topic of
educationand completely explained, keep it up all the time.


Look into my web site; password cracker for winrar

Anonymous said...

Simply desire to say your article is as astonishing.

The clarity in your post is simply excellent and i could assume you're an expert on this subject.
Well with your permission allow me to grab your RSS feed
to keep up to date with forthcoming post. Thanks a
million and please keep up the enjoyable work.


Here is my web page: online survey jobs

oakleyses said...

oakley sunglasses, prada handbags, oakley sunglasses, longchamp handbags, longchamp handbags, louboutin shoes, louis vuitton handbags, coach factory outlet, tiffany and co, coach purses, louis vuitton outlet, polo ralph lauren outlet, air max, prada outlet, longchamp outlet, oakley sunglasses cheap, ray ban sunglasses, louboutin outlet, michael kors outlet, michael kors outlet, tiffany and co, burberry outlet, christian louboutin shoes, coach outlet store online, jordan shoes, polo ralph lauren outlet, louboutin, kate spade handbags, michael kors outlet, coach outlet, air max, gucci outlet, michael kors outlet, ray ban sunglasses, chanel handbags, michael kors outlet, tory burch outlet, nike free, kate spade outlet, louis vuitton outlet, burberry outlet, louis vuitton outlet stores, louis vuitton, nike shoes, michael kors outlet

oakleyses said...

abercrombie and fitch, instyler, ghd, bottega veneta, ugg boots, jimmy choo outlet, soccer shoes, ugg pas cher, herve leger, beats by dre, birkin bag, abercrombie and fitch, north face jackets, soccer jerseys, mont blanc, rolex watches, lululemon outlet, celine handbags, nike roshe run, nike trainers, giuseppe zanotti, hollister, wedding dresses, nike huarache, mcm handbags, vans shoes, chi flat iron, babyliss pro, north face outlet, nike roshe, ugg australia, ugg, marc jacobs, barbour, nfl jerseys, p90x, new balance shoes, asics running shoes, ferragamo shoes, mac cosmetics, insanity workout, uggs outlet, reebok outlet, longchamp, valentino shoes

oakleyses said...

converse, air max, gucci, canada goose, juicy couture outlet, canada goose, wedding dresses, moncler, ralph lauren, lancel, montre homme, moncler, louboutin, oakley, karen millen, vans, coach outlet store online, air max, canada goose jackets, ugg, hollister clothing store, louis vuitton, baseball bats, hollister, rolex watches, juicy couture outlet, iphone 6 cases, canada goose uk, canada goose outlet, ugg, moncler, moncler outlet, timberland boots, hollister, supra shoes, moncler, canada goose, converse shoes, toms shoes, moncler, moncler, canada goose, ugg boots, ray ban, parajumpers, canada goose

Path Infotech said...

Thanks for sharing the information

Oracle DBA Certification

Unknown said...

nice blog, Thanks for your information.Oracle RAC Training in Hyderabad