srvctl starting / stopping RAC Database fails with ORA-01031: insufficient privileges and ORA-01005: null password given (Doc ID 1450253.1)

Last updated on NOVEMBER 18, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

Stopping, Starting RAC database via srvctl or re-start of clusterware stack, fails to start database.
Reported to the screen is the error codes ORA-01031: insufficient privileges and ORA-01005: null password given; logon denied
Starting the database via sqplus works.
srvctl reports :

srvctl stop database -d ORCL -o immediate
PRKP-1002 : Error stopping instance orcl1 on node Node1
Node1:ora.orcl.orcl1.inst:
Node1:ora.orcl.orcl1.inst:SQL*Plus: Release 11.1.0.7.0 - Production on Fri Mar 23 13:01:25 2012
Node1:ora.orcl.orcl1.inst:
Node1:ora.orcl.orcl1.inst:Copyright (c) 1982, 2008, Oracle.  All rights reserved.
Node1:ora.orcl.orcl1.inst:
Node1:ora.orcl.orcl1.inst:Enter user-name: ERROR:
Node1:ora.orcl.orcl1.inst:ORA-01031: insufficient privileges
Node1:ora.orcl.orcl1.inst:
Node1:ora.orcl.orcl1.inst:
Node1:ora.orcl.orcl1.inst:Enter user-name: SP2-0306: Invalid option.
Node1:ora.orcl.orcl1.inst:Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER|SYSASM}]
Node1:ora.orcl.orcl1.inst:where <logon>  ::= <username>[/<password>][@<connect_identifier>] [edition=value] | /
Node1:ora.orcl.orcl1.inst:Enter user-name: Enter password:
Node1:ora.orcl.orcl1.inst:ERROR:
Node1:ora.orcl.orcl1.inst:ORA-01005: null password given; logon denied
Node1:ora.orcl.orcl1.inst:
Node1:ora.orcl.orcl1.inst:
Node1:ora.orcl.orcl1.inst:SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
Node1:ora.orcl.orcl1.inst:
Node1:ora.orcl.orcl1.inst:
Node1:ora.orcl.orcl1.inst:SQL*Plus: Release 11.1.0.7.0 - Production on Fri Mar 23 13:01:27 2012
Node1:ora.orcl.orcl1.inst:
Node1:ora.orcl.orcl1.inst:Copyright (c) 1982, 2008, Oracle.  All rights reserved.
Node1:ora.orcl.orcl1.inst:
Node1:ora.orcl.orcl1.inst:Enter user-name: ERROR:
Node1:ora.orcl.orcl1.inst:ORA-01031: insufficient privileges
Node1:ora.orcl.orcl1.inst:
Node1:ora.orcl.orcl1.inst:
Node1:ora.orcl.orcl1.inst:Enter user-name: SP2-0306: Invalid option.
Node1:ora.orcl.orcl1.inst:Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER|SYSASM}]
Node1:ora.orcl.orcl1.inst:where <logon>  ::= <username>[/<password>][@<connect_identifier>] [edition=value] | /
Node1:ora.orcl.orcl1.inst:Enter user-name: Enter password:
Node1:ora.orcl.orcl1.inst:ERROR:
Node1:ora.orcl.orcl1.inst:ORA-01005: null password given; logon denied
Node1:ora.orcl.orcl1.inst:
Node1:ora.orcl.orcl1.inst:
Node1:ora.orcl.orcl1.inst:SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

 

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