哪里可以做宝盈网站,云购网站开发,网站设计公司 南京,河南如何做网站和许多网友一样#xff0c;今天遇到了ora-01882问题#xff0c;查了matelink解决了#xff01; 环境#xff1a;Oracle server端版本#xff1a;SQLgt; select * from v$version和许多网友一样#xff0c;今天遇到了ora-01882问题#xff0c;查了matelink解决了#xf…和许多网友一样今天遇到了ora-01882问题查了matelink解决了 环境Oracle server端版本SQLgt; select * from v$version和许多网友一样今天遇到了ora-01882问题查了matelink解决了环境Oracle server端版本SQL select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64biPL/SQL Release 10.2.0.5.0 - ProductionCORE 10.2.0.5.0 ProductionTNS for Linux: Version 10.2.0.5.0 - ProductionNLSRTL Version 10.2.0.5.0 - ProductionOracle client端版本OS:windows XP 32bitDB client:Oracle 10.2.0.1现象--客户端查询报错SQL select * from dba_scheduler_jobs;ERROR:ORA-01882: 未找到时区区域 %s未选定行SQL select * from v$timezone_file;FILENAME VERSION------------ ----------timezlrg.dat 4--登录server端查询正常SQL Select job_name,LAST_START_DATE From Dba_Scheduler_Jobs Where job_nameGATHER_STATS_JOB;JOB_NAME LAST_START_DATE-------------------- ----------------------------------------GATHER_STATS_JOB 15-1月 -13 10.00.01.937819 下午 08:00分析通过查找资料参考这个网友的分析的文章--根据我的具体问题重点参考文章中蓝色部分如下Please make sure you have the error using the sqlplus found in the oracle_home on the server (!!! this is important !!!). IF and ONLY IF that is the case run the fix script found below directly on the server.If you do NOT have a ORA-01882 when using the sqlplus found in the oracle_home on the server but you DO have it when connecting from a remote client then it means the remote client has not been updated to V3 or higher. In that case running the script will NOT solve the issue, you then need to update the clients DST version.For windows clients see Note 417893.1 How To Apply The V4 DST Patches To Windows Clients or Servers--问题原因应该是oracle客户端版本太旧存在bug所致。--通过matelink找到Note 417893.1使用红色部分的解决方案How To Apply The V4 DST Patches To Windows Clients or Servers [ID 417893.1]If you need to patch windows clients or servers then can download the patch forWindows 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 ItaniumTo see on what platform you are you can useselect 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)) or208 (Microsoft Windows Server 2003 (64-bit Itanium))or you can start winvera x86 64 bit AMD64/EMT64 will mention x64 editionto see if its 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 its a Itanium system.Above information is provided as-is. Please contact Microsoft if you haveany questions regarding thisA) Windows 32 bit ( NT4/2000/XP/Vista)--------------------------------------1) Download the Windows 32 bit 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 patchcontaining the DST V4 files:https://updates.oracle.com/download/5731535.html2) Unzip the patch, and locate the 3 files readme.txt, timezone.dat and timezlrg.datin the patch, for 9.2 and 10.2 they are in the files\oracore\zoneinfodirectory 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 2into 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 patchcontaining the DST V4 files: https://updates.oracle.com/download/5731537.html2) Unzip the patch, and locate the 3 files readme.txt, timezone.dat and timezlrg.datin the patch, for 10.2 they are in the files\oracore\zoneinfo directory ofthe uncompressed patch.3) For a server install we recommend to backup the %ORACLE_HOME%\oracore\zoneinfo directory . 本条技术文章来源于互联网如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源php中文网
