ORA-27054 error when creating databases - Revision history

Hutch at 17:51, 31 December 2007

2007-12-31T17:51:17Z

←Older revision		Revision as of 17:51, 31 December 2007
Line 32:		Line 32:
	However, Oracle apparently looks at the output of the '''mount''' command (i.e., the contents of '''/etc/mtab'''). Unless the '''rsize''', '''wsize''', and '''hard''' mount options are specified when mounting the file system, they are not returned by the '''mount''' command. This causes the above Oracle errors, even though these mount options are actually in effect (i.e., '''nfsstat -m''').		However, Oracle apparently looks at the output of the '''mount''' command (i.e., the contents of '''/etc/mtab'''). Unless the '''rsize''', '''wsize''', and '''hard''' mount options are specified when mounting the file system, they are not returned by the '''mount''' command. This causes the above Oracle errors, even though these mount options are actually in effect (i.e., '''nfsstat -m''').

-	As a workaround, specify these mount options in the '''/etc/fstab''' ~~NFS mount. e.g.,~~	+	As a workaround, specify these mount options when mounting the file system. e.g., '''/etc/fstab''' entry:
	192.168.1.100:/vol/oradata1 /oradata1 nfs '''rsize=32768,wsize=32768,hard,noac''' 0 0		192.168.1.100:/vol/oradata1 /oradata1 nfs '''rsize=32768,wsize=32768,hard,noac''' 0 0

Hutch at 17:49, 31 December 2007

2007-12-31T17:49:56Z

