Hi Pradeep,
Please ask your Oracle support rep on how to setup JDBC with Dataguard
systems (it's not something new, being around since 11g), it's is after
all what you pay for! Also please and share your findings/config with
all of us. Oracle isn't really in a sharing mood, see eg:
https://support.oracle.com/knowledge/Middleware/2303116_1.html or
https://support.oracle.com/knowledge/Oracle%20Database%20Products/1429223_1.html
Also a quick search give us:
https://dba.stackexchange.com/questions/3869/what-is-the-jdbc-url-for-oracles-data-guard-fast-start-failover
and https://docs.oracle.com/cd/B28359_01/java.111/b31224/urls.htm shows
us various example of the "thin" syntax, I think you can add things like
this:
@(DESCRIPTION=
(LOAD_BALANCE=on)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=service_name)))
in the host part of the form for a loadbalanced setup
hth
- M
On 11/30/20 11:38 AM, pradeep2751 wrote:
hi,
We are migrating our Oracle database from version 12C to 19C . Currently 12C
is configured with single server database so Oracle plugin in geoserver is
configured with it.. After migration we will have database on high
availability mode with Primary and Secondary server and Service Name X. I
want to know how I can configure GeoServer in this case. Is anyone come
across similar configuration before?
Oracle 19C Primary Server
Oracle 19C Secondary Server
Service Name : X
Regards,
Pradeep
--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
