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 ?
dblink with oracle 11g
Re: dblink with oracle 11g
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.
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.
Re: dblink with oracle 11g
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 ?
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 ?
Re: dblink with oracle 11g
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.
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.