Database Administration (MOSC)

MOSC Banner

SQLPlus Local Login on the Database (DB) Host Fails with "ORA-01017: invalid username/password; logo

DB VERSION:19.3

OS VERSION:Red Hat Enterprise Linux Server release 7.4 (Maipo)

When I create a new account in pdb,and try login the pdb,then an error occured.

15:51:21 sys@ora19c.PDBTEST > create user u01 identified by 123;


User created.


Elapsed: 00:00:00.03


15:51:54 sys@ora19c.PDBTEST > grant connect,resource to u01;


Grant succeeded.


Elapsed: 00:00:00.00

15:52:05 sys@ora19c.PDBTEST > select username,account_status from dba_users where username='U01';


USERNAME       ACCOUNT_STATUS

-------------------- --------------------------------

U01         OPEN


1 row selected.


Elapsed: 00:00:00.01

15:52:35 sys@ora19c.PDBTEST > conn u01

Enter password:

ERROR:

ORA-01017: invalid username/password; logon denied



Warning: You are no longer connected to ORACLE.

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