CDB - CDB Profile unable to connect to Oracle database even when Visualizer and Automator are able to connect using the same ODBC definition and Automator Catalog Entry.

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Performance Analyzer for Mainframes


    APPLIES TO:

    BMC Performance Analyzer for Mainframes



    PROBLEM:

     

    The CDB Profile is unable to connect to an Oracle database even when Visualizer and Automator are able to connect using the same ODBC definition and Automator Catalog Entry.

    CDB returns the following Error message:

    ERROR: SQLFreeConnect() failed. SQLState: 00000 - SQLErrror.

    Module - GetPlatformsInfo

      


    LP: BMC Capacity Optimization for Mainframes


     

     


    SOLUTION:

     

    Legacy ID:KA413774

      

    The problem turned out that the CDB definition in IIS was using the default identity for the Application Pool "ApplicationPoolIdentity" and that identity (user) didn't enough privilege to connect to Oracle.

    Do the following to change the Identity (user) in the BMCCDBServicesAppPool...

    1. Open IIS Manager.
    2. Expand the tree.
    3. Click on Application Pools.
    4. Select Advanced Settings from the menu on the right.
    5. Under Process Model click on Identity and click on the 3 dots in the right corner of the box.
    6. Click the pull-down menu under Built-in Account.
    7. Select "LocalSystem" from the list.
    8. Click Ok twice to save the new selection.
    9. From the menu on the right under Application Pool Tasks click on Recycle.

    After this the CDB GET tool was able to connect to the Oracle database.

      
    Related Products:  
       
    1. BMC Capacity Optimization

     


    Article Number:

    000075552


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles