My Oracle Support Banner

RAC ONE Db For DBFS Repository (Doc ID 1543410.1)

Last updated on APRIL 09, 2020

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]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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.mydbfs.db' on '<host01>'
CRS-2676: Start of 'ora.mydbfs.db' on '<host01>' succeeded
CRS-2672: Attempting to start 'ora.mydbfs.dbfs.svc' on '<host01>'
CRS-2672: Attempting to start 'dbfs_mount' on '<host01>'
CRS-2676: Start of 'ora.mydbfs.dbfs.svc' on '<host01>' succeeded
CRS-2674: Start of 'dbfs_mount' on '<host01>' failed
CRS-2679: Attempting to clean 'dbfs_mount' on '<host01>'
CRS-2681: Clean of 'dbfs_mount' on '<host01>' succeeded
CRS-2673: Attempting to stop 'ora.mydbfs.dbfs.svc' on '<host01>'
CRS-2677: Stop of 'ora.mydbfs.dbfs.svc' on '<host01>' succeeded
CRS-2527: Unable to start 'dbfs_mount' because it has a 'hard' dependency on 'ora.mydbfs.db'
CRS-2525: All instances of the resource 'ora.mydbfs.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 <host01> DBFS_/dbfs_direct: mount-dbfs.sh mounting DBFS at /dbfs_direct from database myDBFS
Apr  3 17:14:12 <host01> DBFS_/dbfs_direct: ORACLE_SID is                                <<<< not set to any value
Apr  3 17:14:12 <host01> 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_myDBFS_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 mydbfs
Instance myDBFS_1 is running on node <host01>

Changes

 The process works on non RAC One Node setups.

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!


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