Re: moving oracle database 9 from another computer to another one

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Wed, 19 Dec 2007 17:55:33 GMT
Message-ID: <pWcaj.33793$5l3.19267@edtnps82>

"noumian" <n.noumia_at_gmail.com> wrote in message news:1e751a0c-d5ca-4f2c-a126-d97ad842da61_at_f3g2000hsg.googlegroups.com...
> hello, i am not an expert in orace, that's why am here.
> i need to move all a database (structure+data) from another computer
> to another one, and i need also to place the database in the same
> directory in the new pc as it was in the old pc.
> what is the best way to do this? please try to explain point by point.
> thank you!

The basic steps are:

install oracle on the new computer (must be the same OS!), patched to exactly same level, e.g. Oracle 9.2.0.7 with opatch 1234 installed copy the files (redologs, control files, database files, temp files) create instance
configure sqlnet (listener.ora, tnsnames.ora etc)

I would recommend that you do hire an Oracle DBA to the move.

-- 
Terry Dykstra

Received on Wed Dec 19 2007 - 11:55:33 CST