Re: Creating DB on partition > 2TB

From: Greg Rahn <greg_at_structureddata.org>
Date: Thu, 6 Mar 2008 15:08:39 -0800
Message-ID: <a9c093440803061508v53edf5e3yc7e2de00368d6253@mail.gmail.com>


Sounds like a DBCA bug from a really large number. Oracle db doesn't have any knowledge of the LUN size, only database file size.

I don't know that I would recommend just a single large LUN. I believe that things like the SCSI IO queue are per LUN so with only a single LUN you only get one queue. This probably will limit the number of in-flight IOs.

On 3/6/08, William Wagman <wjwagman_at_ucdavis.edu> wrote:
> Greetings,
>
> I have installed Oracle 10.2.0.3.0 on a server running Centos 4,
> 2.6.9-67.0.4.Elsmp. This is a new server and installation. I am using
> the DBCA to create the database which initially will only be 2GB. The
> partition on which I am attempting to create the database has nearly 3TB
> of space and when I attempt to create the database dialogue box is
> presented with the message...
>
> You do not have enough free space
> You need 1845248KB
> You have -1570091008KB
>
> Oracle is telling me that the DBCA is unable to properly compute space
> on a partition > 2TB and suggests either creating the database manually,
> the scripts were created, or dividing the disk into partitions < 2TB. I
> haven't yet tried to create the database manually as I am concerned
> about whether or not if the DBCA gets confused with such a large
> partition that Oracle will also get confused.
>
> So, I'm looking for suggestions or experiences with similar situations.

-- 
Regards,

Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 06 2008 - 17:08:39 CST

Original text of this message