Forum Stats

  • 3,828,179 Users
  • 2,260,870 Discussions
  • 7,897,506 Comments

Discussions

sys user with password shows ora-01017 occasionally

Has anyone faced this before??

[[email protected] dbs]$ sqlplus sys/[email protected] as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Thu Oct 14 20:15:55 2021


Copyright (c) 1982, 2013, Oracle. All rights reserved.


ERROR:

ORA-01017: invalid username/password; logon denied



Enter user-name: ^C

[[email protected] dbs]$ sqlplus sys/[email protected] as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Thu Oct 14 20:16:00 2021


Copyright (c) 1982, 2013, Oracle. All rights reserved.



Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options


SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

[[email protected] dbs]$ sqlplus sys/[email protected] as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Thu Oct 14 20:16:11 2021


Copyright (c) 1982, 2013, Oracle. All rights reserved.



Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options


SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

[[email protected] dbs]$ sqlplus sys/[email protected] as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Thu Oct 14 20:16:16 2021


Copyright (c) 1982, 2013, Oracle. All rights reserved.


ERROR:

ORA-01017: invalid username/password; logon denied


SQL> conn sys/[email protected] as sysdba

Connected.

SQL> conn sys/[email protected] as sysdba

ERROR:

ORA-01017: invalid username/password; logon denied



Warning: You are no longer connected to ORACLE.

SQL> conn sys/[email protected] as sysdba

Connected.

SQL> conn sys/[email protected] as sysdba

Connected.

SQL> conn sys/[email protected] as sysdba

ERROR:

ORA-01017: invalid username/password; logon denied



Warning: You are no longer connected to ORACLE.

SQL> conn sys/[email protected] as sysdba

ERROR:

ORA-01017: invalid username/password; logon denied



SQL> conn sys/[email protected] as sysdba

Connected.

SQL> 


If yes, kindly let me know how you have resolved this ?

Also, would like to know the cause .

sec_case_sensitive_logon is set to TRUE.

Answers

  • Nikhil Kotak
    Nikhil Kotak Member Posts: 5 Red Ribbon
    • Validate the permissions of Oracle executable in $Oracle_Home/bin directory
    • Check if there is any trigger on OS level which might conflicts or writing in the same directory
    • Verify the space utilization in /u01.
    • Create a new password file in dbs location with orapwd utility.