PRCA-1084 : FAILED TO RETRIEVE ASM MODE FOR NON-CRS USER

(Doc ID 2333374.1)

Last updated on JANUARY 10, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

- Two node RAC setup with nodes node5,node6
- GI running with 12.1.0.2 release and it was tested with the Databases running from both 12c and 11g HOMEs
- Discrepancy was found in running same command which gave two different results when was run from 12c and 11g RDBMS HOMES.
- The user as which it was run is user "yromanen" which does not have the oinstall as the primary group. The issue is found when the command is executed as this user.

+ yromanen user:
uid=64846982(yromanen) gid=100(guest) groups=100(guest),40763(PRC-AXP-PB-TIMS-PBG-NP_DBA)

+ Grid owner (12.1.0.2):
uid=60023(orcrs) gid=60013(oinstall) groups=60013(oinstall),504(asmadmin),506(asmdba),507(asmoper),20019(pbgsft),60011(dba)

+ 12c db owner:
uid=20103(oratpb02) gid=60013(oinstall) groups=60013(oinstall),506(asmdba),60011(dba)

+ 11g db owner:
uid=20100(oratpb01) gid=60013(oinstall) groups=60013(oinstall),506(asmdba),60011(dba)

 

The below command worked as user "yromanen" in 11.2.0.4 database:

[yromanen@node5 ~]$ export
ORACLE_HOME=/apps/oracle/db/TSXXT99P/product/11.2.0.4
[yromanen@node5 ~]$ ${ORACLE_HOME}/bin/srvctl config database -d
TSXXT99P
Database unique name: TSXXT99P
Database name: TSXXT99P
Oracle home: /apps/oracle/db/TSXXT99P/product/11.2.0.4
Oracle user: oratpb01
Spfile: +DATA_TSXXT99P/tsxxt99p/spfiletsxxt99p.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: TSXXT99P
Database instances: TSXXT99P1,TSXXT99P2
Disk Groups: DATA_TSXXT99P,FRA_TSXXT99P
Mount point paths:
Services:
s_app_mon_xxdev
Type: RAC
Database is administrator managed

 

But, it did not work when the database was running from the 12.1.0.2 RDBMS HOME:

[yromanen@node5 ~]$ export
ORACLE_HOME=/apps/oracle/grid/product/12.1.0.2
[yromanen@node5 ~]$ ${ORACLE_HOME}/bin/srvctl config database -d
TSXXT88P
Database unique name: TSXXT88P
Database name:
Oracle home: /apps/oracle/db/TSXXT88P/product/12.1.0.2
Oracle user: oratpb02
Spfile: +DATA_TSXXT99P/spfileTSXXT88P.ora
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
PRCD-1012 : Failed to retrieve disk group list for database TSXXT88P.
PRCA-1084 : Failed to retrieve ASM Mode
PRKH-1059 : Failed to get ASM mode
PRKH-1056 : Unexpected CSS error(error code[0])
PRKH-1002 : Internal HASContext Error: JNI Native Call Failure



+ The permissions for binaries and other configurations were found to be same.
+ The SRVM_TRACE for the failed command show below logs:

[main] [ 2017-05-08 15:24:15.784 IST ] [ClusterUtil.getASMMode:714] Calling native code getASMMode
[main] [ 2017-05-08 15:24:15.996 IST ] [ClusterUtil.getASMMode:718] Returned from native code
[main] [ 2017-05-08 15:24:15.997 IST ] [ClusterUtil.getASMMode:719] mode string returned from native code is NONE
[main] [ 2017-05-08 15:24:16.017 IST ] [InterruptHandler.unRegisterInterruptHandler:76] UNRegistering shutdown hook.....
[main] [ 2017-05-08 15:24:16.018 IST ] [InterruptHandler.unRegisterInterruptHandler:81] UnRegistered shutdown hook.....
[main] [ 2017-05-08 15:24:16.018 IST ] [OPSCTLDriver.main:242] OPSCTL execute() failed. Unregistered OPSCTL driver's interrupt handler
[main] [ 2017-05-08 15:24:16.018 IST ] [OPSCTLDriver.main:247] exiting abnormally due to FrameworkException
PRCD-1012 : Failed to retrieve disk group list for database orcl.
PRCA-1084 : Failed to retrieve ASM Mode
PRKH-1059 : Failed to get ASM mode
PRKH-1056 : Unexpected CSS error(error code[0])
PRKH-1002 : Internal HASContext Error: JNI Native Call Failure



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms