RE: upgrade 10 to 11
From: <Joel.Patterson_at_crowley.com>
Date: Wed, 24 Aug 2011 13:50:16 -0400
Message-ID: <C95D75DD2E01DD4D81124D104D317ACA16B830F8CE_at_JAXMSG01.crowley.com>
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.
Date: Wed, 24 Aug 2011 13:50:16 -0400
Message-ID: <C95D75DD2E01DD4D81124D104D317ACA16B830F8CE_at_JAXMSG01.crowley.com>
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
- 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.
- 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))
- 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 24 2011 - 12:50:16 CDT