解决ORA-01882: 未找到时区区域 %s(二)

2014-11-24 18:17:05 · 作者: · 浏览: 1
ectory of the uncompressed patch.


3) For a server install we recommend to backup the %ORACLE_HOME%\oracore\zoneinfo directory .


3) Copy the 2 .dat files and the readme.txt file that were found in step 2
into the %ORACLE_HOME%\oracore\zoneinfo directory on your clients or server.
Please make sure you copy the correct version.
The files from the 9.2 patch for a 9.2.0.X client or server.
The files from the 10.1 patch for a 10.1.0.X client or server.
The files from the 10.2 patch for a 10.2.0.x client or server.


4) Restart the client applications (in case of client install)
or database (in case of a server install).


B) Windows 64 bit x86 (AMD64 and EMT64)
---------------------------------------


1) Download the Windows 64 bit x86 (AMD64 and EMT64) (XP/2003) server patch for your version.


For a 10.2.0.X client or server ( 10.2.0.1 to 10.2.0.3) download the 10.2.0.3 patch
containing the DST V4 files: https://updates.oracle.com/download/5731537.html


2) Unzip the patch, and locate the 3 files readme.txt, timezone.dat and timezlrg.dat
in the patch, for 10.2 they are in the "files\oracore\zoneinfo" directory of
the uncompressed patch.


3) For a server install we recommend to backup the %ORACLE_HOME%\oracore\zoneinfo directory .


3) Copy the 2 .dat files and the readme.txt file that were found in step 2
into the %ORACLE_HOME%\oracore\zoneinfo directory on your clients or server.
Please make sure you copy the correct version.
The files from the 10.2 patch for a 10.2.0.x client or server.


4) restart the client applications (in case of client install)
or database (in case of a server install).


C) Windows 64 bit Itanium
-------------------------


1) Download the Windows 64 bit Itanium server patch for your version.


For a 9.2.0.X client or server (9.2.0.1 to 9.2.0.8) download the 9.2.0.8 patch
containing the DST V4 files: https://updates.oracle.com/download/5845932.html
For a 10.1.0.X client or server (10.1.0.1 to 10.1.0.5) download the 10.1.0.5 patch
containing the DST V4 files: https://updates.oracle.com/download/5731205.html
-> this is not out yet.


For a 10.2.0.X client or server ( 10.2.0.1 to 10.2.0.3) download the 10.2.0.3 patch
containing the DST V4 files: https://updates.oracle.com/download/5731536.html


2) Unzip the patch, and locate the 3 files readme.txt, timezone.dat and timezlrg.dat
in the patch, for 9.2, 10.1 and 10.2 they are in the "files\oracore\zoneinfo"
directory of the uncompressed patch.


3) For a server install we recommend to backup the %ORACLE_HOME%\oracore\zoneinfo directory .


3) Copy the 2 .dat files and the readme.txt file that were found in step 2
into the %ORACLE_HOME%\oracore\zoneinfo directory on your clients or server.
Please make sure you copy the correct version.
The files from the 9.2 patch for a 9.2.0.X client or server.
The files from the 10.1 patch for a 10.1.0.X client or server.
The files from the 10.2 patch for a 10.2.0.x client or server.


4) restart the client applications (in case of client install)
or database (in case of a server install).


Remarks:
--------


* there is no easy way to identify a client's version.


the Oracle_Home can be read from the registry under


HKEY_LOCAL_MACHINE\SOFTWARE\Oracle


if you have there HOMEx (HOME0, HOME1,HOME2 ) you know this is 8,8i or 9i
the actual directory is in the ORACLE_HOME key.

if you have KEY_ then this is 10.1 or 10.2,
again the the actual directory is in the ORACLE_HOME key.


once you have the directory you can check for
%oracle_home%\inventory\Components21\oracle.rsf\9.2.0.1.0 -> 9i
%oracle_home%\inventory\Components2