RE: upgrade 10 to 11
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <howard.latham@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Aug 2011 13:50:16 -0400
If you have not used the data types timestamp with % timezone, then if you have
DSTv16 in you 11g software aleady... $ORACLE_HOME/oracore/zoneinfo, then I was
successful just upgrading the database with dbua, where during the process it
suggests upgrading the database timezone using the DBMS_DST after dbua is
finished. Seemed simpler to do it after.
YMMV
1. If the Pre-Upgrade Information Tool instructed you to upgrade the time
zone files after
completing the database upgrade, then use the DBMS_DST PL/SQL package to
upgrade the time zone file.
a. Note
977512.1<https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=977512.1>
Updating the RDBMS DST version in 11gR2 (11.2.0.1 and up) using DBMS_DST
https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocDsrc=KB&from=BOOKMARK&viewingMode=1143&bmDocTitle=Actions%20For%20DST%20Updates%20When%20Upgrading%20To%2011.2.0.1%20Base%20Release&bmDocID=815679.1&bmDocType=BULLETIN))
b. Note
977512.1<https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=977512.1>
Updating the RDBMS DST version in 11gR2 (11.2.0.1 and up) using DBMS_DST
(Different?)
https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocDsrc=KB&from=BOOKMARK&viewingMode=1143&bmDocTitle=Actions%20For%20DST%20Updates%20When%20Upgrading%20To%2011.2.0.1%20Base%20Release&bmDocID=815679.1&bmDocType=BULLETIN))
Joel Patterson
Database Administrator
904 727-2546
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Howard Latham
Sent: Wednesday, August 24, 2011 7:33 AM
To: ORACLE-L
Subject: upgrade 10 to 11
10 + 11
RH Linux
The upgrade from 10 to 11 doc seems to imply that you have to change some
timezone files.
Can I Ignore this is If have'nt used the TIMESTAMP Datatype-
And ..
Why do I get ORa-00723 Initialization parameter COMPATIBLE must be explicitly
set
When I startup upgrade WHEN I HAVE SET COMPATIBLE ? any Ideas?
--
Howard A. Latham
Sent from my Nokia N97
Other related posts:
