I have already successfully configured a database with
keycloak using database
SID and following configuration. However, I have to configure another database which doesn’t has
SID but with a
service name in
docker-compose file. I couldn’t find a way to configure database to
keycloak using it’s
Configuration using SID in docker-compose file
- name: DB_VENDOR value: ORACLE - name: DB_ADDR value: xxx.xx.xx.xxx - name: DB_PORT value: "1521" - name: DB_DATABASE value: sid_name - name: DB_USER value: db_user_name - name: DB_PASSWORD value: ******
When I tried to use
service name instead of
SID as value for
DB_DATABASE it gave following error.
Caused by: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Appreciate your kind help to solve this issue.
Thank you in advance..