RAC ONE Db For DBFS Repository (Doc ID 1543410.1)

Last updated on MAY 24, 2013

Applies to:

Exadata X3-2 Quarter Rack - Version All Versions to All Versions [Release All Releases]
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

 Following "Configuring DBFS on Oracle Database Machine (Doc ID 1054431.1)" to setup dbfs on a RAC One Node and find that DBFS mounting via Oracle Clusterware will not work. The crsctl start command fails with CRS-2674.

crsctl start resource dbfs_mount
CRS-2672: Attempting to start 'ora.prddbfs.db' on 'hostname01'
CRS-2676: Start of 'ora.prddbfs.db' on 'hostname01' succeeded
CRS-2672: Attempting to start 'ora.prddbfs.dbfs.svc' on 'hostname01'
CRS-2672: Attempting to start 'dbfs_mount' on 'hostname01'
CRS-2676: Start of 'ora.prddbfs.dbfs.svc' on 'hostname01' succeeded
CRS-2674: Start of 'dbfs_mount' on 'hostname01' failed
CRS-2679: Attempting to clean 'dbfs_mount' on 'hostname01'
CRS-2681: Clean of 'dbfs_mount' on 'hostname01' succeeded
CRS-2673: Attempting to stop 'ora.prddbfs.dbfs.svc' on 'hostname01'
CRS-2677: Stop of 'ora.prddbfs.dbfs.svc' on 'hostname01' succeeded
CRS-2527: Unable to start 'dbfs_mount' because it has a 'hard' dependency on 'ora.prddbfs.db'
CRS-2525: All instances of the resource 'ora.prddbfs.db' are already running; relocate is not allowed because the force option was not specified
CRS-4000: Command Start failed, or completed with errors.

Review of /var/log/messages shows following messages indicating that the ORACLE_SID is set to null value

Apr  3 17:14:11 hostname01 DBFS_/dbfs_direct: mount-dbfs.sh mounting DBFS at /dbfs_direct from database PRDDBFS
Apr  3 17:14:12 hostname01 DBFS_/dbfs_direct: ORACLE_SID is                                <<<< not set to any value
Apr  3 17:14:12 hostname01 DBFS_/dbfs_direct: No running ORACLE_SID available on this host, exiting

The instance however is running and can be accessed via sqlplus

ps -ef|grep pmon
oracle    49499      1  0 15:57 ?        00:00:00 ora_pmon_PRDDBFS_1
oracle    62662      1  0 10:33 ?        00:00:03 asm_pmon_+ASM2
oracle    63520      1  0 10:34 ?        00:00:04 ora_pmon_TSTORD6_1

srvctl status database -d prddbfs
Instance PRDDBFS_1 is running on node edw1dbadm02

Changes

 The process works on non RAC One Node setups.

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