| 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.
John,
I will use the Windows Oracle 8i export executable for export and then will
import it in the Linux environment as you have explained. The only reason I
am using Oracle 8i/Linux because I have CD for this version, for 9i, I need
to download the software. I will try it as well. About moving over the dump
file from Windows OS to Linux, what I do is that once you have Linux OS
running, you can mount DOS Fat drive onto Linux using mount command and that
way you can share files between Linux and DOS on the same machine.
Thanks.
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of John
Weatherman
Sent: Thursday, August 22, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L
Subject: 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-----
From: Dharminder Kumar [mailto:dharminder_at_softhome.net]
Sent: Thursday, August 22, 2002 11:11 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux
7.
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-----
From: root_at_fatcity.com [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
Subject: RE: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux
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
--
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 Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: 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).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: 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).
-- Please see the official ORACLE-L FAQ: 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 Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: 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 - 11:53:34 CDT
 |
 |