Hello Crista,

I do think that you can have more chances of get an answer for this in the
Oracle Community [1]

Anyway this is how our tns entries [2] looks like for our Oracle Databases:

(PROTOCOL=TCP) (HOST=my.host.name.1) (PORT=XXXXX) )
(PROTOCOL=TCP) (HOST=my.host.name.1) (PORT=XXXXX) )








Hope it helps,



El lun., 27 ene. 2020 a las 18:15, Edwards, Crista E
(<crista.edwa...@pnc.com.invalid>) escribió:

> What is the proper syntax for the URL portion of my JDBC connection when
> using 2 databases? We are on Tomcat 9.0, connecting to an Oracle database.
> We have 2 database instances, one active & one inactive, but the JDBC
> connection must contain both & connect to the active instance. Below is an
> example of the URL we were using when on Websphere servers.
> jdbc:oracle:thin:@
> (DESCRIPTION=(ADDRESS_LIST=(source_route=off)(load_balance=off)(failover=on)(address=(protocol=tcp)(host=
> ldb123.prod.exint.net)(port=1500))(address=(protocol=tcp)(host=
> ldb234.prod.exint.net)(port=1500)))(connect_data=(service_name=
> abc0405p_rwsvc.prod.exint.net)))
> Thank you,
> Crista Edwards
> The contents of this email are the property of PNC. If it was not
> addressed to you, you have no legal right to read it. If you think you
> received it in error, please notify the sender. Do not forward or copy
> without permission of the sender. This message may be considered a
> commercial electronic message under Canadian law or this message may
> contain an advertisement of a product or service and thus may constitute a
> commercial electronic mail message under US law. You may unsubscribe at any
> time from receiving commercial electronic messages from PNC at
> http://pages.e.pnc.com/globalunsub/
> PNC, 249 Fifth Avenue, Pittsburgh, PA 15222; pnc.com
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org


"Ever tried. Ever failed. No matter. Try Again. Fail again. Fail better."

- Samuel Beckett

Reply via email to