RE: Oracle and DST changes
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <Brandon.Allen@xxxxxxxxxxx>, <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Jan 2007 08:09:48 -0500
10.2.0.2 has a patch, listed in note 359145.1, page 3. 10.2.0.1 does not so
you go to note 399832.1 which actually installs the files exactly like you did.
However, that is only because there is no patch - because oracle always wants
you to 'apply' the patch when possible as it will now
self-document..(OPatch/opatch lsinventory). If you cannot update the central
inventory (10.2.0.1 for example because there is no patch), then you have to
(theoretically) keep track youself. (meaning you document it (who does this
:-)... well, you could be running 50 or 100 databases).
This is my £0.02.
Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904 727-2546
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Allen, Brandon
Sent: Tuesday, January 23, 2007 5:51 PM
To: Mercadante, Thomas F (LABOR); oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle and DST changes
I hope I'm not beating this subject to death, but it seems a lot of people are
interested in it so here is another thing I found interesting. The 10.2 patch
(5601428) for installing the new utltzuv2.sql and timezdif.csv files (which are
just for checking to see if you have affected data, not for actually fixing it)
says the following in the README.TXT file:
# Patch Special Instructions:
# ---------------------------
# Make sure all instances running under the ORACLE_HOME being patched
# are cleanly shutdown before installing this patch. Also ensure that
# the tool used to terminate the instance(s) has exited cleanly.
Now, why would you have to shutdown your instance just to install this SQL
script and CSV file? Of course I didn't want to shutdown my instance, so I
just extracted the .sql and .csv files and put them in the correct directories
($ORACLE_HOME/rdbms/admin & $ORACLE_HOME/oracore/zoneinfo, repectively) and
then I ran the script and it worked just fine - returning no affected data, as
expected.
I don't have a lot of experience with patching, so maybe I'm missing something
here. Can someone please tell me if there is some reason why I should install
this patch instead of just manually extracting the files, and if so, why this
simple patch would require the instance to be shutdown, or is that just
standard procedure that you have to shutdown for all patches, even if it's not
really necessary?
Thanks,
Brandon
________________________________
From: Mercadante, Thomas F (LABOR)
[mailto:Thomas.Mercadante@xxxxxxxxxxxxxxxxx
<mailto:Thomas.Mercadante@xxxxxxxxxxxxxxxxx> ]
I saw that and reran the utltzuv2.sql file against my 10g database
(10.2.0.2) and it reports nothing to be concerned about.
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
Other related posts:
