Receiving The Error, 'Oraoledb.Oracle' provider is not registered on the local machine, During The Post Installation GRCM 7.8 Steps (Doc ID 1101821.1)

Last updated on OCTOBER 02, 2016

Applies to:

Oracle Governance, Risk and Compliance Manager - Version 7.8 and later
Information in this document applies to any platform.

Symptoms

When executing the saving a "Business Process" as part of the post-install steps listed in the "Test the Configuration" section on pp 3-20 of the GRC Manager 7.8 Implementation guide, the following error is displayed::

CMSSearch.GetChildren: Stellent Error: 5 GetDocumentByParentId The 'OraOLEDB.Oracle' provider is not registered on the local machine. in CMSSearch.Execute: Parent=000008 Types=SOA_CTC. in SoxSearch.Execute: Parent=000008 Types=SOA_CTC.
at SoxDocMgmt.SoxBase.handleException(String Message, Exception ex, Int32 Severity)
at SoxDocMgmt.SoxSearch.pGetChildren(String ParentId, String Columns, Boolean UseRevisionId, String DocumentType, String strLogin, Boolean blnIncludeRetire, Boolean blnTransformResult, enumSearchType intSoxSearchType)
at SoxDocMgmt.SoxSearch.GetChildren(String ParentId, String Columns, Boolean UseRevisionId, String DocumentType, String strLogin, Boolean blnIncludeRetire, Boolean blnTransformResult, enumSearchType intSearchType)
at SoxNav.GlobalsUI.pLoadChildren(String LoginId, String ParentId, Boolean UseParentRevision, String ChildType, String Columns, String strXmlPrefix, String strXmlSuffix, DataSet TargetDataset, String TransformPath, Boolean blnIncludeRetire, Boolean blnTransformResults, enumSearchType intSearchType)
at SoxNav.GlobalsUI.LoadChildren(String LoginId, String ParentId, Boolean UseParentRevision, String ChildType, String Columns, String strXmlPrefix, String strXmlSuffix, DataSet TargetDataset, String TransformPath, Boolean blnIncludeRetire, Boolean blnTransformResults, enumSearchType intSearchType)
at SoxNav.SoxPage.LoadChildDatagrid(String strChildTypes, String strColumns, String strUrlPrefix, Int32 intLinkColumn, DataSet dsTarget, DataGrid dgTarget, String TransformPath, String DocStateColName, String DocStateListName)

Changes

This is a new installation of GRC Manager 7.8 on Windows platform.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms