Monday 11 February 2019

Unable to start Instance on RAC Node2 with error ORA-01017: invalid username/password


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


No comments:

Post a Comment