Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
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
-
- 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.