Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

copy database to another machine 1

Status
Not open for further replies.

maswien

Technical User
Sep 24, 2003
1,286
CA

I want clone a database from one machine with AIX 5.2 to another machine with Sun Solaris 5.9. I followed the steps in metalink article: 174226.1, copied adata files, redo log files and control files over to the new box, then change the init.ora file to adjusting the path thing. When I tried to start the database I got an error:


SQL> startup mount pfile=$ORACLE_HOME/dbs/initPSP.ora
ORACLE instance started.

Total System Global Area 219646344 bytes
Fixed Size 731528 bytes
Variable Size 150994944 bytes
Database Buffers 67108864 bytes
Redo Buffers 811008 bytes
ORA-03113: end-of-file on communication channel


I wonder what I did wrong? Is this because the hardware is different? Any suggestion? Thanks a lot!
 
yes.. you wil need to do an import export... 10g allows you to migrate datafiles to different platform.. not avail in 9i



Sy UK
 

Thanks Scunningham99 ! good to know that.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top