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.

26 comments:

Viji 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

Libasa Yuwari 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...

Hey! Would you mind if I share your blog with my facebook group?
There's a lot of people that I think would really enjoy your content.
Please let me know. Thank you

Here is my website :: Modesto Pool Builder

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...

air max, hollister, true religion outlet, nike blazer, louboutin, ray ban sunglasses, polo ralph lauren, michael kors, true religion jeans, sac guess, sac longchamp, hogan outlet, ralph lauren, vans pas cher, sac louis vuitton, air max pas cher, nike free pas cher, nike free, air max, mulberry, nike roshe run, sac burberry, hollister, vanessa bruno, louis vuitton, lululemon, michael kors pas cher, oakley pas cher, air jordan, ray ban pas cher, new balance pas cher, polo lacoste, converse pas cher, north face, sac louis vuitton, michael kors, sac hermes, nike tn, timberland, louis vuitton uk, longchamp, true religion jeans, nike air max, air force, north face

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

ekhtsasy yamama said...

شركة تنظيف شقق بالدمام
شركة تنظيف مجالس بالدمام
شركة مكافحة حشرات بالدمام
شركة مكافحة حشرات بالاحساء
شركة مكافحة حشرات بالجبيل
شركة مكافحة حشرات بالقطيف
شركة مكافحة حشرات برأس تنورة
شركة تنظيف منازل بالدمام
شركة تنظيف بالقطيف
شركة تنظيف شقق بالقطيف
شركة تنظيف بالاحساء
شركة تنظيف شقق بالاحساء
شركة تنظيف برأس تنورة
شركة تنظيف شقق برأس تنورة
شركة تنظيف بالجبيل
شركة تنظيف شقق بالجبيل
شركة تسليك مجارى بالدمام
شركة تسليك مجارى بالاحساء
شركة تسليك مجارى بالقطيف

Path Infotech said...

Thanks for sharing the information

Oracle DBA Certification

John Nash said...

Thanks for sharing this information. Wonderful tips, very helpful well explained.
Oracle Database SQL Workshop
Oracle Database Integration 11g Online Training
Oracle RAC DBA Online Training

مؤسسه الحرمين said...


شركة كشف تسربات المياه بالاحساء
كشف تسربات المياه بالاحساء
شركة عزل اسطح بالاحساء
شركة عزل خزانات المياه بالاحساء
شركه عزل مائى بالاحساء
شركة عزل حرارى بالاحساء
شركة ترميم منازل بالاحساء
شركة مكافحة حشرات بالاحساء
شركة رش مبيدات بالاحساء
شركة تسليك مجارى بالاحساء
شركة ترميم منازل بالاحساء

مؤسسه الحرمين said...


شركة كشف تسربات المياه بالاحساء
كشف تسربات المياه بالاحساء
شركة عزل اسطح بالاحساء
شركة عزل خزانات المياه بالاحساء
شركه عزل مائى بالاحساء
شركة عزل حرارى بالاحساء
شركة ترميم منازل بالاحساء
شركة مكافحة حشرات بالاحساء
شركة رش مبيدات بالاحساء
شركة تسليك مجارى بالاحساء
شركة ترميم منازل بالاحساء


مؤسسه الحرمين said...



شركة كشف تسربات المياه بالرياض
كشف تسربات المياه بالرياض
شركة عزل اسطح بالرياض
شركة عزل خزانات المياه بالرياض
شركه عزل مائى بالرياض
شركة عزل حرارى بالرياض
شركة ترميم منازل بالرياض
شركة مكافحة حشرات بالرياض
شركة رش مبيدات بالرياض
شركة تسليك مجارى بالرياض

شركة كشف تسربات المياه بالاحساء
كشف تسربات المياه بالاحساء
شركة عزل اسطح بالاحساء
شركة عزل خزانات المياه بالاحساء
شركه عزل مائى بالاحساء
شركة عزل حرارى بالاحساء
شركة ترميم منازل بالاحساء
شركة مكافحة حشرات بالاحساء
شركة رش مبيدات بالاحساء
شركة تسليك مجارى بالاحساء
شركة ترميم منازل بالاحساء