• 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

    • Foreign Keys deferred vs disabled
      Here is my observation regarding deferred foreign keys which I am not able to understand: - We have 3 tables : TP1, TC1 & TC2. TC1 and TC2 have foreign keys pointing to TP1 and foreign keys are defined as DEFERRED. - We load huge amounts of data to these tables once a week and the insert takes unusually long time. This is how we insert: (Case 1) step 1: […]
    • Low EST_PGA_CACHE_HIT_PERCENTAGE
      Hi Friends, While analysing the AWR report of Oracle 11g, In PGA TARGET Advisory i found low est_pga_cache_hit_percentage at size_factor =1. If I increase the PGA_AGGREGATE_TARGET size will it improve the performance of the queries that accessing SORT/MERGE/HASH paths. or Should i found the queries accessing SORT/MERGE/HASH paths and tune them? Which will be […]
    • Oracle Performance
      Hello Please I am actually using a new server on Linux Redhat with 32G (64 bits) . I need some advice to increase performance since my rman takes Now 2 hours instead of 1 hour before when I was on 16G See below pfile details Code: --------- rwddb.__db_cache_size=1577058304 rwddb.__java_pool_size=33554432 rwddb.__large_pool_size=16777216 rwddb.__shared_pool_s […]
    • New to DBA
      Hi all, Hope this is the right place to post this question. I recently joined a program that prepares students to become DBA's. Its a six month program, roughly. It's every weekend sat-sun, 4-7 P.M. I wanted to attach our course schedule and get some feedback from you guys to see if the topics covered in this course would prepare me for an actual j […]
    • Oracle Import / Export help
      Hi, I am learning Oracle export/import options and I wanted to find a way as stated I have a destination database that I want to import a dump file to but exclude some schemas. I exported schemas using expdp user1/pass full=Y dir=tmp dumpfile=node1.expdp.dmp on the target node, I want to import full db excluding sys,system,dbsnmp schemas. is there an option […]
    • Bit confused with Select Query
      I am bit confused regarding below query . select /*+ parallel_index(t,"IDX_CR_TRANSACTION_HIST_17",32) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index_ffs(t,"IDX_CR_TRANSACTION_HIST_17") */ count(*) as nrw,count(distinct sys_op_lbid(52330892,'L',t.rowid)) as nlb,count(distinct […]
    • Email using cron job
      Hi, Because of the daily task to monitor session in oracle database, I would like to set this task in crontab to run everyday and automatical send the output of the query. Do you have sample script for this? Thanks
    • explain plan for partition table
      explain plan for partition table hello, i have a question about explain plan for partition table. i have created two tables, one of them is partitioned and the other one is not. when i execute a query for analyzing the two tables and ask for the explain plans i am not sure what does ROW and BYTE mean? below i wrote two examples from the same query where in t […]
    • How to manage CLOB tables
      Hi..We have a table. Which has 4 columns. 1.ID column,2.CLOB column(which contains file information),3.Create Date,4.Create BY. Inserting data in this row is increasing exponenetially. Currently the size of this table is 400GB. Now to manage this table we have decided to delete some data in every year. But as deleting doesn't free up the space for CLOB […]

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: