Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Migrating Oracle 8i on Unix HP to Oracle for windows

SOLVED
Go to solution
Michael Brooks_4
Occasional Advisor

Migrating Oracle 8i on Unix HP to Oracle for windows

Hi All,
Does anyone know of any resources to migrate Oracle UNIX HP to Oracle for Windows, or how to do it?

Thanks so much,
Mike
8 REPLIES
Michael Schulte zur Sur
Honored Contributor

Re: Migrating Oracle 8i on Unix HP to Oracle for windows

Hi,

create a database under Windows, export under HP-UX and import under Windows.

is that enough, or do you need more details?

Michael
Alzhy
Honored Contributor

Re: Migrating Oracle 8i on Unix HP to Oracle for windows

Export / Import.

or

Use Advanced Replication...
Hakuna Matata.
James A. Donovan
Honored Contributor
Solution

Re: Migrating Oracle 8i on Unix HP to Oracle for windows

Suggest you review the relevant Metalink articles. E.g., this one...

http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=10767.1

Purpose ------- This article highlights some important points to consider when performing a Full System Export and Import. Scope and Application --------------------- It is intended to assist users performing FULL System Exports and Imports. A Full System Export and Import is a useful way to replicate or clean up a database. Please note the following guidelines when performing a Full System Export and Import: 1. When performing the import, ensure you are pointing at the correct instance. Always check values for the SID and two task driver before proceeding. *Note: On Unix systems, just entering a sub-shell, such as using C-shell, can change the database that the import would work against. 2. When possible, it is advisable to take a physical copy of the exported database and the database you intend to import into before starting the import. This ensures any mistakes are reversible. 3. *NEVER* run a FULL SYSTEM IMPORT on a machine that has more than one database UNLESS you are 100% sure all tablespaces have been pre-created. A full import will create any undefined tablespaces using the same datafile names as the exported database. There are situations where this is very dangerous: -> If the datafiles belong to ANY other database, they will be CORRUPTED. This is especially true if the exported database is on the same machine, because its datafiles will be re-used by the database you are importing into. -> If the datafiles have names that clash with existing operating system files. 4. When exporting, it is advisable to also produce a report showing information you may need before / after the import: -> List the tablespaces and datafiles -> List the rollback segments -> List a count, by user, of each object type such as tables, indexes, etc. This enables you to ensure that tablespaces have been pre-created and to check the success of the import after it is complete. 5. If you are creating a completely new database from an export, remember to create an extra rollback segment in SYSTEM, and make this available in the init.ora file before proceeding with the import. 6. There are some versions of export that do not retain sequence numbers correctly. It is advisable to select next_value for each sequence after the export so that these can be checked after import. Following these guidelines will help you to avoid major problems. -----------------------------------------------------------------
Remember, wherever you go, there you are...
Printaporn_1
Esteemed Contributor

Re: Migrating Oracle 8i on Unix HP to Oracle for windows

The only way to move oracle data between platform is exp/imp.

it is your choice to do full /tablespace or user mode export/import.
enjoy any little thing in my life
Michael Brooks_4
Occasional Advisor

Re: Migrating Oracle 8i on Unix HP to Oracle for windows

Thanks, for the infomation. However, they don't have oms install here. Can anyone tell me how to do an export from the Unix command line in detail please?

Thanks again,
Mike
Yogeeraj_1
Honored Contributor

Re: Migrating Oracle 8i on Unix HP to Oracle for windows

hi mike,

If you want to do a full database export, you can try:

$ORACLE_HOME/bin/exp $ACC_PASS filesize=1024M file=\($DMP_PATH1/expa.dmp,$DMP_PATH1/expb.dmp,$DMP_PATH1/expc.dmp,$DMP_PATH1/expd.dmp,$DMP_PATH1/expe.dmp\) buffer=409600 log=$LOG_PATH/exp.log full=Y grants=Y rows=Y compress=N direct=n

where $ORACLE_HOME, $DMP_PATH1, $LOG_PATH and $ACC_PASS will have to be replaced with values from your environment.

also note that the dump file will be split into file sizes of 1GB just in case your export goes more that 1 GB....

hope this helps!

if you have any further queries please do let us know.

regards
Yogeeraj

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Volker Borowski
Honored Contributor

Re: Migrating Oracle 8i on Unix HP to Oracle for windows

Hi,

exp / imp if native Oracle, but watch out for DB-charset and proper NLS-environment.

If SAP-Application is involved, you need to perform a systemcopy using special SAP-Migration Tools.
Check http://service.sap.com/osdbmigration
in this case.

Good luck
Volker
Tim Sanko
Trusted Contributor

Re: Migrating Oracle 8i on Unix HP to Oracle for windows

Mike,

We wish you a happy migration.

Hopefully, you don't have the MSFun tha we MShave. Good Luck, and see if you can't keep the HP up to date as you may need to recover back to it soon if you have replication set up, it may save you tons of grief...

Tim