Oracle Database 11g Database File System (DBFS). Common DBFS Problems and Solutions. Part I.

In my recent post entitled Oracle Database 11g Database File System (DBFS) Is Not A Popular Topic. Yet., I discussed how I use Google search terms as a way of monitoring what sorts of problems people are running into with new technology such as (DBFS).

This is part one in a series of posts where I’ll offer some tips regarding the more common DBFS-related problems one might encounter in early testing. The first I’ll tackle is “Transport endpoint is not connected.”

Error Text: Transport Endpoint is not connected.
This error string occurs when attempting to access a mounted DBFS file system. The error condition arises when there is no dbfs_client currently executing that is associated with the file system.

In the following boxes I’ll show two examples of how this error can be encountered. First, I’ll show that I have a DBFS file system mounted and that an attempt to change directories to the mount point results in “Transport endpoint is not connected”, such as:

$ mount | grep dbfs
dbfs on /data type fuse (rw,nosuid,nodev,max_read=1048576,default_permissions,allow_other,user=oracle)
$ cd /data
-bash: cd: /data: Transport endpoint is not connected

A simple ps command shows there is no dbfs_client process executing:

$ ps -ef | grep dbfs_client
oracle    1694 21941  0 09:49 pts/11   00:00:00 grep dbfs_client

This error condition is quite simple to rectify. You simply need to restart the dbfs_client process:

$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib
$ export ORACLE_SID=DBFS1
$ 
$ ORACLE_HOME/bin/dbfs_client dbfs@ -o allow_root,direct_io /data < /opt/oracle/dbfs/passwd.txt &
[1] 2501
$ fuse: bad mount point `/data': Transport endpoint is not connected

Sorry, I had to be sneaky in order to show one of the other conditions that raises the error. So, yes, to rectify this error condition you do have to restart dbfs_client, however, you need to first unmount the dead mount. You’ll see in the following box that I use fusermount –u to unmount and then execute dbfs_client and without any further action I can list the contents of the file system.

$ fusermount -u /data
$ $ORACLE_HOME/bin/dbfs_client dbfs@ -o allow_root,direct_io /data < /opt/oracle/dbfs/passwd.txt &
[1] 2931
$ Password:

$ ls -l /data/FS1/TEST
total 0
-rw-r--r-- 1 oracle oinstall 0 Dec 30 13:39 511b
-rw-r--r-- 1 root root 0 Dec 30 13:40 test.out

Dead Mount, Living DBFS Instance.
If you look in the boxes above you’ll notice that dbfs_client was not executing (the real root of the problem) but the instance was running. Since dbfs_client is an OCI program all I had to do was kill it to create this scenario. If, however, you suffer this error while dbfs_client is executing then I recommend involving support because that would be a bug.

3 Responses to “Oracle Database 11g Database File System (DBFS). Common DBFS Problems and Solutions. Part I.”


  1. 1 pete September 27, 2010 at 8:34 pm

    Noted on an exadata one dbfs is down on one node but the other is up. Neither show the dbfs_client as running.

    the good node:
    [oracle@ex01db01 ~]$ ps -ef | grep dbfs
    oracle 3916 25145 0 15:31 pts/6 00:00:00 grep dbfs
    oracle 24870 1 0 Sep16 ? 00:01:41 /sbin/mount.dbfs /@xiwprdfs.local /dbfsmnt -o rw,noexec,nosuid,nodev,direct_io,allow_other,wallet
    [oracle@ex01db01 ~]$
    [oracle@ex01db01 ~]$ df -k /dbfsmnt
    Filesystem 1K-blocks Used Available Use% Mounted on
    dbfs 104932992 102824424 2108568 98% /dbfsmnt
    [oracle@ex01db01 ~]$

    the bad node:
    [oracle@ex01db05 ~]$ ps -ef | grep dbfs
    oracle 15892 1 0 15:04 ? 00:00:00 /sbin/mount.dbfs /@xiwprdfs.local /dbfsmnt -o rw,noexec,nosuid,nodev,direct_io,allow_other,wallet
    oracle 27925 8715 0 15:33 pts/1 00:00:00 grep dbfs
    [oracle@ex01db05 ~]$
    [oracle@ex01db05 ~]$ df -k /dbfsmnt
    df: `/dbfsmnt': Input/output error
    [oracle@ex01db05 ~]$


  1. 1 Blogroll Report 22/01/2009 – 29/01/2010 « Coskan’s Approach to Oracle Trackback on February 21, 2010 at 3:25 am

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




EMC Employee Disclaimer

The opinions and interests expressed on EMC employee blogs are the employees' own and do not necessarily represent EMC's positions, strategies or views. EMC makes no representation or warranties about employee blogs or the accuracy or reliability of such blogs. When you access employee blogs, even though they may contain the EMC logo and content regarding EMC products and services, employee blogs are independent of EMC and EMC does not control their content or operation. In addition, a link to a blog does not mean that EMC endorses that blog or has responsibility for its content or use.

This disclaimer was put into place on March 23, 2011.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,027 other followers

Oracle ACE Program Status

Click It

website metrics

Fond Memories

Copyright

All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2013. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Kevin Closson and Kevin Closson's Blog: Platforms, Databases, and Storage with appropriate and specific direction to the original content.

Follow

Get every new post delivered to your Inbox.

Join 2,027 other followers

%d bloggers like this: