Database Administration (MOSC)

MOSC Banner

Connecting as SYSTEM in 19C

I cannot connect to a newly created database using the system id - I keep getting a message that my password is incorrect. When I create the database I set the passwords in the create script. For example:


create database DBNAME

user sys identified by manager

user system identified by manager

...


When I attempt to connect using system I get the a message like the following:


$ sqlplus system/manager

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 29 10:35:44 2021

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:


How do I set the system password and get it to work so that I can run scripts like pupbld.sql?

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