Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Migration oracle from tru64 to hpux

SOLVED
Go to solution
marshal_4
Advisor

Migration oracle from tru64 to hpux

Hi Gurus,

If im going to migrate my 80 gb database from alpha server (tru64) to rp5740(hpux11i). Will i be needing only the export/import command? Will it already migrate all my database files to rp5470?

Thanks and more power,
marshal
want some guts learn HPUX
14 REPLIES
Graham Cameron_1
Honored Contributor

Re: Migration oracle from tru64 to hpux

>>Will i be needing only the export/import command?

If only.

Export/Import will move your data for you, assuming you have enough room for the dmp file, but you will have to do all the tablespace creation and datafile allocation manually. But this is what you would want in any case, otherwise the datafiles may not be placed where you want them.
There's a paper on this subject here: http://otn.oracle.com/deploy/performance/pdf/opt_storage_conf.pdf

You don't mention Oracle versions: if you are moving to but not already at 9i, there are many new features to do with file and tablespace management.

Good luck

-- Graham
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Indira Aramandla
Honored Contributor

Re: Migration oracle from tru64 to hpux

Hi marchal,

You will need to install the oracle RDBMS software on your HP (rp5740) server that is certified for HP-UX 11i.

Then create the database,empty tablespaces (datafile) and the schemas (users).

Grant privileges and quotas to users.

Then you export the data from the source server (tru64) database and then import the data intot the newly created database on rp5740.

Depending on the time available as exp/imp takes long time, you can run multiple sessions of export and imports (by schema, or table lists)


I hope this helps.

IA
Never give up, Keep Trying
Sanjay Kumar Suri
Honored Contributor

Re: Migration oracle from tru64 to hpux

Hello

There is another useful document at the following address

http://www.hp.com/dspp with title

Oracle Database Migration, Tru64 UNIX to HP-UX

Thanks.
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
marshal_4
Advisor

Re: Migration oracle from tru64 to hpux

Hi Graham,

I thought after importing my dump file all everything will be migrated to the new machine. Why do i have to manually create or allocate the tablespace and datafiles. Sorry im confused.

Thanks,
Marshal
want some guts learn HPUX
marshal_4
Advisor

Re: Migration oracle from tru64 to hpux

Hi IA,

What do you mean by oracle RDBMS software that i need to install in rp5470? Is it free?

Thanks,
Marshal
want some guts learn HPUX
marshal_4
Advisor

Re: Migration oracle from tru64 to hpux

Hi Sanjay,

I visited the link that you gave unfortunately i did not found any information regarding Oracle Database Migrating Tru64 to HPUX.

Thanks,
Marshal
want some guts learn HPUX
Yogeeraj_1
Honored Contributor
Solution

Re: Migration oracle from tru64 to hpux

Hi marshal,

Export/Import is the only supported method of moving an existing Oracle database from one hardware platform to another. This is due to the incompatible file structures between Operating Systems.

The only option is to take a logical backup of the database, hence export/import.

The general procedure is as follows:
1. Gather the necessary information from your source database.
You will need to know the exact name of all TABLESPACES, so perform the following query as a DBA user:
SQL> SELECT tablespace_name FROM dba_tablespaces;

Maybe a good time to move to Locally managed tablespaces if you are still using dictionary managed tablespaces.

2. Perform a full export from the source database as a DBA user.
For example:
exp system/manager full=y file=expdat.dmp

3. Move the dump file to the target database server via ftp or NFS.

4. Create a database on the target server.

5. Before performing the import, you will need to precreate your tablespaces.
This is necessary since the import will want to create the corresponding datafiles in the same file structure as was at the source database. Since your file structure will be different on the target database, precreating the tablespaces will allow you to specify a file structure that will work.

6. Perform a full import with the parameter IGNORE=Y into the target database as a DBA user.
imp system/manager full=y ignore=y file=expdat.dmp

Using IGNORE=Y will tell Oracle to ignore any creation errors during the import, allowing the import to complete.

Please refer to metalink note 113178.1


hope this helps!

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Indira Aramandla
Honored Contributor

Re: Migration oracle from tru64 to hpux

Hi marshal,

By Oracle 8i RDBMS I ment the Oracle 8i software. You have Oracle 8i software on your tru64 (HP Tru64 UNIX ), where you have an database of 80 GB. Like wise you will have Oracle 8i software for (HP-UX PA-RISC) for HP-UX 11i.

You will get the software by creating a TAR in metalink / requesting from oracle, by specifing the platform.

Once you install this software, you will be able to create any empty database. And then you can follow the steps and import the data from the source database.

IA.
Never give up, Keep Trying
Yogeeraj_1
Honored Contributor

Re: Migration oracle from tru64 to hpux

hi again,

About your question:
<>
The Oracle RDBMS software is the corresponding Oracle software that you currently have on your tru64 and that you need on your HP-UX server.

YOu may either contact your Oracle support or download it from OTN.

hope this helps too!

regards
YOgeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
marshal_4
Advisor

Re: Migration oracle from tru64 to hpux

Hi Yogeeraj,

Where can i found the metalink note 113178.1. Sorry im quite new in databases.

Thanks,
Marshal
want some guts learn HPUX
marshal_4
Advisor

Re: Migration oracle from tru64 to hpux

Hi Yogeeraj,

Follow up question. I have allocated 2gb for each tablespaces in my source database will this mean that if i pre create the tablespaces in my target database i should also allocate 2gb (or more)each?

Do i also have to pre create the datafiles?

Thanks a lot,
Marshal
want some guts learn HPUX
Indira Aramandla
Honored Contributor

Re: Migration oracle from tru64 to hpux

Attached is the note 113178.1

If you have a login to oracle Metalink, then login and enter the note number in the search place and it will fetch for you.


IA
Never give up, Keep Trying
Yogeeraj_1
Honored Contributor

Re: Migration oracle from tru64 to hpux

Hi,

<>

OracleMetaLink is Oracle Support Services' premier web support service. OracleMetaLink is FREE for Oracle customers with current product support contracts. OracleMetaLink leverages the Internet for quick and immediate access to technical support 24 hours a day, 7 days a week. OracleMetaLink allows you to access support whenever and wherever you need so you can enhance productivity and minimize business disruption.

http://metalink.oracle.com

FOr more information about the access to this Oracle SUpport site, see:
http://www.oracle.com/support/metalink/index.html

You should have a Support Identifier to be able to register to this site.

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

Re: Migration oracle from tru64 to hpux

hi,

<< Follow up question. I have allocated 2gb for each tablespaces in my source database will this mean that if i pre create the tablespaces in my target database i should also allocate 2gb (or more)each?

Do i also have to pre create the datafiles?>>

You need only to pre-create the tablespaces only (the datafiles will be automatically created during this process).

I would not create 2GB tablespaces. I would create locally managed tablespaces (SMALL, MEDIUM, LARGE, XLARGE) with uniform extent sizes and if possible review the tablespaces that currently being used by the tables.

regards
Yogeeraj

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