Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
ORA 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA 01722 invalid number
 
AW: [suse-oracle] Oracle-datafiles on NFS-Volume

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

2007-06-01       - By Oliver Gehlert

 Back
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`0,rsize2768,wsize2768



RHAS2.1:



 rw,bg,hard,nointr,tcp,vers=3,timeo`0,rsize2768,wsize2768



 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`0,rsize2768,wsize2768,actimeo=0



RHAS2.1, RHEL3 pre QU3:



 rw,bg,hard,nointr,tcp,vers=3,timeo`0,rsize2768,wsize2768,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)" <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