Symptoms:
When tyring to login on the db instance using sqlplus / as sysdba, gets ORA-01017: invalid username/password; logon denied.
Cause:
Operating system authentication may have been deliberately disabled.
Solution:
Look at the sqlnet.ora file located at $ORACLE_HOME/network/admin and check the value of parameter sqlnet.authentication_services.
If you get the operating system authentication disabled, this parameter is set with the value:
#SQLNET.AUTHENTICATION_SERVICES = (NONE)
If you want to allow connection using operating system authentication, remove or comment out the line:
#SQLNET.AUTHENTICATION_SERVICES = (NONE)
Subscribe to:
Posts (Atom)
Configure the Oracle DB Access Control List to avoid error like ORA-24247: network access denied
Symptoms: You try to make external connections from the Oracle Database and receive erros like ORA-24247: network access denied by access c...
-
Symptoms: When trying to compile an Oracle Forms, it gives an error such as "FRM-30085: Unable to adjust form for output." Si...
-
Symptoms : When starting the Weblogic it presents error such as this: Error message: JPS-01055: Could not create credential store instanc...
-
Symptoms : When having a transaction with database link involved, it results in an error that says: ORA-03150: end-of-file on communicati...