My Oracle Support Banner

ORA-1031 Connect as Sysdba Using Password File (Doc ID 563156.1)

Last updated on FEBRUARY 27, 2019

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.