Need information in oracle db

[sk]

Hi Team,

we have a requirement on oracle db connection, where the application is having 10 databases , how can we mention them in the same connection 

[rushikeshvartak]

sample url

jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL=TCP)(HOST=10.127.78.7)(PORT=1652)) (ADDRESS =
(PROTOCOL=TCP)(HOST=10.127.31.160)(PORT=1652)) (ADDRESS =
(PROTOCOL=TCP)(HOST=10.127.78.14)(PORT=1652)) (FAILOVER=on) (LOAD_BALANCE=ON))(CONNECT_DATA =(SERVER
= DEDICATED)(SERVICE_NAME = RUSHI)))

[sk]

Hi @rushikeshvartak , thanks for the response

As mentioned above, we are having 10 databases with different 10 hostnames, so we are planning to create 10 db connections.

But here the request form should be same for all the 10 endpoints, the requirement here is if user changes password for one endpoint (one database) then it should change for all the other databases.

Can you help me with this.

Thanks in Advance

[rushikeshvartak]

You can't sync password between 10 endpoints. while resetting password you can select all 10 accounts from application reset password in bulk.