My Oracle Support Banner

Unable To Use Dnfs Mutipath On An 18.10 SE Database (Doc ID 2713514.1)

Last updated on OCTOBER 16, 2020

Applies to:

Oracle Database - Standard Edition - Version 18.9.0.0.0 and later
Information in this document applies to any platform.

Symptoms

 

Its a 18.10 Standard Edition database.

Configured two DNFS path. However, database picking only one.

No error reported in alert/system log file for this. Customer also configured

DNFS multipathing in many environment  with Enterprise Edition database and not facing any issue. Only facing issue in Standard Edition database.

DIAGNOSTIC ANALYSIS:
--------------------
alert_<SID>.log
==================

  sql92_security           = TRUE
  pga_aggregate_target     = 1G
  sec_protocol_error_further_action= "CONTINUE"
  diagnostic_dest          = "/opt/oracle"
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2020-09-02T16:57:27.343278+01:00
Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 4.0  
NOTE: PatchLevel of this instance 0
Starting background process PMON
2020-09-02T16:57:27.390574+01:00
PMON started with pid=2, OS id=19945
==============================

SQL> select * from v$dnfs_servers;

ID SVRNAME DIRNAME MNTPORT NFSPORT NFSVERSION WTMAX RTMAX CON_ID
RDMAENABLE RDMAPORT SECURITY
1 <NFS_SERVER> <filesystem> 635 2049 NFSv3.0 65536 65536 0 No 0 sys
1 <NFS_SERVER> <filesystem> 635 2049 NFSv3.0 65536 65536 0 No 0 sys
1 <NFS_SERVER> <filesystem> 635 2049 NFSv3.0 65536 65536 0 No 0 sys


cat $ORACLE_HOME/dbs/oranfstab
===========

>>>>>>>>>>>>>>>>>>>>>>>>>>>>Here server parameter missing
local: 172.24.xxx.xxx
path:  172.24.xxx.xx
local: 172.24.xxx.xxx
path:  172.24.xxx.xx
Mnt_timeout: 30

export : /test_redo1             mount : /u01
export : /test_redo2             mount : /u02
export : /test_data             mount : /u03
export : /test_temp             mount : /u04
export : /test_fra               mount : /u05

 

Changes

 No changes

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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