ORA-1031 Connect as Sysdba Using Password File
(Doc ID 563156.1)
Last updated on FEBRUARY 02, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.5 [Release 9.2 to 10.2]Information in this document applies to any platform.
Symptoms
1) FILESYSTEMIO_OPTIONS has been set to SETALL or DIRECTIO in the initialization parameter file.
2) When trying to connect to the database with the sysdba privilege using listener, it fails with ORA-1031.
4) There are no issues with the normal users connecting to the database using listener.
The parameter remote_login_passwordfile has been set to exclusive in the parameter file.
The password file with the correct name exists in the $ORACLE_HOME/dbs directory and have the correct ownership and permission as per <Note 392027.1>.
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 |
| Cause |
| Solution |
| References |