DX Unified Infrastructure Management

 View Only
  • 1.  Configure a datasource to external oracle DB but it didn't work

    Posted 26 days ago
    Edited by Miller Echagarreta 22 days ago

    Hi Everyone.

    I need configure a datasource to extern DB but it didn't work. Maybe i have some bad on the configuration

    This is the configuration from documentation:

    oracle.jdbc.driver.OracleDriver
    jdbc:oracle:thin:@<dbserver>:CA Portal:<service name>

    this is my configuration:

                    jdbc_driver = oracle.jdbc.driver.OracleDriver
                    jdbc_url = jdbc:oracle:thin:@172.00.00.10:SVFE:SVFE1

    I have doubt with the part "CA Portal" what need i change here ? i put the name of the service but it didn't work

    Best Regards...!!!



  • 2.  RE: Configure a datasource to external oracle DB but it didn't work

    Broadcom Employee
    Posted 26 days ago

    Hi Miller,

    What documentation are you referencing?

    What exactly are you tryiing to accomplish?

    Are you trying to use the adogtw probe to connect to an external database?

    Determine the correct URL of your Oracle database. The URL should be in one of the following formats:
     
    jdbc:oracle:thin:@<dbhost>:<dbport>:<sid>
    jdbc:oracle:thin:@<dbhost>:<dbport>/<sn>
     
    dbhost = the database hostname
    dbport = the database listen port (default is 1521)
    sid = the service id for the database 
    sn = the service name alias for the database
     
    To see what service name aliases are available for connection requests, login as the SYS account and execute the query..
     
    select con_id, name from v$services;
    If youre using the jdbc_response probe, format is:
    jdbc:oracle:thin:@IP address:Port Number:Database Name
     
    You may also want to look at the adogtw probe:

    adogtw configuration

    Steve



    ------------------------------
    Steve Danseglio
    Technical Support Engineer 4 | IMS Division
    UIM Certified Expert
    KCSv6 Practices Certified
    Certified Customer Success Manager (CCSM) Level 1
    ------------------------------



  • 3.  RE: Configure a datasource to external oracle DB but it didn't work

    Posted 22 days ago

    Steve, excuse me for not being clear...!!!

    I am configure a datasource for a widget... I have doubt with the part "CA Portal" what need i change here ? i put the name of the service but it didn't work

    Best regards...!!!




  • 4.  RE: Configure a datasource to external oracle DB but it didn't work

    Broadcom Employee
    Posted 22 days ago

    I believe this is a documentation error, it should just say "port" not "CA Portal."   You should put the port that the database listens on (e.g. 1521 for Oracle usually)




  • 5.  RE: Configure a datasource to external oracle DB but it didn't work

    Posted 13 days ago

     jdbc:oracle:thin:@<IP>:1521:<servicename>

     jdbc:oracle:thin:@<IP>:1521/<servicename>




  • 6.  RE: Configure a datasource to external oracle DB but it didn't work

    Broadcom Employee
    Posted 5 days ago

    Tech doc page has been updated. Thank you all for sharing.

    https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/23-4/configuring-and-viewing-monitoring-data/the-dashboard-portlet/create-and-assign-the-data-source-for-a-widget.html#concept.dita_ce1e7096c1f416c3e41200ded7281319527d30dc_CreateanSQLDataSource

    Rgds,

    Rajesh B