Starting / Stopping RAC Database (with srvctl) Fails With ORA-01031: insufficient privileges and ORA-01005: null password given
(Doc ID 1450253.1)
Last updated on OCTOBER 11, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.7 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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 RACDB -o immediate
PRKP-1002 : Error stopping instance racdb1 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
PRKP-1002 : Error stopping instance racdb1 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
Changes
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 |
Changes |
Cause |
Solution |