Friday, April 11, 2008

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;

The following queriesSQL> 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 dbconsoleisqlplusctl stopsrvctl stop service -d DWHDB -s DWHDB_TAF -i DWHDB1srvctl stop instance -d DWHDB -i DWHDB1 -o immediatesrvctl stop asm -n bl3306srvctl 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:

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

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.

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.

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.