Migrating from Linux/Solaris to Windows and vice versa

I need to migrate from Oracle on Linux or Sun Solaris to Oracle on Windows 2000 and the other way around. What are the issues with the migration?

Maria Anderson

Published: 12 Oct 2005

I need to migrate from Oracle on Linux or Sun Solaris to Oracle on Windows 2000 and the other way around, i.e., from Oracle on Windows 2000 to Oracle on Linux or Sun Solaris. What are the issues with the migration?

It's not clear from your question whether your Oracle database(s) will remain at the same release level across platforms so I'm assuming that they will. It is also not apparent from your question whether we are dealing with Oracle9i and lower or Oracle 10g. If we're dealing with Oracle9i and below, the only option to migrate your database across platforms is to use the Oracle utilities export and import.

If your database is at Oracle 10g, you have another option, which is to use the cross-platform transportable tablespaces...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

feature. Solaris, Linux and Windows are supported platforms (you can query the view V$TRANSPORTABLE_PLATFORM to see supported platforms) but they are of different endianness. Solaris is big endian while Linux and Windows are little endian, so there may be an additional step involved to convert the tablespaces being transported on either the source or target side.

To read more about the cross-platform transportable tablespace feature, download the Oracle Database Administrator's Guide 10g (release 10.2) from Oracle Technology Network, which can be found here.

Dig Deeper on Oracle database export, import and migration

How to perform a Big to Little Endian conversion in Oracle 8i Learn how to perform a Big to Little Endian conversion in Oracle 8i using either an Oracle upgrade or export/import in this tip from Oracle expert Brian Peasland.

How to use RMAN CONVERT to migrate from Solaris to Oracle 11g RHEL Learn how to migrate Oracle from Solaris to Oracle 11g RHEL with the RMAN CONVERT command in this tip from an Oracle expert.

Migrating Oracle to Sun Solaris with Oracle Transportable Tablespaces Learn how migrating Oracle from an HP-UX operations system to Sun Solaris is best done with Oracle Transportable Tablespaces in this tip from an Oracle expert.

RMAN convert command to migrate Oracle from Big Endian to Little Endian Want to migrate Oracle from Big Endian to Little Endian? Learn how to do so with the RMAN convert command and Transportable Tablespaces in this expert tip.

How to migrate 1.5 TB Oracle database from Solaris to AIX We have a huge database (1.5 TB) on Solaris (Oracle 10g) and we want to migrate it to AIX -- is expdp the best solution?

Migrate cold backup files from HP-UX to Windows Is it possible to migrate Oracle 10g cold backup files from HP-UX to Windows?

Related Q&A from Maria Anderson

Using /var/opt/oracle/oratab

Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading

Impact on apps of migration from Oracle 8 to 10g

We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading

Error in invoking target install of makefile

I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Amazon Managed Apache Cassandra Service stokes competition

Vendors in the open source Cassandra NoSQL database market voice their concerns about AWS' entry into the field, as the cloud ...

Aerospike 4.8 advances database persistent memory support

Aerospike 4.8 adds full support for Intel's Optane persistent memory, enabling the NoSQL database to run both the index and data ...

Data warehouse technologies evolve as vendors look skyward

The need for high-speed analytics and low latency are pushing data warehousing vendors to create and reinvent their platforms and...

SearchBusinessAnalytics

Government IT pros: Hiring data scientists isn't an exact science

There's no such thing as a data science unicorn, U.S. government experts caution. You'll need more than programmers and technical...

Tableau 2020.1 unveiled for beta testing

Featuring improvements to Explain Data, an AI product that aims to explain the reasons behind data points, the update is made up ...

Data scientist vs. data analyst: What's the difference?

Data scientists and data analysts have a lot of crossover in their roles, but they're certainly not the same. Here's a look at ...

SearchSAP

Understand and fight potential SAP exploits

Without taking the right steps to secure SAP systems, you're creating vulnerabilities for potential exploits. Here's a look at ...

Partners need to target SAP SMB market for cloud transition

In this Q&A, SAP executive Claus Gruenewald discusses how SAP partners are instrumental in servicing the SMB market and how they ...

S/4HANA Cloud integrates Qualtrics for continuous improvement

The latest version of SAP S/4HANA Cloud embeds Qualtrics XM capabilities that provide a way for users to give direct feedback ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

Don't ever put a non-Java LTS release into production

Development teams should avoid non-long-term support releases at all costs. Pay attention to the Java release cycle to make sure ...

Public API strategy considerations for enterprise adoption

As organizations look for more cost-effective ways to manage data, an evolving landscape with APIs has made the technology more ...

Ideas on how to hold a successful code hackathon

Want to host a hackathon? Here are some ideas on what a company can do to host an event that solves problems and reenergizes the ...

SearchDataCenter

Refresh your data center cooling lexicon

As the data center industry moves to improve energy efficiency, refresh your knowledge on the available cooling technology and ...

Comparing Linux distributions: Red Hat vs. Ubuntu

Before selecting a Linux distribution, compare Red Hat Enterprise Linux and Ubuntu when it comes to features, ease of use, ...

Get eco-friendly with LEED data center certification

The U.S. Green Building Council helps companies make existing and new data centers eco-friendly. HVAC, lighting and monitoring ...

SearchContentManagement

DNA as a content storage device is closer than you think

Storing content in DNA may one day be possible, but today, it's neither practical nor cost-effective. Here's where this ...

Acquia acquisition of AgilOne CDP signals CX platform expansion

Acquia's acquisition of AgilOne, a customer data platform specializing in analytics, shows it's serious about competing against ...

Personalization engines help engage and retain customers

Content personalization is essential to getting the right material to the right customers. Here are some personalization engines ...

SearchHRSoftware

US Army HR expects migration to Azure cloud will cut IT costs

The U.S. Army civilian HR operations is hoping for lower operational costs and improved services with a shift to the Microsoft ...

H-1B lottery change may drive increase in visa applicants

The U.S. is launching an H-1B electronic registration system in March. It should make the process of applying for a visa easier, ...

Fight the skills gap with a great upskilling and reskilling strategy

Just say 'no' to a skills gap and high turnover with upskilling and reskilling. Here's a look at the ins and outs of these ...

Dig Deeper on Oracle database export, import and migration

Related Q&A from Maria Anderson

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.