安装12.2.0.1单实例ASM。dbca报错？

[ora.cdb.db]{0:0:1343} [start] ORA-01017: invalid username/password; logon denied

Database Creation in Oracle Restart Environment Fails With "ORA-01017: Invalid Username/password" (文档 ID 2108268.1)

In this Document

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later

---

 

APPLIES TO:

Oracle Database Configuration Assistant - Version 12.1.0.1 and later
Information in this document applies to any platform.

SYMPTOMS

Attempt to create a database in Oracle Restart environment fails and the following error is observed in DBCA trace.log available under $ORACLE_BASE/cfgtoollogs/dbca/<SID>

[Thread-209] [ 2016-02-15 16:06:20.842 CET ] [PostDBCreationStep.executeImpl:1073] Exception while Starting with HA Database Resource PRCR-1079 : Failed to start resource ora.orcl.db
ORA-01017: invalid username/password; logon denied
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-01017: invalid username/password; logon denied
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/rac1/crs/trace/ohasd_oraagent_grid.trc".

CRS-2674: Start of 'ora.orcl.db' on 'rac1' failed
ORA-01017: invalid username/password; logon denied
[Thread-209] [ 2016-02-15 16:07:05.740 CET ] [PostDBCreationStep.executeImpl:1115] Connecting for SIHA/RAC

The database software installation log had the following error logged regarding the group membership of "grid" user

INFO: Group Membership: dba: This is a prerequisite condition to test whether user "grid" is a member of the group "dba".
INFO: Severity:CRITICAL
INFO: OverallStatus:VERIFICATION_FAILED

CAUSE

In an Oracle Restart environment, the Grid Infrastructure owner (typically, grid) should be a member of OSDBA group in order to be able to manage database files managed by Oracle ASM. 

SOLUTION

The solution is to add the user "grid" to OSDBA group of the database, relink the binaries and execute dbca to create the database.

01) Add the user "grid" to OSDBA group (for example, dba)

# id grid
uid=501(grid) gid=502(oinstall) groups=502(oinstall)
# usermod -a -G dba grid
# id grid
uid=501(grid) gid=502(oinstall) groups=502(oinstall),503(dba)

02) Recompile the DB binaries (execute as oracle user)

$ export ORACLE_BASE=/u01/app/oracle
$ export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
$ export PATH=$ORACLE_HOME/bin:$PATH
$ relink all

03) If there are no errors reported in $ORACLE_HOME/install/relink.log, then proceed with creating the database

$ dbca

Reference :
About Oracle Installations with Job Role Separation