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" <funklover4u@(protected)>
To: <wolfgang.wagner@(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: "wolfgang.wagner@(protected)>
An: suse-oracle@(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: wolfgang.wagner@(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: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(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: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
