Setting SQLNET.AUTHENTICATION_SERVICES=(NONE) on sqlnet.ora causes dbstart to fail to start the database.
(Doc ID 3073717.1)
Last updated on MARCH 12, 2025
Applies to:
Oracle Database - Standard Edition - Version 12.2.0.1 and laterOracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.
Symptoms
If you set SQLNET.AUTHENTICATION_SERVICES=(NONE) in sqlnet.ora, the database fails to start using dbstart.
The following ORA-01017 error appears in the alert log:
---
Copyright (c) 1982, 2016, Oracle. All rights reserved.
SQL> ERROR:
ORA-01017: invalid username/password; logon denied
SQL> SP2-0640: Not connected
---
Changes
Setting SQLNET.AUTHENTICATION_SERVICES=(NONE) disables OS authentication, requiring explicit username and password credentials to connect to the database.
Example configuration:
$ cat $ORACLE_HOME/network/admin/sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES=(NONE)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |