Cannot Connect To RCU ODS User, Schema Exists In RCU But Not In The Database

(Doc ID 2180869.1)

Last updated on SEPTEMBER 12, 2016

Applies to:

Oracle Fusion Middleware - Version and later
Information in this document applies to any platform.


During OID installation 'Specify schema database' screen failed with "Cannot connect to the database" error.
Logfiles shows ORA-1017.

RCU shows ODS schema is already configured.
But database does not have ODS schema.
Following sql query confirms that ODS schema is not installed in the database:
 select username from all_users where username = 'ODS';


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