My Oracle Support Banner

PRCA-1084 : FAILED TO RETRIEVE ASM MODE FOR NON-CRS USER (Doc ID 2333374.1)

Last updated on MARCH 06, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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 "test" which does not have the oinstall as the primary group. The issue is found when the command is executed as this user.

+ test user:
uid=64846982(test) gid=100(guest) groups=100(guest)

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

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

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

 

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

[test@node5 ~]$ export
ORACLE_HOME=<11.2.0.4 Database Oracle Home>
[yromanen@node5 ~]$ ${ORACLE_HOME}/bin/srvctl config database -d
TEST
Database unique name: TEST
Database name: TEST
Oracle home: <11.2.0.4 Database Oracle Home>
Oracle user: ora01
Spfile: +DATA/test/spfiletest.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: TEST
Database instances: TEST1,TEST2
Disk Groups: DATA,FRA
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:

[test@node5 ~]$ export
ORACLE_HOME=<12c Database home>
[yromanen@node5 ~]$ ${ORACLE_HOME}/bin/srvctl config database -d
TEST_NEW
Database unique name: TEST_NEW
Database name:
Oracle home: <12c Database home>
Oracle user: oratpb02
Spfile: +DATA/spfileTEST_NEW.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 TEST_NEW.
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 TEST_NEW.
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



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.