Cannot Connect To RCU ODS User, Schema Exists In RCU But Not In The Database
Last updated on SEPTEMBER 12, 2016
Applies to:Oracle Fusion Middleware - Version 220.127.116.11.0 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