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

2014-11-24 18:17:05 · 作者: · 浏览: 2
1\oracle.rsf\10.1.0.2.0 -> 10.1
%oracle_home%\inventory\Components21\oracle.rsf\10.2.0.1.0 -> 10.2



* For Instant Clients on Windows you need to download a NEW version from OTN.
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
At the moment only the 10.2.0.3 Instant client has the V3 fixes on board.
You CANNOT patch a Instant Client with above method.
Setting ORA_TZFILE will not help - ORA_TZFILE is ignored by the Instant Client.


On Unix it is possible to generate yourself a new instant client from a patched env,
but not on windows.



解决方法:
Windows 32 bit ( NT4/2000/XP/Vista) 平台
1.下载相应版本的DST V4补丁文件,如下:
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/5731535.html


2.解压缩补丁包 p5731535_10203_WINNT.zip
在files\oracore\zoneinfo目录下找到这三个文件:readme.txt, timezone.dat and timezlrg.dat


3.copy上面三个文件到你的客户端oracle的%ORACLE_HOME%\oracore\zoneinfo目录,把原来文件替换掉。


4.重新启动你oracle客户端连程序或database,是直接重启了我的电脑。
因为我是pl/sql developer连接的,重启连接程序后再连报错,所以直接重启了下我的电脑,再次连接后查询正常