Service Virtualization

Expand all | Collapse all

Connect IAM to Oracle Service

  • 1.  Connect IAM to Oracle Service

    Posted 04-17-2019 08:58 AM

    Hi all,

     

    when I run {INSTALL_DIR}/IdentityAccessManager/bin/DatasourceUpdater and try to configure an Oracle database, it ask the database name but I want to configure the database access throught an Oracle service.

     

    Example:

    I want:

     

    jdbc:oracle:thin:@sandbox-database-vs.dev.echonet:1521/IAM_SERVICE_CLIENT

     

    instead of:

     

    jdbc:oracle:thin:@sandbox-database-vs.dev.echonet:1521:DATABASE_NAME

     

    is there a way to achiveve this ?

     

    thanks.



  • 2.  Re: Connect IAM to Oracle Service

    Posted 04-17-2019 09:14 AM

    What happens when you give the service name?  Are you facing any errors? 

     

     



  • 3.  Re: Connect IAM to Oracle Service

    Posted 04-17-2019 09:35 AM
    IAM only supports only a SID, but the connection url in the configuration file can be updated to use service name.

     

    1. Navigate to /IdentityAccessManager/standalone/configuration
    2. Open standalone.xml
    3. Search for pool-name="KeycloakDS"
    4. Update the connection url as needed.

     

    Change the connection-url to your service:

     

    Service format: jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE

     

    Verify tables created with a JDBC connection tool.

     

    Let us know if this works.