Home » RDBMS Server » Security » ORA-01017: invalid username/password (Win Server 2019, Oracle 19c non-CDB)
ORA-01017: invalid username/password [message #686356] |
Sun, 14 August 2022 05:57  |
Andrey_R
Messages: 441 Registered: January 2012 Location: Israel
|
Senior Member |
|
|
Hi all,
I am creating a user with a simple password - it doesn't let me connect.
SQL> create user test identified by 1;
User created.
SQL> grant connect to test;
Grant succeeded.
SQL> conn test/1
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL>
SYS does connect OK
SQL>
SQL> conn sys as sysdba
Enter password:
Connected.
SQL>
SQLNET.ORA has
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
Thanks
|
|
|
|
|
|
|
Goto Forum:
Current Time: Tue Jun 03 08:15:11 CDT 2025
|