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:
TNS_ENTRY_1_PROD=(
DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP) (HOST=my.host.name.1) (PORT=X) )
(ADDRESS=
(PROTOCOL=TCP) (HOST=my.host.name.1) (PORT=X) )
(LOAD_BALANCE=off)
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=my.service.name)
(FAILOVER_MODE=
(TYPE=SELECT)
(METHOD=BASIC)
)
)
)
Hope it helps,
Luis
[1]
https://community.oracle.com/community/groundbreakers/database/general_questions
[2]
https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/glossary.html#GUID-8836AF91-6176-4133-BD13-348AF90181CE
El lun., 27 ene. 2020 a las 18:15, Edwards, Crista E
() 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
