What should I do - ora 01017 invalid username password logon denied
I'm trying to connect to a remote instance as sysdba - however, I encounter the error: "ORA-01017: invalid username/password; logon denied".
$ sqlplus "sys/xxxx@:1521/sid1 as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 29 04:07:34 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
When I try to connect to another instance on the same server, I can get through:
$ sqlplus "sys/xxxx@:1521/sid2 as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 29 04:07:23 2015
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, OLAP, Data Mining and Real Application Testing options
SQL>
Can someone point me to what I may have missed here?
In case of - ora 01017 invalid username password logon denied
Seems simply a password issue. Different instances may have different passwords, the SYS password is not necessarily the same for all the instances on the same server. Make sure remote_login_passwordfile is configured properly in the instances, and the password file exists for instance SID1 on the server in ORACLE_HOME/dbs/orapwSID1 (Linux-Unix) or ORACLE_HOME/database/pwdSID1.ora (Windows).
If you do not know the correct SYS password, you can recreate the password file, for example:
orapwd file=$ORACLE_HOME/dbs/orapwsid1 password=xxxx force=y
Answer (1)
The ORA-01017 error in Oracle indicates that the provided username and/or password is invalid, and the login attempt has been denied. Here's what you should do to address this issue:
Verify Username and Password: Double-check the username and password you are using to log in. Ensure there are no typos or mistakes in the credentials. Remember that Oracle usernames and passwords are case-sensitive.
Reset Password: If you suspect that the password might be incorrect or if you've forgotten it, consider resetting the password for the user. Depending on your setup and permissions, you may need assistance from a database administrator (DBA) to reset the password.
Unlock the Account (if necessary): Sometimes, an account may become locked due to multiple failed login attempts. If you suspect this is the case, you can ask your DBA to unlock the account.
Check Account Status: Ensure that the user account you are trying to log in with is active and not expired. If the account has expired or is locked, you may need administrative privileges to rectify the situation.
Review Connection Configuration: If you're connecting through a client application or script, review the connection configuration to ensure it's pointing to the correct database instance and using the correct authentication method.
Check for Case Sensitivity: Remember that Oracle usernames and passwords are case-sensitive. Make sure you're entering the username and password exactly as they were created.
Check for Database Connectivity Issues: Ensure that there are no network or firewall issues preventing your client from connecting to the Oracle database.
Review Audit Logs: If necessary, review the Oracle audit logs to see if there are any additional details or errors that could provide insight into why the login attempt is failing.
Contact Database Administrator: If you've exhausted all other options and are still unable to resolve the issue, contact your database administrator or Oracle support for further assistance. They may be able to provide additional troubleshooting steps or reset the account if needed.
By following these steps, you should be able to diagnose and resolve the ORA-01017 error and successfully log in to the Oracle database.