SOLVED

ORA-01017: invalid username/password; logon denied

Asked by OracleDba••12 views•oracle
1
2
3
4
5
ORA-01017: invalid username/password; logon denied

ORA-01017 is a very common error which we get while connection to Oracle Database.

Other than invalid Username/Password, it can be encountered dute to improper connect string, permissions isues or wrong configuration of tnsnames.ora or sqlnet.ora.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
1) If connecting to Oracle 11 or later, passwords can be configured as case sensitive. To check this configuration, run following by SYS/SYSTEM user

SQL> show parameter SEC_CASE_SENSITIVE_LOGON

NAME                           TYPE      VALUE

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

sec_case_sensitive_logon       boolean   TRUE

You can change this configuration and alter password of user and try to connect

SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;

System altered.

SQL> alter user scott identified by <password>;

User Altered.

SQL> CONN scott/<password>

Connected.

2)

Check $ORACLE_SID and $ORACLE_HOME environmental variables to validate.

3) Check whether the user we are trying to connect exists on that instance. Run following by SYS/SYSTEM user.

SQL> SELECT username FROM dba_users where username='SCOTT';

USERNAME

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

SCOTT

4) Check TNSNAMES.ORA to validate that TNS-Alias we are using to connect Oracle Database is pointing to right Database Server and Instance.

Hope it Helps!
OracleDba•

Post Your Solution