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 Go to next message
Andrey_R
Messages: 409
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 #686357 is a reply to message #686356] Sun, 14 August 2022 07:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
https://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)

Re: ORA-01017: invalid username/password [message #686358 is a reply to message #686357] Sun, 14 August 2022 07:32 Go to previous messageGo to next message
Andrey_R
Messages: 409
Registered: January 2012
Location: Israel
Senior Member
Mahesh Rajendran wrote on Sun, 14 August 2022 15:26
https://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 #686359 is a reply to message #686358] Sun, 14 August 2022 08:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68342
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I 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"
Re: ORA-01017: invalid username/password [message #686361 is a reply to message #686359] Mon, 15 August 2022 08:30 Go to previous message
Andrey_R
Messages: 409
Registered: January 2012
Location: Israel
Senior Member
Michel Cadot wrote on Sun, 14 August 2022 16:37
I 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 Sad

Sorry for the hassle and thank you.

Andrey
Previous Topic: Getting password
Next Topic: how to retrieve user logging 120 days ago
Goto Forum:
  


Current Time: Mon Jan 30 01:18:22 CST 2023