topic Oracle DB 11gR2 (11.2.0.1.0) Installation Failed with ORA-27054 in Operating System - HP-UX

Oracle DB 11gR2 (11.2.0.1.0) Installation Failed with ORA-27054

X0NET0 — Sat, 20 Nov 2010 04:46:18 GMT

O/S: HP-UX 11.31
Machine: HP rx8640 Itanium
Installation: Oracle DB 11gR2 (11.2.0.1.0)
/etc/fstab:
10.100.250.249:/vol/Billap_d01 /d01 nfs rw,hard 0 0 #For Oracle 11gR2 Billing DB Home
10.100.250.249:/vol/Billap_d02 /d02 nfs rw,hard 0 0 #For Oracle 11gR2 Billing Oradata

Error: ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Installation Stage: At Oracle Database Configuration Assistant (Almost Completed)

Tried the following mount option for just /d02 but get "mount: ignoring incomplete/incorrect entry for 10.100.250.249:/vol/Billap_d02 in /etc/fstab".
10.100.250.249:/vol/Billap_d02 /d02 nfs hard,rw,noac,rsize=32768,wsize=32768,suid,proto=tcp,vers=3
10.100.250.249:/vol/Billap_d02 /d02 nfs rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,proto=tcp,suid, forcedirectio
10.100.250.249:/vol/Billap_d02 /d02 nfs rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,proto=tcp,suid

I have other Oracle 10gR2 databases and even Peoplesoft apps using simple "nfs rw,hard 0 0" mount option work fine without any issue.
I am not sure why this is not working in 11gR2 DB installation.

Can someone advise me what, why, how... ?

Thanks in advance.

Re: Oracle DB 11gR2 (11.2.0.1.0) Installation Failed with ORA-27054

SoorajCleris — Sat, 20 Nov 2010 04:59:15 GMT

Hi,

try to mount manually and check if its working

==> did you give the correct optiond for the host while exporting the dir.

==> check if you have used FQDN for permission.

regards,
Sooraj

Re: Oracle DB 11gR2 (11.2.0.1.0) Installation Failed with ORA-27054

X0NET0 — Sat, 20 Nov 2010 05:24:12 GMT

Hi Sooraj,
I have tried manual mount but still the same.
The below original mount are fine but just that my Oracle DB 11gR2 installation failed:
10.100.250.249:/vol/Billap_d01 /d01 nfs rw,hard 0 0
10.100.250.249:/vol/Billap_d02 /d02 nfs rw,hard 0 0

Re: Oracle DB 11gR2 (11.2.0.1.0) Installation Failed with ORA-27054

Shibin_2 — Mon, 22 Nov 2010 13:09:20 GMT

Hi Seng,

What is your NFS server version? Is it same version 3?

Can you try to mount it manually?

mount -F nfs -o rw,hard,vers=3,noac,rsize=????

Re: Oracle DB 11gR2 (11.2.0.1.0) Installation Failed with ORA-27054

X0NET0 — Tue, 23 Nov 2010 08:29:40 GMT

Hi Shibin,

I am using the following:
Netapp FAS3020
Data ONTAP ver 7.2.6.1P2
NFS version 3

I can mount /d01 and /d02 using either manual or /etc/fstab file.
10.100.250.249:/vol/Billap_d01 /d01 nfs rw,hard 0 0
10.100.250.249:/vol/Billap_d02 /d02 nfs hard,rw,noac,rsize=32768,wsize=32768,suid,proto=tcp,vers=3 0 2

The problem is that the installation still getting the following errors at DBCA stage:
ORA-19624: Operation failed, retry possible
ORA-19870: Error while restoring backup piece /d01/oracle/BILL/product/11.2.0/dbhome_1/assistants/dbca/templates/Seed_Database.dfb
ORA-19504: Failed to create file "/d02/BILLDB106/bill/system01.dbf"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Re: Oracle DB 11gR2 (11.2.0.1.0) Installation Failed with ORA-27054

Shibin_2 — Tue, 23 Nov 2010 14:07:56 GMT

I found this option from one of the article.

rw, bg, rsize = 32768, wsize = 32768, hard, vers = 3, nointr, timeo = 600, proto = tcp, suid 0 0,

Can you try to mount with all these options. You must first unmount it and make sure, it is not at all mounted. Then retry.

Is it possible to attach "installAction*.log" ?

Re: Oracle DB 11gR2 (11.2.0.1.0) Installation Failed with ORA-27054

Alex Glennie — Tue, 23 Nov 2010 14:47:25 GMT

see http://forums.oracle.com/forums/thread.jspa?threadID=325008&start=30&tstart=0

eg: Add this to the init.ora

#disallow MOUNT POINT checks

event="10298 trace name context forever, level 32"

.

This will disable the NFS mount checks allowing you to use

any mounts options but then the onus is on yourself to ensure

that the mount options used for each disk are correct

for the use that they are to be put to.

fyi I work in a hpux netapps oracle env and seen this myself .... the above worked.

Re: Oracle DB 11gR2 (11.2.0.1.0) Installation Failed with ORA-27054

X0NET0 — Wed, 24 Nov 2010 01:53:44 GMT

Hi Shibin,
I have tested with the option you suggested after remounted /d02 but the installation still encounter the same error.
10.100.250.249:/vol/Billap_d02 /d02 nfs rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,proto=tcp,suid 0 0

Hi Alex,
At this point of time, I will not be testing your recommended option because I have just submitted the tusc file to Oracle Support.

Regards,
Saw

Re: Oracle DB 11gR2 (11.2.0.1.0) Installation Failed with ORA-27054

Shibin_2 — Wed, 24 Nov 2010 17:59:33 GMT

Have you checked "installAction*.log" ? Any clues in that ?