|
List Info
Thread: AW: Oracle-datafiles on NFS-Volume
|
|
| AW: Oracle-datafiles on NFS-Volume |
|
2007-06-01 08:55:29 |
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=327
68
RHAS2.1:
rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=327
68
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=327
68,actimeo=0
RHAS2.1, RHEL3 pre QU3:
rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=327
68,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 riwa-gis.de"
<wolfgang.wagnerriwa-gis.de>
An: suse-oraclesuse.com
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.wagnerriwa-gis.de
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-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting
___________________________________________________________
Telefonate ohne weitere Kosten vom PC zum PC: http://messenger.yahoo.de
--
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting
|
|
| Re: Oracle-datafiles on NFS-Volume |
|
2007-06-01 13:07:11 |
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" <funklover4uyahoo.de>
To: <wolfgang.wagnerriwa-gis.de>; <suse-oraclesuse.com>
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=327
68
RHAS2.1:
rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=327
68
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=327
68,actimeo=0
RHAS2.1, RHEL3 pre QU3:
rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=327
68,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.wagnerriwa-gis.de"
<wolfgang.wagnerriwa-gis.de>
An: suse-oraclesuse.com
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.wagnerriwa-gis.de
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-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting
___________________________________________________________
Telefonate ohne weitere Kosten vom PC zum PC: http://messenger.yahoo.de
--
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting
--
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting
|
|
[1-2]
|
|