Originally posted by: Ole Haavard Haug-Larsen

Hi.

We use WTX Command server and Oracle database in our mappings. The database connect string is defined in ResourceVariables.mrn like this:

"-CONNECT <ipadress>:<port>/<service-name> -USER <user> -PASSWORD <password>"

Is it possible to include the failover-node in the connect-string as well (in additon to the 'normal' ipadress)?? This is a part of an activity in robustifying the database-connections.

Any suggestions?

Originally posted by: PaulBrett

I do not think so.

I recommend you include the connection name from your tnsnames.ora file, and put the failover settings in that

"-DBTYPE oracle -CONNECT <tns_named_entry> -USER <user> -PASSWORD <password>"

https://docs.oracle.com/cd/E11882_01/network.112/e10835/tnsnames.htm#NETRF263

Thank you

Paul

Follow me on Twitter