My Oracle Support Banner

ORA-12631 SQLPLUS / AS SYSDBA (Doc ID 1421456.1)

Last updated on JULY 06, 2021

Applies to:

Oracle Fail Safe - Version 3.4.1 and later
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Advanced Networking Option - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Failsafe 3.4.1 setup with database 11.2.0.1, the database can not be started in the Failsafe environment, its status always shows "Failed" and OS event log shows:

ORA-1031 insufficient privileges

Testing sqlplus / as sysdba from command prompt:
1. with sqlnet.ora content:
sqlnet.authentication_services=(NONE)
sqlplus / as sysdba get ORA-1031 insufficient privileges

2. with sqlnet.ora content:
sqlnet.authentication_services=(NTS)
sqlplus / as sysdba get ORA-12631 Username retrieval failed

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.