解決client端的ORA-01882錯誤

環境描述： Serve端： Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0 Production TNS for Linux: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3.0 - Production Client端: SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 12月 13 10:44:26 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. 透過PL/SQL連線伺服器查詢時報：ora-01882錯誤，錯誤原因是Client端的time zonesID太舊導致的。 解決方法：升級Client端的Time Zone ID為V4[@more@]If you need to patch windows clients or servers then can download the patch for Windows for each version you have and simply copy the 3 needed files. Note that there are different patches for 32bit / 64 bit x86 and 64 bit Itanium To see on what platform you are you can use select platform_id, platform_name from v$database; -> Windows 32 bit is platform 7 (Microsoft Windows IA (32-bit)) -> Windows x86 64 bit is platform 233 (Microsoft Windows Server 2003 (64-bit AMD64 and Intel EM64T)) -> Windows Itanium is platform 206 (Microsoft Windows XP (64-bit Itanium)) or 208 (Microsoft Windows Server 2003 (64-bit Itanium)) or you can start "winver" a x86 64 bit AMD64/EMT64 will mention "x64 edition" to see if it's a Itanium system: Click Start, right-click My Computer, and then click Properties. In the System Properties window, click the General tab. Note the first line under Computer: Itanium or Itanium 2 appears on this line if it's a Itanium system. Above information is provided as-is. Please contact Microsoft if you have any questions regarding this A) Windows 32 bit ( NT4/2000/XP/Vista) -------------------------------------- 1) Download the Windows 32 bit 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: 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: 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: 2) Unzip the patch, and locate the 3 files readme.txt, timezone.dat and timezlrg.dat in the patch, for 9.2 and 10.2 they are in the "filesoracorezoneinfo" directory of the uncompressed patch. 3) For a server install we recommend to backup the %ORACLE_HOME%oracorezoneinfo directory . 3) Copy the 2 .dat files and the readme.txt file that were found in step 2 into the %ORACLE_HOME%oracorezoneinfo 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: 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 "filesoracorezoneinfo" directory of the uncompressed patch. 3) For a server install we recommend to backup the %ORACLE_HOME%oracorezoneinfo directory . 3) Copy the 2 .dat files and the readme.txt file that were found in step 2 into the %ORACLE_HOME%oracorezoneinfo 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: 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: -> 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: 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 "filesoracorezoneinfo" directory of the uncompressed patch. 3) For a server install we recommend to backup the %ORACLE_HOME%oracorezoneinfo directory . 3) Copy the 2 .dat files and the readme.txt file that were found in step 2 into the %ORACLE_HOME%oracorezoneinfo 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_MACHINESOFTWAREOracle 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%inventoryComponents21oracle.rsf9.2.0.1.0 -> 9i %oracle_home%inventoryComponents21oracle.rsf10.1.0.2.0 -> 10.1 %oracle_home%inventoryComponents21oracle.rsf10.2.0.1.0 -> 10.2 * For Instant Clients on Windows you need to download a NEW version from OTN. 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.