CODEWITHSUNDEEP
oracle-databaseuser-accountsoracle19c
misaki
misaki

Reputation: 21

Unlocking SCOTT user in oracle 19c

Trying to unlock SCOTT in oracle 19c.

 alter user scott account unlock identified by tiger;

ERROR Message: ORA-01918: user 'SCOTT' does not exist

Upvotes: 2

Views: 5112

Answers (2)

Abhijit Bavdhankar
Abhijit Bavdhankar

Reputation: 13

In ORACLE 19C How TO CHANGE sysdba password.

Upvotes: 0

Lalit Kumar B
Lalit Kumar B

Reputation: 49092

From documentation:

Starting from Oracle 12cR2, only HR schema is provided via installation. All other sample schema scripts are available on GitHub at https://github.com/oracle/db-sample-schemas/releases/latest

SCOTT schema is no longer provided in the sample schemas, you could manually create it using the scripts from older Oracle versions or use the HR and other sample schemas.

Once you install the sample schemas manually in PDB, you could then unlock them and use. See Oracle Multi-tenant DB Post Installation Mandatory Steps

Upvotes: 2

Related Questions