random technical thoughts from the Nominet technical team

DBCA and large filesystems

1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 1.67 out of 5)
Loading ... Loading ...
Posted by jason on Nov 9th, 2007

I never used to like dbca for creating a database, I much prefered the more hardcore (and more configurable) method of creating a script to create the database, and indeed all the production databases created here at nominet have been scripted rather than gui’d into existence. However I have found myself using dbca more and more, particularly since we upgraded to Oracle 10.2 a while back, dbca is much more useable, I used to find this java painfully slow, but 10.2 performs much faster. The reason I’ve been using it more is that our developers want empty databases that they then run the auto schema building tools on to give them the schemas to develop against but without data. I find dbca very useful for creating this type of database.
However it seems like dbca (10.2.0.3) has a limit on the size of filesystem that it can understand and throws an error when attempting to install onto a filesystem that is larger than it understands:

dbca file overflow

There was actually around 16TB of free space available rather than the -1 the gui is suggesting. Thankfully clicking ignore allowed the installation to proceed successfully.

5 Responses

  1. Chris Says:

    This article is so good I want to give it -1 stars!

  2. Hey Says:

    haha :)

    16TB - nice !

  3. jason arneil Says:

    It gets better, and better, you can now get the X4500 with 48TB. http://www.sun.com/servers/x64/x4500/specs.xml.

    If ZFS can get it’s I/O a bit more optimized for a DB workload, I think this is a Datawarehouse in a box.

  4. Suresh Says:

    This is most likely bug 7039202, which is yet to be fixed. If you hit the “Ignore” button dbca would allow the database to be created without any issue.

    Regards,
    Suresh

  5. jason arneil Says:

    Hi Suresh,

    Yep, you are absolutely correct - I did say hit ignore and the installation proceeds in the article!

    Hopefully not too many people would be put off by seeing this pop up during their install.

    jason.

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.

Recent Posts

Highest Rated

Categories

Archives

Meta: