10.2.0.2 Client fails to connect to Database, ORA-604 error
(Doc ID 374790.1)
Last updated on FEBRUARY 06, 2020
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"
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
ERROR #2:err=1882 tim=157903036
ORA-1882 means "timezone region %s not found"
Upgraded from an earlier release of Oracle.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document