Start/Connect To OWB Control Center Fails With RPE-02226 - ORA-00018/RTC-5260
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.
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:
The Control Center Service log file reports the following messages :
- 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.
The Database has been upgraded.
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