IT Process Automation

 View Only
  • 1.  Select from Database Operator: oracle connect string

    Posted Dec 18, 2014 07:57 PM

    I am using the Select from Database operator and the oracle connect string does not seem to work using the service information from our tnsnames.ora file. I have gotten it to work by giving the direct connection information to an oracle server, however we have redundant database servers and as currently configured it will not survive a database failover.


    In configuring the connection wizard Database Name and Oracle Service ID seem to do the exact same thing with Service ID eclipsing Name. If I try to use the Oracle TNS Name filed, I get a host not found. I also tried manually configuring the Connection URL but any changes there do no seem to take effect, judging by the result of the error messages. It seems like PAM does not recognize the tnsnames.ora information at all...


    Any suggestion or additional information on how this works that may be of assistance?

  • 2.  Re: Select from Database Operator: oracle connect string
    Best Answer

    Posted Jan 20, 2015 08:28 AM

    I ended up contacting CA Support about this issue. They suggested by-passing the connection wizard, removing all values from it, and just using the connection url. During my previous attempt I had not cleared the connection wizard so it was still overriding what was supplied directly in the connection url. This allowed me to change the format of the connection string to connect by service instead of sid which did work correctly.