An Oracle blog – Amardeep Sidhu

June 27, 2013

Oracle database 12c

Filed under: Database — Sidhu @ 7:28 am
Tags: ,

So there is a new toy in the market for database geeks : Oracle has released database 12c. Every social platform is abuzz with the 12c activity. So thought that I should also complete the ritual Winking smile

In this post Aman has already summed up many important links.

Maria Colgan has posted some useful links here.

And here is a link to a slidedeck about Upgrading and Migrating to 12c.

Happy 12c’ing !

June 10, 2008

A database – one tablespace & one datafile

Filed under: Oracle General — Sidhu @ 9:32 pm

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

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 πŸ˜‰

March 27, 2008

Upgrade 10gR1 to 10gR2 – DBUA error

Filed under: Troubleshooting — Sidhu @ 10:53 pm
Tags: , , ,

Today I was upgrading 10gR1 to 10gR2 ( 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


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.

Theme: Rubric. Get a free blog at

%d bloggers like this: