| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux 7.
Kumar,
You can't copy the datafiles between OSs unless they are binary compatable,
with Windows and any
flavor of Unix are not. Also, you will have problems trying to export from
9i and import to 8i. You need
to run the export using 8i executables, or at least I could never get it to
work any other way. Is there
a reason you can't install 9i on the Linux side? Also, if you are saying
that both "machines" are the
same hardware ("dual boot"), how do you expect to get the .dmp file from one
"side" to the "other side"?
Do you have some network storage somewhere?
Good Luck,
John P Weatherman
Database Administrator
Replacements Ltd.
-----Original Message-----
Sent: Thursday, August 22, 2002 11:11 AM
To: Multiple recipients of list ORACLE-L
Dennis,
In my case Net8 connection is not feasible because I have both OS Windows
2000/ Linux on the same machine using dual boot. So the only option for me
is to export the required user from Windows database and then import from
Linux database. But please note that I have source database Windows 2000/9i,
but the source database is Linux/8.1.6. Can this be any problem for
export/import.
Recently I copied a database from a Window machine to another window machine by copying the database files, redo log file, control files etc to target machine in the corresponding directory and just created a service on the target machine by using oradim and it worked fine. Is that possible if you want to move the database and other files of Windows OS database to a Linux OS database and then use svrmgrl to do something similar to get windows database working on Linux. I know for this to work, I need to recreate or make changes to control file.
Thanks.
-----Original Message-----
mailto:root_at_fatcity.com]On Behalf Of DENNIS
WILLIAMS
Sent: Wednesday, August 21, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L
7.
Kumar
Ummm . . . are you using any 9i features? I'm assuming you have
considered using 9i on Red Hat. Sounds like probably use the 8i export
function to create the export file. I'm assuming the data involved is small
enough to make export/import practical. If you create a Net8 connection, you
can just copy the data.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, August 21, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L
8.1.6
I want to move the Windows 2000/ Oracle 9i database to Linux Red Hat 7.1/ Oracle 8.1.6. Please suggest the options.
Thanks.
--
Please see the official ORACLE-L FAQ: <http://www.orafaq.com>
http://www.orafaq.com
--
Author: Dharminder Kumar
INET: dharminder_at_softhome.net
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: john.weatherman_at_replacements.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Aug 22 2002 - 10:28:48 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |