- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Migrating Oracle 8i on Unix HP to Oracle for windo...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2003 06:09 AM
тАО11-26-2003 06:09 AM
Does anyone know of any resources to migrate Oracle UNIX HP to Oracle for Windows, or how to do it?
Thanks so much,
Mike
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2003 06:26 AM
тАО11-26-2003 06:26 AM
Re: Migrating Oracle 8i on Unix HP to Oracle for windows
create a database under Windows, export under HP-UX and import under Windows.
is that enough, or do you need more details?
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2003 06:32 AM
тАО11-26-2003 06:32 AM
Re: Migrating Oracle 8i on Unix HP to Oracle for windows
or
Use Advanced Replication...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2003 06:43 AM
тАО11-26-2003 06:43 AM
Solutionhttp://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. -----------------------------------------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2003 02:37 PM
тАО11-26-2003 02:37 PM
Re: Migrating Oracle 8i on Unix HP to Oracle for windows
it is your choice to do full /tablespace or user mode export/import.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2003 04:13 AM
тАО12-01-2003 04:13 AM
Re: Migrating Oracle 8i on Unix HP to Oracle for windows
Thanks again,
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2003 11:57 PM
тАО12-01-2003 11:57 PM
Re: Migrating Oracle 8i on Unix HP to Oracle for windows
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2003 04:45 AM
тАО12-02-2003 04:45 AM
Re: Migrating Oracle 8i on Unix HP to Oracle for windows
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2003 07:26 AM
тАО12-03-2003 07:26 AM
Re: Migrating Oracle 8i on Unix HP to Oracle for windows
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