10.2.0.2 Client fails to connect to Database, ORA-604 error (Doc ID 374790.1)

Last updated on APRIL 24, 2017

Applies to:

Operating System Dependent Interface - Version 10.2.0.2 and later
IBM z/OS on System z

"Checked for relevance on 15-March-2010"


"Checked for relevance on 12-November-2014"



Symptoms

When attempting to use a 10.2.0.2,10.2.0.3 or 10.2.0.5 client to connect to an Oracle database server, the following error is encountered

ORA-604 Error Occurred at Recursive SQL level 1

Setting SQL_TRACE=TRUE for the database server, recreating the problem, and examining the trace file shows the following error:


PARSING IN CURSOR #2 len=32 dep=1 uid=32 oct=42 lid=32 tim=3360397972330583 hv=3
ALTER SESSION SET TIME_ZONE='%s'
END OF STMT
PARSE #2:c=650,e=669,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,tim=3360397972330579
BINDS #2:
EXEC #2:c=52,e=52,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=3360397972330687
ERROR #2:err=1882 tim=157903036


ORA-1882 means  "timezone region %s not found"











Changes

Upgraded from an earlier release of Oracle.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms