ORA-01031 While Connecting As Sysdba On Windows With A Domain User (Doc ID 1071638.1)

Last updated on SEPTEMBER 16, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 10-APR-2013


Symptoms

While trying to connect to a database running on Windows using "/ as sysdba" from an OS session started as a domain user the following error occurs:


sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on M Mar 8 17:22:36 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:
ORA-1031: Insufficient privileges.


The domain user is a direct member of the local ORA_DBA group. If the Oracle Service is started as a domain user and not as Local System Account then the OS authentication will work for any user.

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