Data Integration

 View Only
Expand all | Collapse all

Display list of Oracle services

  • 1.  Display list of Oracle services

    Posted Fri October 20, 2023 04:46 PM
      |   view attached

    hello,

    I'm using Datastage 11.7 to get data from an Oracle database 19c, by Oracle connector stage. on the server property there is a button that displys list of oracle  services but it shows an error. Ihave configured the oracle_hole and tns_admin variables but still get the error.

    cheers.



    ------------------------------
    OUGADDOUM Abdelaziz
    enim
    ------------------------------



  • 2.  RE: Display list of Oracle services

    Posted Mon October 23, 2023 01:46 AM

    1. Check whether you have defined the ORACLE_HOME path in $DSHOME/dsenv which set the path of oracle tns for dsadm account



    ------------------------------
    Bharathi Murugesan
    ------------------------------