Posted by Sidhu on 10th June 2008
Today I was checking OTN forums and came across a thread. OP’s concern was:
One of the db i am supporting has about 3.3 Terabytes capacity and the application is using only 1 huge tablespace with one big file.
the system is linux 4 , 32 bit.
oracle version is 10.2.0.4
Is there a limit of space for a tablespace when you consider insert/delete/query performance?
Single datafile of 3.3 TB 
Awesome !
Kudos to the designer 
Posted in Oracle General | No Comments »
Posted by Sidhu on 27th March 2008
Today I was upgrading 10gR1 to 10gR2 (10.2.0.1) on Linux x86. The upgrade went almost fine (except that I had to install one package and change few kernel parameters) but while running DBUA to upgrade databases, it gave an error:
Could not get database version from the Oracle Server component. The CEP file rdbmsup.sql does not provide the version directive
and
Start of root element expected. Upgrade Configuration file
'C:\Oracle10g2\cfgtoollogs\dbua\test\upgrade5\upgrade.xml' is not a valid XML file.
I searched in the metalink and found that this all happens due to customized glogin.sql file which was there in my case also. And removing that customization made DBUA rock
You might want to check here, here and here.
Posted in Troubleshooting | No Comments »