My Oracle Support Banner

Connecting as SYS/passwd@ AS SYSDBA To A Database In NOMOUNT Status Fails With ORA-01031 (Doc ID 438138.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Oracle Solaris on SPARC (64-bit)
Checked for relevance on 10-APR-2013
Solaris Operating System (SPARC) (64-bit)


Symptoms

With an Oracle 10.2.0.3 database on Sun SPARC Solaris 64-bit, which is started NOMOUNT the following error occurs:

sqlplus sys/<password>@<db_alias> as sysdba
ERROR
ORA-01031: insufficient privileges



By contrast, the following commands DO connect successfully:

sqlplus / as sysdba
sqlplus sys/<password>
sqlplus sys/<password>@<db_alias>



Under these circumstances, when issuing CREATE PFILE FROM SPFILE, the following messages are also generated:

ORA-27037: unable to obtain file status
SVR4 Error: 25: Inappropriate ioctl for device
Additional information: 46


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.