Solution - Process Framework - Unable to connect to Process Framework database with Oracle

Version 2


    Attempting to log into the Process Framework tables, for example via the Designer or Session Manager interfaces in ArcMap or through the "Process Framework Administration Tool" utility, using Oracle client, fails with the the error "Provider cannot be found. It may not be properly installed."



    This is due to a known bug with the Oracle client, #13417266: "While upgrading to, installer fails to register ORAOLEDB.DLL".


    (from Oracle's original listing of bug #13417266)


    To complete the installation of the Oracle Provider for OLE DB. Please complete the following steps:

    1. Open command prompt, if you are running on Windows 7 or Windows 2008 please make sure to run the command window with "Run As Administrator" privileges.

    2. In the command window execute the following command to register the Oracle Provider for OLE DB :

    regsvr32 <oraclehome>\bin\OraOLEDB11.dll

    Where is the physical path to the Oracle home where the driver is installed. i.e





    Oracle login failure