I am trying to connect to a remote Oracle DB using ROracle from the client side.
After establishing connection, I execute this query:
dat = dbGetQuery(con, "SELECT * FROM TABLE_01")
This leads to the error:
Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch, :
Error in try({ : ORA-01805: possible error in date/time operation
I checked the DB version in server side:
SELECT * FROM V$VERSION
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
Then I ran genezi in client side:
genezi -v
System name: Linux
Release: 4.4.0-36-generic
Version: #55-Ubuntu SMP Thu Aug 11 18:01:55 UTC 2016
Machine: x86_64
Operating in Instant Client mode.
Small timezone file = timezone_14.dat
Large timezone file = timezlrg_14.dat
The Oracle version of both client and server is 11.2. But the timezone file seems to be different. How to fix this issue?
Best Answer
Most likely you have different timezones installed between the database server and the client.
To check the database version:
To check the client version:
(Which you've done already - your client is on 14. I suspect the database is using a more recent version).