Symantec IGA

  • Private Community

  • 1.  IG client tool connect to Oracle database

    Posted May 03, 2018 01:11 AM

    Hi There,

     

    I have deployed Identity Suite 14.1 virtual appliance with identity governance. I used an external Oracle database for the deployment.

     

    I then tried to use the client tools to connect to the Identity Governance database. From the main menu, File/General Settings/SQL Connectivity tab, I selected "Request SQL Credentials from a Server" option. For the server URL, I selected "http", virtual appliance IP, 8082. When I clicked on "Apply", on the "Enter Server Credentials" pop up dialog, I entered the values for the four fields: SQL Server/User Name="SYSTEM", SQL Server/Password="MY_PASS", Web Server/User Name="AD1\EAdmin" and Web Server/Password="eurekify". An error message came back telling me it failed to connect to the server.

     

    I checked that the IG server and the Oracle database are running.

     

    Does anyone know I entered the right values ?

    For the Oracle database, the eurekify database is named "EUREKIFY".

     

    Regards,

    Jiangping Li



  • 2.  Re: IG client tool connect to Oracle database
    Best Answer

    Broadcom Employee
    Posted May 03, 2018 08:51 AM

    I find it odd that you are trying to connect as "SYSTEM".  Did you try connecting as the schema owner (EUREKIFY_SDB or EUREKIFY)?  I assume that you have the Oracle client or MDAC installed.



  • 3.  Re: IG client tool connect to Oracle database

    Posted May 04, 2018 12:53 AM

    Thanks Ricky for your reply.

     

    Yes, I had installed Oracle client (followed the steps on this page: Install Additional Components - CA Identity Governance - 14.2 - CA Technologies Documentation )

     

    I had also tried the schema owner EUREKIFY, it did not work either. In the client tools log, it says "Either SQL Server or Database name is unspecified"

     

    From the client tools, if I select "Use Static SQL Credentials" on the "SQL Connectivity" tab, it works.



  • 4.  Re: IG client tool connect to Oracle database

    Broadcom Employee
    Posted May 07, 2018 08:09 AM

    Hi,

    If you are on 14.1, then please refer to the 14.1 link (Install Additional Components 14.1 IG)  link. There are a couple of changes to the page from 14.1 to 14.2. The 14.2 commands do not work on 14.1 client tools.

    Did you run the below commands?

    regasm.exe "C:\Program Files\CA\RCM\Client Tools\Software\Microsoft.Web.Services3.dll"
    regasm.exe "C:\Program Files\CA\RCM\Client Tools\Software\SageSOAP.dll"

     

    Thanks,

    Yogitha



  • 5.  Re: IG client tool connect to Oracle database

    Posted May 07, 2018 07:30 PM

    Of course I did run those two commands after client tools installation, otherwise it wouldn't even start.

    Both client and server are 14.1.

    Server is deployed as virtual appliance.