My Oracle Support Banner

Cannot Alter ORDS_PUBLIC_USER Password After Database Upgrade, ORA-65066 / ORA-01918 Errors (Doc ID 2774163.1)

Last updated on MARCH 13, 2024

Applies to:

Oracle REST Data Services - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

Upgraded Database from 12c (Non-multitenant) to 19c (multitenant).

Unable to change password for ORDS_PUBLIC_USER, APEX_PUBLIC_USER, APEX_REST_PUBLIC_USER, APEX_LISTENER.

Errors encountered when attempting to change password ->

From PDB:
ORA-65066: The specified changes must apply to all containers

From CDB$ROOT:
ORA-01918: user 'ORDS_PUBLIC_USER' does not exist

 

The ORDS / APEX schemas exist only in the PDB and not in the CDB$ROOT.

 

Changes

 Upgraded Database from 12c (Non-multitenant) to 19c (multitenant).

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.