Attempt to create a database in Oracle Restart environment fails and the following error
ORA-01017: invalid username/password; logon denied . For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/multisrv1/crs/trace/ohasd_oraagent_grid.trc". CRS-2674: Start of 'ora.cdb1.db' on 'multisrv1' failed ORA-01017: invalid username/password; logon denied oracle.cluster.impl.crs.cops.CRSNativeResult.createException(CRSNativeResult.java:617) oracle.cluster.impl.crs.cops.CRSNative.doStartResource(Native Method) oracle.cluster.impl.crs.cops.CRSNative.genericStartResource(CRSNative.java:567) oracle.cluster.impl.crs.cops.EntityOperations.startResource(EntityOperations.java:678) oracle.cluster.impl.crs.CRSResourceImpl.start(CRSResourceImpl.java:883) oracle.cluster.impl.crs.CRSResourceImpl.start(CRSResourceImpl.java:858) oracle.cluster.impl.crs.CRSResourceImpl.start(CRSResourceImpl.java:846) oracle.cluster.impl.common.SoftwareModuleImpl.start(SoftwareModuleImpl.java:525) oracle.sysman.assistants.util.hasi.HADatabaseUtils.start(HADatabaseUtils.java:1476) oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:1145) oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:278) oracle.sysman.assistants.util.step.Step.execute(Step.java:135) oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2941) java.lang.Thread.run(Thread.java:745) [Thread-291] [ 2018-05-01 10:46:38.078 GST ] [PostDBCreationStep.executeImpl:1156] Exception while Starting with HA Database Resource PRCR-1079 : Failed to start resource ora.cdb1.db CRS-5017: The resource action "ora.cdb1.db start" encountered the following error: ORA-01017: invalid username/password; logon denied . For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/multisrv1/crs/trace/ohasd_oraagent_grid.trc". CRS-2674: Start of 'ora.cdb1.db' on 'multisrv1' failed ORA-01017: invalid username/password; logon denied
Cause:
grid user is not under dba group.
[root@multisrv1 ~]# id grid uid=54323(grid) gid=54321(oinstall) groups=54321(oinstall),492(vboxsf),54323(asmadmin),54324(asmdba)
Solution:
Add grid user to dba group and relink the oracle binary
[root@multisrv1 ~]# usermod -a -G dba grid [root@multisrv1 ~]# id grid uid=54323(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),492(vboxsf),54323(asmadmin),54324(asmdba) [oracle@multisrv1 bin]$ ./relink all writing relink log to: /u01/app/oracle/product/12.2.0.1/db_1/install/relink.log [oracle@multisrv1 bin]$