• About Me

    Maxwell Miranda
    Oracle DBA Consultant.
  • Category

  • Archives

  • My Blog Calendar

    January 2010
    M T W T F S S
    « Nov   Feb »
     123
    45678910
    11121314151617
    18192021222324
    25262728293031
  • RSS Oracle Feeds

    • Rman not deleting obsolete backups
      Hi all I am trying tgo maintain my RMAN Catalog. My RMAN retention policy is set to recovery window of 28 days. RMAN> report obsolete; Report of obsolete backups and copies ( Shows a bunch of obsolete backups and copies dated from 18-JAN-15 to 22-JAN-15) I run the following command to delete the obsolete backups reported by RMAN. RMAN> delete obsolete; […]
    • Hate to be that guy but..
      Hi everyone, my name is Jack and I am new to the forums here. I have gone through and read through the "how to ask a question" thread a bit, and still find myself a bit confused on a few things: *Background:* After searching through this site as well as other DBA forums, I am still a bit unclear as to the specific approach to take with my education […]
    • Partitions?? I haven't a clue what there asking for? where would I look?
      The following tables have partitions without any rows (NUM_ROWS). Partitions with blocks assigned are wasting space unless they will be reused. The Attached report details partition ids and whether partitions were found to contain rows (ROW_COUNT), the timing of stats collection can cause a difference. . Can you review : . - Whether partitions are being left […]
    • How to skip constraints validation for a transaction permanently
      Below is the techinical issue that I am trying to see if there is a way out: (I simplified the issue as much as I could to give you overall idea. ) Platform: Oracle Version: 11.2.0.4 OS: CentOS 6.4 There are two schemas named SCH01 and SCH02 on databases DB01 and DB02 respectively. The schemas are totally identical and their definition match. The data in the […]
    • Data getting deleted from Table Unexpectedly every Wednesday Morning
      Team, I have a peculiar situation where Data from a Oracle Table is getting deleted unexpectedly every wednesday morning. Now, we checked if there is any deleted script scheduled to run on that 'table' but found that there were none. Can you please provide some pointers for us to explore more? Regards, Vikram
    • ksh: ./install.sh: not found
      Hi, Im trying to install application in a database. But install.sh was unable to run. *oracle@xx09:/rpm/application # ./install.sh ksh: ./install.sh: not found.* *oracle@xx09:/rpm/application # ls -lrt total 240 -rw-r--r-- 1 oracle dba 23388 Dec 30 2011 antinstall-config.xml -rw-r--r-- 1 oracle dba 2314 Dec 30 2011 ant.install.properties.sample -rwxrwxr-x 1 […]
    • 12c EM Cloud Control Installation Fail
      I am trying install 12c Enterprise Manager Cloud Control on a lenovo IdeaPad Laptop. Windows 8. (Intel® Core i5-3210M CPU (2.5 GHz) X 2, 6 GB RAM, can't find swapfile size, but it passed the pre-req.s check, 454 GB free disk space) I created a repository database for oem purposes.. What happens in the Installer , is that I get past all prerequisites , a […]
    • when users are trying to access any task from Fusion application home page, they are
      We have installed HCM and CRM modules on Fusion Application 11.1.7 version. This is 2 node architecture ie IDM components installed in one node and Fusion components installed in another node. We are able to start the IDM components and Fusion components successfully, but when users are trying to access any task from Fusion application home page, they are ge […]
    • IEPostStringrequest
      Hi While saving an image in an application which is captured using a webcam we get an error message IEPostStringrequest.image upload failed while saving the image to an oracle database. Has anyone seen this issue before? any suggestions to troubleshoot?
    • Pls-00302 error :(
      I know there are lot of resources online that talk about this error, but not even a single one helped me fix my error :(... Below is my story. I created a object StudentUpdate_t, a table with the objects StudentUpdate_Type and trying to load the values from the table into a cursor and return a cursor as an output parameter in procedure create or replace type […]

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

NFS Mount Options

You must mount NFS volumes used for storing database files with special mount options on the host where the database server is running. When mounting an NFS file system, Oracle recommends that you use the same mount point options that your NAS vendor used when certifying the device. Refer to your device documentation or contact your vendor for information about recommended mount-point options.

In general, most vendors recommend that you use the NFS mount options listed in the following table.

Option Requirement Description
hard Mandatory Generate a hard mount of the NFS file system. If the connection to the server fails or is temporarily lost, connection attempts are made until the NAS device responds.
bg Optional Try to connect in the background if connection fails.
tcp Optional Use the TCP protocol rather than UDP. TCP is more reliable than UDP.
nfsvers=3 Optional Use NFS version 3. Oracle recommends that you use NFS version 3 where available, unless the performance of version 2 is higher.
suid Optional Allow clients to run executables with SUID enabled. This option is required for Oracle software mount points.
rsize Mandatory The number of bytes used when reading from the NAS device. This value should be set to the maximum database block size supported by this platform. A value of 8192 is often recommended for NFS version 2 and 32768 is often recommended for NFS version 3.
wsize Mandatory The number of bytes used when writing to the NAS device. This value should be set to the maximum database block size supported by this platform. A value of 8192 is often recommended for NFS version 2 and 32768 is often recommended for NFS version 3.
nointr (or intr) Optional Do not allow (or allow) keyboard interrupts to kill a process that is hung while waiting for a response on a hard-mounted file system.

Note: Different vendors have different recommendations about this option. Contact your vendor for advice.

actime=0 or noac Mandatory Disable attribute caching.

Note: You must specify this option for NFS file systems where you want to install the software. If you do not use this option, Oracle Universal Installer will not install the software in the directory that you specify.

The mandatory mount options comprise the minimum set of mount options that you must use while mounting the NFS volumes. These mount options are essential to protect the integrity of the data and to prevent any database corruption. Failure to use these mount options may result in the generation of file access errors. Refer to your operating system or NAS device documentation for more information about the specific options supported on your platform.

For AIX:
cio,rw,bg,hard,nointr,rsize=32768,wsize=32768,proto=tcp,noac,vers=3,timeo=600

For HP-UX:
forcedirectio,rw,bg,hard,nointr,rsize=32768,wsize=32768,proto=tcp,noac,vers=3,timeo=600,suid

About these ads

One Response

  1. Good article. I thank you posting that. I ask you accept my apology for my weak English writing, I am from France and English is sort of new to me.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: