Decision Management (ODM,ADS)

 View Only
Expand all | Collapse all

What is the default db.properties file for a fresh install with oracle using service name instead of hostname?

  • 1.  What is the default db.properties file for a fresh install with oracle using service name instead of hostname?

    Posted Mon August 01, 2022 06:11 PM
    My DB.properties is configured using. database.type= database.jdbc Driver Path= database.name= database.hostname= database.port= database.user= database.password= How would it be if I had to use the servicename in oracle without using sid (database.name)?



    #OperationalDecisionManager(ODM)
    #Support
    #SupportMigration


  • 2.  RE: What is the default db.properties file for a fresh install with oracle using service name instead of hostname?

    Posted Fri August 05, 2022 05:18 PM

    You have to use the custom external database configuration for an Oracle instance

    https://www.ibm.com/docs/en/odm/8.11.0?topic=database-configuring-custom-external

    You will specify the properties directly in a resource file following this description here https://www.ibm.com/docs/en/was-liberty/base?topic=SSEQTP_liberty/com.ibm.websphere.liberty.autogen.nd.doc/ae/rwlp_config_dataSource.html search for properties.oracle.

    For SID connection you will use the property serviceName



    #OperationalDecisionManager(ODM)
    #Support
    #SupportMigration