My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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]
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!


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