Devart Forums

There are two nodes in rac, and a third node is a different database that is connected by dblink.

The connection is done not using the RAC, but by instance in using the format:
server: port: sid.
And the connection is set to direct=false.


on node 1 works ok.
on node 2 I get the error when accessing any dblink.



ORA-018121: date format not recognized

ORA-02063: preceding line from ....

When I run with sqlplus works in both nodes.

Any suggestions ?

Hello,

If you have set the Direct property to False, then the OCI mode is used, in which a record from the tnsnames.ora settings file is used in the connection string, but not server:port:sid. I.e. the connection string in the OCI mode looks like the following:

user/passwd@TNSNAME

in the Direct mode

user/passwd@server:port:sid[ServiceName]

Please specify the mode you are using (Direct or OCI), and describe the steps leading to this error in more details.

Hello,

I wrote wrong, the error occurr when the direct is set to true.
When I use the oci driver work find in both nodes.
The version of odac is 8.1.4.
what details do you need ?

hello,

We have checked the ODAC behaviour when connecting in direct mode to different nodes of the RAC server and the work with the external dblink via both nodes, and didn't manage to reproduce the error on any of nodes. Please provide the query, the script for creating and filling the tables taking part in the query (or the dump of these tables), and the NLS settings of all the servers.