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.