When launching the Job Scheduler in SQL Navigator, the following error occurs:
ORA-01882: timezone region %s not found
When clicking the 'new' button in the Job Scheduler, the following error occurs:
Variant is not an array
This is not a SQL Navigator issue, Oracle documentation for ORA-01882 recommends contacting Oracle Support Services to resolve this problem.
Inside SQL Navigator article:
http://sqlnavigator.inside.quest.com/message.jspa?messageID=20572
Some important features in the article:
"If after applying the DST patches a "select * from dba_scheduler_jobs;" or other TSLTZ data gives "ORA-01882: timezone region %s not found", 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 client's DST version.
For windows clients see Note 417893.1 How To Apply The V4 DST Patches To Windows Clients or Servers."
Test the issue by running the query below and see what scenario best fits the circumstance of the issue.
select * from dba_scheduler_jobs;
