How Do You Remove the Query Processor (And Linked Servers) From an Upgraded IPM 10gR3 System? (Doc ID 1060835.1)

Last updated on JUNE 30, 2016

Applies to:

Oracle Imaging and Process Management - Version 10.1.3.3.1 to 10.1.3.6 [Release 10gR3]
Information in this document applies to any platform.

Goal

As of Oracle IPM 7.7, installing Microsoft SQL Server as a local query processor on the Information Broker is optional. Information Broker may be configured to provide additional searching capabilities to multiple data sources, but these searching capabilities require that Microsoft SQL Server be installed on every Information Broker Server. This is also required if any of the following features will be implemented:
  • Full-Text Indexing and Searching 
  • External data searching retrieval 
  • DOD certified Records Management
These should be the only circumstances where a local Query Process is required.

The steps in this document will provide information on removing the Query Processor from an upgraded IPM system.

Solution

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