10.2.0.2 Client fails to connect to Database, ORA-604 error
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"
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.
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