DBCA and large filesystems
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:
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.




November 9th, 2007 at 12:30 pm
This article is so good I want to give it -1 stars!
November 26th, 2007 at 9:19 pm
haha :)
16TB - nice !
November 27th, 2007 at 8:27 am
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.
June 26th, 2008 at 11:51 am
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
June 26th, 2008 at 1:38 pm
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.