 |
|
ORA-27054 Tips
Oracle Tips by Burleson Consulting |
Question:
I'm getting the following error when I attempt to issue the
mount command on an NFS filesystem:
ORA-27054: NFS file system where the file is created or resides
is not mounted with correct options
What is the ORA-27054 error about?
Answer:
The
oerr utility shows this for the ORA-27054:
ORA-27054: NFS file system where
the file is created or resides is not mounted with correct
options
Cause: The file was on an NFS partition and either reading the
mount tab file failed or the partition was not mounted with the
correct mount option.
Action: Make sure mount tab file has read access for Oracle user
and the NFS partition where the file resides is mounted
correctly. For the list of mount options to use refer to your
platform specific documentation.
The ORA-27054 error is different between the older Oracle export
utility (exp and the data pump export (expdp).
When using exp, you must create the file, whereas in data pump
expdp Oracle will create the file on your behalf.
Start by checking your
NFS file mount
options for Oracle, and verify permissions, hard, rsize, wsize, and noac
parms in your NFS mount command:
mount -o rw,timeo=600,hard,wsize=32768,vers=3,rsize=32768,tcp
mount -o hard,rw,noac,rsize=32768,wsize=32768,suid,proto=tcp,vers=3
For more details, see Jon Emmons
book "Oracle
Shell Scripting" for Linux & UNIX.
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
|