←Older revision		Revision as of 17:49, 31 December 2007
Line 30:		Line 30:
	According to this document[http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15660/app_nas.htm#CHDIAGAD], attribute caching must be disabled on the NFS mount using '''noac''' or '''actime=0'''.		According to this document[http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15660/app_nas.htm#CHDIAGAD], attribute caching must be disabled on the NFS mount using '''noac''' or '''actime=0'''.

-	However, Oracle apparently looks at the output of the '''mount''' command (i.e., the contents of '''/etc/mtab'''). Unless the '''rsize''', '''wsize''', and '''hard''' mount options are specified in '''~~/etc/fstab~~''', ~~they~~ are ~~not listed~~ in '''~~/etc/mtab~~'''.	+	However, Oracle apparently looks at the output of the '''mount''' command (i.e., the contents of '''/etc/mtab'''). Unless the '''rsize''', '''wsize''', and '''hard''' mount options are specified when mounting the file system, they are not returned by the '''mount''' command. This causes the above Oracle errors, even though these mount options are actually in effect (i.e., '''nfsstat -m''').

	As a workaround, specify these mount options in the '''/etc/fstab''' NFS mount. e.g.,		As a workaround, specify these mount options in the '''/etc/fstab''' NFS mount. e.g.,
	192.168.1.100:/vol/oradata1 /oradata1 nfs '''rsize=32768,wsize=32768,hard,noac''' 0 0		192.168.1.100:/vol/oradata1 /oradata1 nfs '''rsize=32768,wsize=32768,hard,noac''' 0 0
-
-
-
-
-	149.122.39.60:/vol/anaemmmdo801_backuparea_oradata5_aecd01/oradata5_aecd01 /oradata5/AECD01 nfs rw,noac,addr=149.122.39.60 0 0

Hutch at 17:48, 31 December 2007

2007-12-31T17:48:21Z

←Older revision		Revision as of 17:48, 31 December 2007
Line 6:		Line 6:
	ORA-27054: NFS file system where the file is created or resides is not mounted with correct options		ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
	WARNING:NFS file system ... mounted with incorrect options		WARNING:NFS file system ... mounted with incorrect options
-
	WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard		WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard

Hutch at 17:48, 31 December 2007

2007-12-31T17:48:08Z

←Older revision		Revision as of 17:48, 31 December 2007
Line 5:		Line 5:
	One of our DBAs was creating databases on a NAS device and received the following error:		One of our DBAs was creating databases on a NAS device and received the following error:
	ORA-27054: NFS file system where the file is created or resides is not mounted with correct options		ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
		+	WARNING:NFS file system ... mounted with incorrect options

-	The NAS share was mounted using the NFS defaults:	+	WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard
		+
		+	The NAS share was mounted using the NFS defaults. From '''nfsstat -m''':
	Flags: rw,vers=3,rsize=32768,wsize=32768,hard,proto=tcp,timeo=600,retrans=2,sec=sys,addr=192.168.1.100		Flags: rw,vers=3,rsize=32768,wsize=32768,hard,proto=tcp,timeo=600,retrans=2,sec=sys,addr=192.168.1.100

Line 26:		Line 29:
	from a server. The default is 60 seconds.		from a server. The default is 60 seconds.

-	According to this document[http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15660/app_nas.htm#CHDIAGAD], ~~you must disable~~ attribute caching on the NFS mount using '''noac''' or '''actime=0'''.	+	According to this document[http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15660/app_nas.htm#CHDIAGAD], attribute caching must be disabled on the NFS mount using '''noac''' or '''actime=0'''.
		+
		+	However, Oracle apparently looks at the output of the '''mount''' command (i.e., the contents of '''/etc/mtab'''). Unless the '''rsize''', '''wsize''', and '''hard''' mount options are specified in '''/etc/fstab''', they are not listed in '''/etc/mtab'''.
		+
		+	As a workaround, specify these mount options in the '''/etc/fstab''' NFS mount. e.g.,
		+	192.168.1.100:/vol/oradata1 /oradata1 nfs '''rsize=32768,wsize=32768,hard,noac''' 0 0
		+
		+
		+
		+
		+	149.122.39.60:/vol/anaemmmdo801_backuparea_oradata5_aecd01/oradata5_aecd01 /oradata5/AECD01 nfs rw,noac,addr=149.122.39.60 0 0

Hutch at 16:28, 31 December 2007

2007-12-31T16:28:40Z

←Older revision		Revision as of 16:28, 31 December 2007
Line 7:		Line 7:

	The NAS share was mounted using the NFS defaults:		The NAS share was mounted using the NFS defaults:
-	Flags: rw,vers=3,rsize=32768,wsize=32768,hard,proto=tcp,timeo=600,retrans=2,sec=sys,addr=~~149~~.~~122~~.39.60	+	Flags: rw,vers=3,rsize=32768,wsize=32768,hard,proto=tcp,timeo=600,retrans=2,sec=sys,addr=192.168.1.100
		+
		+	Although not listed with '''nfsstat -m''', attribute caching is enabled by default. From ''nfs''(5):
		+	acregmin=n The minimum time in seconds that attributes of a regular
		+	file should be cached before requesting fresh informa-
		+	tion from a server. The default is 3 seconds.
		+
		+	acregmax=n The maximum time in seconds that attributes of a regular
		+	file can be cached before requesting fresh information
		+	from a server. The default is 60 seconds.
		+
		+	acdirmin=n The minimum time in seconds that attributes of a direc-
		+	tory should be cached before requesting fresh informa-
		+	tion from a server. The default is 30 seconds.
		+
		+	acdirmax=n The maximum time in seconds that attributes of a direc-
		+	tory can be cached before requesting fresh information
		+	from a server. The default is 60 seconds.

	According to this document[http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15660/app_nas.htm#CHDIAGAD], you must disable attribute caching on the NFS mount using '''noac''' or '''actime=0'''.		According to this document[http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15660/app_nas.htm#CHDIAGAD], you must disable attribute caching on the NFS mount using '''noac''' or '''actime=0'''.

Hutch at 16:26, 31 December 2007

2007-12-31T16:26:14Z

←Older revision		Revision as of 16:26, 31 December 2007
Line 1:		Line 1:
-		+	These notes are from the following:
-	* ~~'''~~Oracle 10G R2~~'''~~	+	* Oracle 10G R2
-	* ~~'''~~RHEL 5.1 x86_64~~'''~~	+	* RHEL 5.1 x86_64

	One of our DBAs was creating databases on a NAS device and received the following error:		One of our DBAs was creating databases on a NAS device and received the following error:

Hutch at 16:25, 31 December 2007

2007-12-31T16:25:50Z

←Older revision		Revision as of 16:25, 31 December 2007
Line 1:		Line 1:
-	~~Oracle version:~~ '''Oracle 10G R2'''	+
-	~~OS version:~~ '''RHEL 5.1 x86_64'''	+	* '''Oracle 10G R2'''
		+	* '''RHEL 5.1 x86_64'''

	One of our DBAs was creating databases on a NAS device and received the following error:		One of our DBAs was creating databases on a NAS device and received the following error:

Hutch at 16:24, 31 December 2007

2007-12-31T16:24:19Z

←Older revision		Revision as of 16:24, 31 December 2007
Line 1:		Line 1:
-	'''Oracle 10G R2'''	+	Oracle version: '''Oracle 10G R2'''
-	'''RHEL 5.1 x86_64'''	+	OS version: '''RHEL 5.1 x86_64'''

	One of our DBAs was creating databases on a NAS device and received the following error:		One of our DBAs was creating databases on a NAS device and received the following error:

Hutch: New page: '''Oracle 10G R2''' '''RHEL 5.1 x86_64''' One of our DBAs was creating databases on a NAS device and received the following error: ORA-27054: NFS file system where the file is created o...

2007-12-31T16:23:54Z

New page: '''Oracle 10G R2''' '''RHEL 5.1 x86_64''' One of our DBAs was creating databases on a NAS device and received the following error: ORA-27054: NFS file system where the file is created o...

New page

'''Oracle 10G R2'''
'''RHEL 5.1 x86_64'''

One of our DBAs was creating databases on a NAS device and received the following error:
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

The NAS share was mounted using the NFS defaults:
Flags: rw,vers=3,rsize=32768,wsize=32768,hard,proto=tcp,timeo=600,retrans=2,sec=sys,addr=149.122.39.60

According to this document[http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15660/app_nas.htm#CHDIAGAD], you must disable attribute caching on the NFS mount using '''noac''' or '''actime=0'''.