Issues with Oracle Direct NFS
This is a quick post to highlight two issues I had with Oracle dNFS. Both relate to wrong entries in the oranfstab file.
One might encounter ORA-00600 during database creation:
DBCA_PROGRESS : 7% DBCA_PROGRESS : 8% ORA-01501: CREATE DATABASE failed ORA-00600: internal error code, arguments: [KSSRMP1], , , , , , , , , , ,  ORA-17502: ksfdcre:3 Failed to create file /oracle/ORCL/database/ORCL/controlfile/o1_mf_%u_.ctl
This was caused by having a wrong entry in oranfstab – there was difference between fstab and oranfstab for the same record:
server: zfs01 path: 192.168.10.100 export: /export/OTHERDB/database mount: /oracle/ORCL/database
The second issue was that the database wasn’t using dNFS. Simple query of v$dnfs_servers will return no rows and there were no errors in the alertlog. However looking around the tracefiles one can easily spot the following repetitive error in all trace files:
KGNFS_NFSPROC3_MNT FAIL 13
This was caused by trying to mount a share we don’t have access to or non existing share from the NFS server:
server: zfs01 path: 192.168.10.100 export: /export/NON_EXIST/database mount: /oracle/ORCL/database
The issue was fixed after correcting the typos in the oranfstab file and resting the database.
The bottom line is make sure that fstab and oranfstab match and have correct entries.