Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migrating from HP-UX to Red Hat Linux

829206Dec 22 2011 — edited Jul 27 2012
Hello all,

I'm planning to migrate and upgrade a 10g database from HP-UX to Red Hat Linux using the following method..

Goal #1: Migrate database from HP-UX to RHEL
Goal #2: Target database should be 11g

Source Database version : Oracle 10g
Source Host : HP-UX (64 Bit)

Target Database version: Oracle 11g
Target Host: Red Hat Linux (RHEL5) 64 bit


Method

1) Install a Shell 11g database on the target system (Linux).

2) Make all tablespaces in source database (10g on HP-UX) READ ONLY with the exception of SYS/SYSAUX/UNDO/TEMP.

3) Take a transportable tablespace export dump using either old exp utility or datapump.

4) Take an export of all data schemas without tables/indexes.

5) copy all datafiles from source system (HP-UX) to target system (Linux).

6) copy all the export dumps from source to target system.

7) Make all the tablespaces in the source system (HP-UX) READ WRITE.

8) Convert the datafiles in the target system (Linux) from Big-Endian to Little-Endian using RMAN.

9) Import the data schemas.

10) Import all the tablespaces using either old exp utility or datapump.

11) create roles, public database links, public synonyms etc on the Linux system.


Are there any flaws or is there any step that would not work in the above methodology?

PS: The database contains a a bunch of materilaized views..


Thanks for your time...

Comments

Paavo

Hi

perhaps make additional column read_only for toggling read only which is computed based on various values of col1 ? I remember that I had challenges with IG read only settings if there are nulls in the read_only column, so it should be not_null. I am not near my app now, but will check.

rgrds Paavo

Sgodavar-Oracle

I'm not sure how to update that column, if i add another read-only column?. I should be able to select the "col2" and update, when it's not read-only (on change of col1).

Paavo

Hi

How about making app to apex.oracle.com with your requirement ?

rgrds Paavo

1 person found this helpful
Veerendra Patil
Answer

Hi,

Can you use Disable Column col2 on DA

Suppose col1 has 2 values in LOV - 1,2.

On selecting value 1 in col1 - col2 should be disabled,

On selecting value 2 in col1 - col2 should be enabled to select values.

Create a DA on change on col1- as below

1.png

1.png

Create the opposite Action as Enable.

Hope this suits.

Thanks,
Veerendra.

Marked as Answer by Sgodavar-Oracle · Sep 27 2020
1 person found this helpful
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 24 2012
Added on Dec 22 2011
#database-upgrade
5 comments
9,982 views