donderdag 8 december 2011

Deinstalling Oracle, pain in the ass to speak off

About 6 months ago I had a huge project from hell, it involved transfering a 57 Gb Oracle database from Oracle to SQL Server, tables, stored procedures, ect...
It took ages to get the database running in the first place,client in Singapore,client previous IT support company also over there, client previous IT support company not happy about losing the contract.

That IT company send us the backup files to create our own copy of the database, but no further info, no name of the database, no version number, no passwords, not even login names. It took me 3 months of constant emails to find out all that stuff.

For those not familiar with oracle, the backups of any database in Oracle can only be installed on an Oracle of the same version,patchlevel and operating system as where they were made on.

SO after 3 months of wasting time we had that data and we tried to do a database create, funny enough we then saw the files were unusable. An Oracle database has to be offlined in order to make a working backup, here they had simply copy pasted the datafiles.

So we angrily went to them and got new files and got it running and eventually transferred to an SQL server database, but not without some further strange problems.

Well now we come back to the title of the post, I no longer need the Oracle installed on my machine at the office and have been trying to deinstall it for weeks now.  The deinstalller runs OK, but at a moment it seems to just stop and not continue, and if you exit the deinstaller it all gets rollbacked. So the deinstall does not occur.

Geen opmerkingen:

Een reactie posten