Database Migration

[serisha]

Hi,

I want to migrate the Database from NT platform to Sun Solaris. Could anybody help me how to do that.

Oracle on NT is 8.0.5
Oracle on Sun is 8.1.6.

Thanks in advance
sirisha

[TerryD]

In the simplest way (assuming you can have database downtime while the migration is performed, and the new database is the same as the old structure):

Setup new init.ora file on Solaris.

Export Database from NT as System with Full=Y parameter.
ftp file from NT to Unix (BINARY Mode).
Create a database on Solaris - Create the same structure - Tablespaces, Rollback etc.

Import as System (password manager don't forget!) with Full=y (and commit=y

You will get a lot of errors when it can't create certain objects/Tablespaces etc... this is ok.

Finally on the new DB, create any grants etc. done by SYS on the old DB, compile any invalid objects, re-import anything which may have failed (other than objects which already exist)

Make sure your listener is set up, and I think thats about it.

[oradbadmin]

You can also use the parameter ignore = y when importing your dump file to avoid object creation errors.