Second Database Provider Indicates 0 of 0 Connections Available (Doc ID 803329.1)

Last updated on MAY 31, 2017

Applies to:

Oracle WebCenter Content - Version: 10.1.3.3.3 and later   [Release: 10gR3 and later ]
Information in this document applies to any platform.

Goal

A new database provider is added to a 10gR3 WebCenter Content Server. When the WebCenter Content Server is restarted the provider indicates 0 of 0 connections available. The systemdatabase and new provider are configured as follows;

  • Provider Name: SystemDatabase
  • ProviderDescription: SystemDatabase
  • Provider Type: database
  • Provider Class: intradoc.jdbc.JdbcWorkspace
  • Provider Connection: intradoc.jdbc.JdbcConnection
  • Test Query:  SELECT COUNT(*) FROM CONFIG
  • JDBC Driver: oracle.jdbc.OracleDriver
  • JDBC Connection String: jdbc:oracle:thin:@dbaservername:port:database

 

  • Provider Name: NewProvider
  • ProviderDescription: NewProvider
  • Provider Type: database
  • Provider Class: intradoc.jdbc.JdbcWorkspace
  • Provider Connection: intradoc.jdbc.JdbcConnection
  • Test Query:  SELECT COUNT(*) FROM CONFIG
  • JDBC Driver: oracle.jdbc.OracleDriver
  • JDBC Connection String: jdbc:oracle:thin:@dbaservername:port:database

...

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