Re: Oracle-datafiles on NFS-Volume

Second action is to set up direct_io in the database (in file access option)
when creating database /don't remember exact option name/,

Btw, 'nointr' option is controversial and optional.

And, last but not least, use only NetApp or orther certified NFS server in
production. We made Oracle work on Linux NFS in the lab, but it is show few
strange errors and is not recommended for anything except experiments or low
importantce database.



----- Original Message ----- 
From: "Oliver Gehlert" <[email protected]>
To: <[email protected]>; <[email protected]>
Sent: Friday, June 01, 2007 6:55 AM
Subject: AW: [suse-oracle] Oracle-datafiles on NFS-Volume


Hi Wolfgang,



be sure to set the right mount options for NFS:



Mount Optionen für Datenbankdateien auf NFS





SINGLE INSTANCE:

----------------



SLES9 , RHEL4 , RHEL3:



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



RHAS2.1:



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



  In /etc/modules.conf add:

    options nfs nfs_uncached_io=1    NOTE:  Only set this for AS 2.1



RAC INSTANCES:

--------------



SLES9, RHEL4, RHEL3 QU3 and later:



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



RHAS2.1, RHEL3 pre QU3:



  rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=32768,noac



  And for AS 2.1 in /etc/modules.conf add:

    options nfs nfs_uncached_io=1    NOTE:  Only set this for AS 2.1



Regards



Oliver



----- Ursprüngliche Mail ----

Von: "[email protected]" <[email protected]>

An: [email protected]

Gesendet: Freitag, den 1. Juni 2007, 13:38:48 Uhr

Betreff: [suse-oracle] Oracle-datafiles on  NFS-Volume



Hello,



I want to install an Oracle 9i - instance on a NFS-mounted Volume.



The NFS-volume is on a SLES8-NFS-server, our Oracle is installed on another
SLES8.



SLES8 uses Linux version 2.4.21-278-default,









The NFS-mount works fine, using the NFS-share for files works.

But during creation an Oracle-instance with dbca I got various errors like
ORA-27086 and others.

I also got errors after moving an existing instance to a NFS-share. I cannot
start the

instance because Oracle complains some locking errors.



Searching through Metalink gave me some information about Direct-IO on NFS,
but

I cannot get it working.



Does anyone use such a structure?



|---------|                      |---------------------------------|

| DB-HOST |----NFS via TCP/IP----| NFS-Server with Oracle datafiles|

|---------|                      |---------------------------------|









Thank you





Wolfgang Wagner

--

Systemadministration

Riwa GmbH, Zwingerstrasse 1, 87435 Kempten, +49-831-52 29 63-537

eMail:    [email protected]

RIWA GmbH, Zwingerstrasse 1, 87435 Kempten

Sitz der Gesellschaft: Kempten (Allgaeu)

Registergericht: Amtsgericht Kempten, HRB 6480

Geschaeftsfuehrer: Dipl.-Ing. Guenter Kraus





--

To unsubscribe, email: [email protected]

For additional commands, email: [email protected]

Please see http://www.suse.com/oracle/ before posting


















___________________________________________________________
Telefonate ohne weitere Kosten vom PC zum PC: http://messenger.yahoo.de

-- 
To unsubscribe, email: [email protected]
For additional commands, email: [email protected]
Please see http://www.suse.com/oracle/ before posting



-- 
To unsubscribe, email: [email protected]
For additional commands, email: [email protected]
Please see http://www.suse.com/oracle/ before posting