Viewing Jobs: ORA - 01882 w/ v10.0.0.1694 on 1 machine, no error on another machine w/v9.0.4.1644

[socal310]

Help!

I'm getting an 'ORA-01882: timezone region %s not found' error on when attempting to view Jobs in PL/SQL Developer in one machine and not another. Both are connecting to the same DB (Oracle 11g 11.2.0.2.0).

I suspect that it may be related to the Oracle install on the impacted machine. Below are my install details.

Any advice?

Thanks for the help!

Details:

Machine that works correctly:

PL/SQL Developer
Version 9.0.4.1644
01.64361 - 50 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 3)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\snyderd\default.ini

Plug-Ins

Homes
OraClient10g_home1 (C:\oracle\product\10.2.0\client_1)

DLLs
C:\oracle\product\10.2.0\client_1\bin\oci.dll

TNS File
C:\oracle\product\10.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient10g_home1
DLL: C:\oracle\product\10.2.0\client_1\bin\oci.dll
OCI: Version 10.2
Oracle Database 11g Release 11.2.0.2.0

Character Sets
Character size: 1 byte(s)
CharSetID: 31
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_CHARACTERSET: WE8ISO8859P1
NLS_NCHAR_CHARACTERSET: AL16UTF16

Machine that gets ORA-01882

PL/SQL Developer
Version 10.0.1.1694
01.86850 - 1 user license
Windows 7 6.1 Build 7601 (Service Pack 1)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Users\SnyderD\AppData\Roaming\PLSQL Developer\Preferences\snyderd\default.ini

Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In (C:\Program Files\PLSQL Developer\PlugIns\RedGate.dll)
*Version Control Interface 1.2 (C:\Program Files\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Homes
OraHome92 (C:\oracle\ora92)

DLLs
C:\oracle\ora92\bin\oci.dll

TNS File
C:\oracle\ora92\Network\Admin\tnsnames.ora

Using
Home: OraHome92
DLL: C:\oracle\ora92\bin\oci.dll
OCI: version 9.2
Oracle Database 11g Release 11.2.0.2.0

Character Sets
Character size: 1 byte(s)
CharSetID: 31
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_CHARACTERSET: WE8ISO8859P1
NLS_NCHAR_CHARACTERSET: AL16UTF16

 

[Marco Kalter]

This is an Oracle Client/Server compatibility issue. See the Oracle Note 414590.1 for more information (server updating its DST [daylight savings time] database, but client using an old one).

 

[socal310]

Thanks Marco. I updated to 11g and problem solved.

Socal310