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
|
|
|
|
Re: ORA-01017: invalid username/password [message #686358 is a reply to message #686357] |
Sun, 14 August 2022 07:32 |
Andrey_R
Messages: 441 Registered: January 2012 Location: Israel
|
Senior Member |
|
|
Mahesh Rajendran wrote on Sun, 14 August 2022 15:26https://docs.oracle.com/cd/E81589_01/doc.181/e83238/c_preinstall_db_passwords.htm#SIMIG-DatabaseUserPasswords-86E4F644
Quote:When performing a database installation, specifically Oracle Database users, passwords must adhere to the following rules:
Cannot start with a number (for example, 1QasHello)
Thanks, but the result is the same when I tried any other combination
SQL> drop user test cascade;
User dropped.
SQL> create user test identified by "a";
User created.
SQL> grant connect to test;
Grant succeeded.
SQL> conn test/"a"
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> conn test/a
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> conn test/A
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> conn test/"A"
ERROR:
ORA-01017: invalid username/password; logon denied
|
|
|
|
Re: ORA-01017: invalid username/password [message #686361 is a reply to message #686359] |
Mon, 15 August 2022 08:30 |
Andrey_R
Messages: 441 Registered: January 2012 Location: Israel
|
Senior Member |
|
|
Michel Cadot wrote on Sun, 14 August 2022 16:37I bet you do not try to connect on the same database than you have created the user.
Execute the following:
connect system/manager
-- or any other account with CREATE USER privilege or DBA role but NOT SYS
create user test identified by "a";
grant connect to test;
conn test/"a"
It was on the database server.
However, I apologize, I can no longer replicate the issue as the environment on which it happened was modified and issue no longer persists.
Modification was SQLNET.ORA change ( sqlnet.ora => sqlnet.allowed_logon_version_server=11 )
I still don't understand why without it a explicit "a123" specified upon creation and connection attempt will not work perfectly.
Unofortunately, I cannot complete this investigation
Sorry for the hassle and thank you.
Andrey
|
|
|