Issues with Oracle Direct NFS
source link: https://sve.to/2016/01/28/issues-with-oracle-direct-nfs/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
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.
Subscribe to Svetoslav Gyurov technical blog
Get the latest posts delivered right to your inbox
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK