Database Administration (MOSC)

MOSC Banner

Oracle container databases 19C

edited Apr 20, 2023 7:14AM in Database Administration (MOSC) 10 commentsAnswered

Hi,

We have recently upgraded to the ORacle 19c Database using container/pluggable databases. This has been done by a 3rd party DBA, but have recently found that they have set the SYSTEM user to expire. I am having issues trying to change the password ad I am getting messages to say "

However, as far as I know, when logging into sqplus, the database I use is what I have been told is the container name.

When using the Alter session set Container=CDB$ROOT I get this

When replacing the "CDB" bit with what I think is the container name I get

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center