10.2.0.2 Client fails to connect to Database, ORA-604 error
(Doc ID 374790.1)
Last updated on AUGUST 31, 2023
Applies to:
Operating System Dependent Interface - Version 10.2.0.2 and laterIBM z/OS on System z
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
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
| Symptoms |
| Changes |
| Cause |
| Solution |