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

Last updated on DECEMBER 06, 2016

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.
***Checked for relevance on 09-Sep-2016***


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.

sqlplus 'sys/****@xyz as sysdba'

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 2 22:59:15 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges



3) Local sysdba connection goes through fine.

sqlplus 'sys/**** as sysdba'

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 2 22:59:26 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options



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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms