My Oracle Support Banner

Setting up External Search Collection in WCC 11g (Doc ID 1444813.1)

Last updated on MAY 30, 2018

Applies to:

Oracle WebCenter Content - Version 11.1.1.3.0 and later
Information in this document applies to any platform.
checked for relevance 27-Sep-2013

Goal

The Oracle Content Server instance can use OracleTextSearch with an external database that is not the "system database". If you select this option, you must provide the name of the external data source on the post-configuration page after starting WCC for the first time.  This note describes that process, as well as how to setup an external data  source on a WCC instance where content already exists in the system (and therefore the post-configuration page cannot be used). 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
 Before reading the solution, please download <Patch 21617568> and read it!  Also, Please note that JDBC parameters are required to be used instead of WLS datasource for using the standalone app Repository Manager.

11g: https://docs.oracle.com/cd/E29542_01/doc.1111/e14495/configucm.htm#INECM1672
==============================================
4.5.2 Configuring an External Database Provider for Standalone Applications

You can create an external database provider in Content Server for standalone applications, such as the Batch Loader utility, to connect directly to the database with JDBC without using the SystemDatabase Provider for the Oracle WebLogic Server data source. For standalone applications to use OracleTextSearch, you must configure the external database provider to include the JDBC connection information.

By default, the configuration of an incoming provider does not include values for JDBC Driver and JDBC Connection String. You need to add these values, but be careful not to change the provider name because you cannot rename an existing provider. To change the name of a provider, you need to delete it and add it again. For information about changing the configuration of a provider, see ”Editing Provider Configuration” in Oracle Fusion Middleware Administering Oracle WebCenter Content.
==============================================

12c: https://docs.oracle.com/middleware/12213/wcc/webcenter-content-admin/GUID-F3BCDC95-EA83-4542-844C-31731CFEE65F.htm#WCCSA197

For example,
======================================
Provider Name: ExternalSearchProvider
Provider Description: External Database Provider
Provider Class: intradoc.jdbc.JdbcWorkspace
Provider Connection: intradoc.jdbc.JdbcConnection

Database Type: ORACLE
Jdbc Driver: oracle.jdbc.OracleDriver
Jdbc Connection String: jdbc:oracle:thin:@localhost:1521:orcl
UseDataSource:  [BLANK]

Test Query=SELECT 1 FROM DUAL

Jdbc User: app4_ocssearch
Jdbc Password: <user password>
Number of Connections: 5
Extra Storage Keys: system
======================================

Also created new KM below
Rebuilds fail using standalone app Repository Manager when using External Search Collection (Doc ID 2404604.1)
 Create the schema using RCU
 Create Data Source in WebLogic
 Set External DataSource on WCC PostConfiguration Page
 Restart Managed Server
 Perform Collection Rebuild
 If changing to use External Data Source on WCC  instance that already contains content:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.