Startup failed with below
error:
/u01/app/oracle/product/11.2.0_64/dbs>
sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on
Mon Feb 11 03:50:41 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORA-01078: failure in processing system
parameters
ORA-01565: error in identifying file '+DB_REDO/PRD31/PARAMETERFILE/spfile.281.999919915'
ORA-17503: ksfdopn:2 Failed to open file +DB_REDO/PRD31/PARAMETERFILE/spfile.281.999919915
ORA-01017: invalid username/password; logon
denied
SQL> exit
Note: Database
fail to start with ORA-01017 due to wrong group setup (Doc ID 1922050.1)
Verify group setup for oracle user on both
nodes:
[grid@dbhost1 bin]$ id oracle
uid=54321(oracle)
gid=54321(oinstall) groups=54321(oinstall),54322(dba),54324(asmdba)
Group setup is different from node1
[grid@dbhost2 bin]$ id oracle
uid=54321(oracle)
gid=54321(oinstall) groups=54321(oinstall),54322(dba),26049(test)
Correct group id on node 2
root@dbhost2# /usr/sbin/usermod -G
oinstall,dba,asmdba oracle
root@dbhost2# id oracle
uid=54321(oracle)
gid=54321(oinstall) groups=54321(oinstall),54322(dba),54324(asmdba)
Instance started without any issue after fixing group setup on node2
Instance started without any issue after fixing group setup on node2
No comments:
Post a Comment