Unable To Edit Files Under DBFS Filesystem (Doc ID 2030456.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Linux x86-64

Symptoms

Unable to edit few scripts/files located under user created dbfs filesystem mount point /dbfs_nondirect, when we tries to edit those files with vi editor end up with error as below.

E325: ATTENTION
Found a swap file by the name ".create_all_others_mviews.sql.swp"
owned by: oracle dated: Mon Jun 29 18:23:00 2015
[cannot be read]
While opening file "create_all_others_mviews.sql"
dated: Tue Jun 30 01:21:36 2015
NEWER than swap file!

(1) Another program may be editing the same file.
If this is the case, be careful not to end up with two
different instances of the same file when making changes.
Quit, or continue with caution.

(2) An edit session for this file crashed.
If this is the case, use ":recover" or "vim -r create_all_others_mviews.sql"
to recover the changes (see ":help recovery").
If you did this already, delete the swap file ".create_all_others_mviews.sql.swp"
to avoid this message.

And in /var/core/message, below errors reported.

Jun 30 02:39:31 nj12mhf0103db01 dbfs_client[61742]: ASSERT failure::
Jun 30 02:39:31 nj12mhf0103db01 dbfs_client[61742]: Assert in FSO
Jun 30 02:39:31 nj12mhf0103db01 dbfs_client[61742]: #012
Jun 30 02:39:31 nj12mhf0103db01 dbfs_client[61742]: Async thread exception /dbfs_scripts/mhf0103/budev/mviews/core/.create_all_others_mviews_dev.sql.swp 1001
Jun 30 02:39:31 nj12mhf0103db01 dbfs_client[61742]: ASSERT failure::
Jun 30 02:39:31 nj12mhf0103db01 dbfs_client[61742]: Assert in FSO
Jun 30 02:39:31 nj12mhf0103db01 dbfs_client[61742]: #012


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