Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can you spread a database across multiple servers?

Re: Can you spread a database across multiple servers?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 26 Apr 2001 23:44:38 +0200
Message-ID: <4j5het4qj5l2m5flbkegn8akmn6qfrmso7@4ax.com>

Evidently that is going to be a network drive. So there is only one answer: No you can't, Oracle won't let you. And the same applies as to in the NFS situation: it would be slow and unreliable.

Regards,

Sybrand Bakker, Oracle DBA

On Thu, 26 Apr 2001 13:25:55 -0800, Calvin Crumrine <Calvin_Crumrine_at_dced.state.ak.us> wrote:

>NFS? Our NT books define that as Network Filing System developed by Sun.
>Nothing to do with my question as far as I can see.
>
>Absolutely not interested in recommendations. Only thing I'm looking for is
>an answer to my question-If we're running Oracle on one Win2K server can we
>create a datafile that resides on another Win2K server in the network?
>
>Andrei wrote:
>
>> datafiles sitting on NFS will result in bad performance, plus NFS is
>> not reliable.
>> you can try looking into disk arrays and SAN.
>>
>> On Thu, 26 Apr 2001 12:11:52 -0800, Calvin Crumrine
>> <Calvin_Crumrine_at_dced.state.ak.us> wrote:
>>
>> >If we have 2 Win2K servers, one running Oracle & one for our apps, and
>> >we run out of disk space on our Oracle server, can we create a datafile
>> >on the other server? Hypothetical question at this point-we're still
>> >setting up our first Win2K server but our plans are to eventually have
>> >2. The Oracle server's hard drive bays will be full while the file
>> >server will have several empty bays. Should we plan on buying an
>> >expansion chassis for the Oracle server, or can we use the empty bays in
>> >the other server?
>> >
>> >Thanks.
>> >
>>
>> ---------------
>> In case I forgot to mention:
>> We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
>> ---------------
>> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630
>> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
  Received on Thu Apr 26 2001 - 16:44:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US