We have the following environment:
Server: HP LH4
OS: Win NT 4.0 SP 5
Database Oracle 22.214.171.124.0
Application: Oracle Financials 11.0.3
We would like to MIGRATE the existing database and applications from NT to Sun SPARC Solaris ver.7
Could I get step by step procedure to migrate the existing database and Applications to Sun SPARC Solaris ?
Thanks in Advance
MIGRATION FROM WIN NT TO SOLARIS
1) Pre-create a database, if you are new to Oracle DBA
you can use DBASSIST to create a database on ur solaris 2.7 system
2) Export your database on NT from command prompt
exp apps/apps@prod full=y
3) ftp the .dmp to your solaris server
4) Import the database on solaris from your Solaris Prompt
imp apps/apps@prod full=y ignore=y
I think, by using the above procedure, I can migrate from NT to Solaris.
If not, correct me please.
and how to install Oracle Financial Application 11.0.3 over there ?
Thanks in Advance
The migration of Oracle database from NT to Solaris is fine no problem I cannot comment about oracle finincial application cause I have never worked on it
For the migration of Oracle Applications you'd better at first install Oracle Applications on the Solaris (install only the files : concurrent program, reports and forms (if the solaris erver is the applicaiton server)). Then import all the data, you've exported from the NT server.
Attention : before the export on the NT server don't forget to stop the concurrent managers.
I was invovled with several such projects for migrations .here are some of the DO's
1)The most importatnt first step is to take a Cold backup of your system.i mean the entire software including ur database datafiles and the oracle software.
2)Most important step TEST WHEATHER YOUR COLD BACKUP ACTUALLY WORKS BY RESTORING IT ON A IDENTICAL SYSTEM.I CANT EMPHASIZE THSI POINT MORE.
2)Since your planning to take change of database from oracle to oracle.I suggest you take an export of the full database .Craete a database on solaris using the solaris cd and import it into sun solaris after creating the database there.
3)Now you can go ahead and install the applications and binaries to which are platform specific.
4)Perform some tests on the migrated sun platform ...........
you can check the import log,check wheather all objects have been imported.....and run the application and see.
5)Take a cold backup of the new database on sun-OS.
thats it .Do thsi excersise on some holiday or when the tarffic is low.Just in case somethin goes wrong you can fall back upon your cold backup..
hope thsi helps
Thank you very much for all your guidelines and prompt replies...
I will start this migration project by this week end.
And i will get back to you all while migration.
Thanks and regards
Click Here to Expand Forum to Full Width