Start/Connect To OWB Control Center Fails With RPE-02226 - ORA-00018/RTC-5260 (Doc ID 869143.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms

After a database upgrade the Oracle Warehouse Builder Control Center becomes "Not Available" after 3-4 days.

Connecting to the Control Center Manager returns the following message:

RTC-5260 : Failed to connect to runtime platform, Please check you have provided the correct Host, user, password and Service Name.

The Control Center Service log file reports the following messages :

oracle.wh.runtime.platform.adapter.InfrastructureException: RPE-01003: An infrastructure condition prevented the request from completing.
- RPE-02226: Cannot test Control Center user ETL_LOG. This user must match the login credentials of the deployment location.
- ORA-00604: error occurred at recursive SQL level 1
ORA-00018: maximum number of sessions exceeded

 

The Control Center Service manual start-up requires many attempts before it becomes available. 

Changes

The Database has been upgraded.

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