Solution for PRCR-1079 CRS-5017 ORA-01017

Issue:

If grid user is not a member of dba group, then DBCA will fails at end of database creation 49% of total progress and 

DBCA will perform rollback of database creation

(database will not be created).

The error below will be raised:

PRCR-1079 CRS-5017 ORA-01017

PRCR-1079 : Failed to start resource ora.prdcdb.db
ORA-01017: invalid username/password; logon denied
CRS-5017: The resource action "ora.istdb.db start" encountered the following
error: ORA-01017: invalid username/password; logon denied
. For details refer to "(:CLSN00107:)" in "/oracle/app/grid/diag/crs/dm04GG01/crs/
trace/ohasd_oraagent_grid.trc".

Solution :
To fix the issue you must add user "grid" to group "dba" and relink RDBMS Binaries.

[root@dm04GG01 ~]# usermod -a -G dba grid


[root@dm04GG01 ~]# id grid
uid=501(grid) gid=501(oinstall) groups=501(oinstall),502(dba),504(asmadmin),506(asmdba),507(asmoper)
[root@dm04GG01 ~]# id oracle
uid=502(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),506(asmdba),507(asmoper)

[oracle@dm04GG01 ~]$ relink all
writing relink log to: /oracle/app/orawork/product/12.2.0.1/db_1//install/relink.log

If there are no errors in $ORACLE_HOME/install/relink.log, then retry to create the database with dbca.
crsctl status after database creation :

--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       dm04gg01                 STABLE
ora.FRA.dg
               ONLINE  ONLINE       dm04gg01                 STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       dm04gg01                 STABLE
ora.asm
               ONLINE  ONLINE       dm04gg01                 Started,STABLE
ora.ons
               OFFLINE OFFLINE      dm04gg01                 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       dm04gg01                 STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       dm04gg01                 STABLE
ora.istdb.db
      1        ONLINE  ONLINE       dm04gg01                 Open,HOME=/oracle/ap
                                                             p/orawork/product/12
                                                             .2.0.1/db_1,STABLE
--------------------------------------------------------------------------------

• Tweet
• Share
• Share
• Share
• Share

Related Post