Re: hp to linux...Redhat upgrade ?

From: Alfredo Abate <alfredo.abate_at_gmail.com>
Date: Tue, 19 May 2015 11:57:47 -0500
Message-ID: <CALrB5pqmSLJUY7XoPzVB6uUxaZMsOdao4782j4-+rQrh-7XW-Q_at_mail.gmail.com>



Max,

Yes you can move from one version to another but I believe XTTS is only available from 10.1 and up (the start of Data Pump).

The biggest concern I would have with the XTTS route is given the massive size of your database. I personally have only performed this on databases under 1 TB and the most time consuming part was the copy from one host to another (I'm sure others may have some creative solutions around that).

I have never used the cross platform incremental transportable tablespace so I really can't speak on that. I do see that the incremental transportable tablespace option is only available with 11.2.0.4 so keep in mind the prerequisites listed in MOS doc # 1389592.1.

Alfredo

On Tue, May 19, 2015 at 11:41 AM, max scalf <oracle.blog3_at_gmail.com> wrote:

> Thank you Seth and Alfredo.
>
> Can we use XTTS to go from one version of oracle to another? and how
> about using cross platform incremental transportable tablespace?
>
> On Tue, May 19, 2015 at 11:37 AM, Alfredo Abate <alfredo.abate_at_gmail.com>
> wrote:
>
>> If using XTTS make sure you confirm the endian format from your source to
>> destination platform.
>>
>>
>> SELECT PLATFORM_NAME, ENDIAN_FORMAT from V$TRANSPORTABLE_PLATFORM;
>>
>>
>> Alfredo
>>
>> On Tue, May 19, 2015 at 11:24 AM, Seth Miller <sethmiller.sm_at_gmail.com>
>> wrote:
>>
>>> Max,
>>>
>>> After reviewing your emails with my microscope, I believe you have
>>> already done 99% of the work. Using DataPump with the Compatible setting,
>>> you can use cross-platform TTS to move tablespaces between 10.X and 11.X
>>> databases. No need for the extra step of moving into a 10g database on the
>>> new platform.
>>>
>>> Seth Miller
>>>
>>> On Tue, May 19, 2015 at 11:11 AM, max scalf <oracle.blog3_at_gmail.com>
>>> wrote:
>>>
>>>> FOr me i am talking big database size, biggest one is about 62TB
>>>>
>>>> On Tue, May 19, 2015 at 11:08 AM, Jack Applewhite <
>>>> jack.applewhite_at_austinisd.org> wrote:
>>>>
>>>>> Depends on your DB size(s). We moved/upgraded our 10.2.0.4 DBs from
>>>>> RH Linux servers to Oracle ODAs (Oracle Linux 5.9) via DataPump
>>>>> Export/Import. Largest DB was about 500GB. It worked perfectly for about 20
>>>>> DBs.
>>>>>
>>>>>
>>>>> We'll do the same in the near future for migrating the data from our
>>>>> old 9i ERP database on HPUX to our new ERP on the ODAs, only we'll have to
>>>>> use legacy exp/imp for that.
>>>>> ----
>>>>> Jack C. Applewhite - Database Administrator
>>>>> Austin I.S.D. - MIS Department
>>>>> 512.414.9250 (wk)
>>>>> ------------------------------
>>>>> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>
>>>>> on behalf of max scalf <oracle.blog3_at_gmail.com>
>>>>> *Sent:* Tuesday, May 19, 2015 11:00 AM
>>>>> *To:* D Kennel; Oracle Mailing List
>>>>> *Subject:* Re: hp to linux...Redhat upgrade ?
>>>>>
>>>>> Adding mailing list..
>>>>>
>>>>> Even if i ran oracle 11.2.0.4 on 5.5, i would still have to upgrade
>>>>> linux to 6.5(as that is our new standard)...and i think that might be a
>>>>> trivial task..
>>>>>
>>>>> On Tue, May 19, 2015 at 10:49 AM, D Kennel <dkenlwork_at_gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Per Metalink Note 880989.1 (Requirements for installing Oracle
>>>>>> 11gR2 RDB MS on RHEL/OEL 5x64), RDBMS 11.2.0.x can be installed on linux
>>>>>> 5.2 and greater, so should work on 5.5 as you’re proposing. I went from
>>>>>> Tru64 to RHEL 4 using exp/imp, but haven’t used transportable tablespaces,
>>>>>> so not sure on that part of it, though…
>>>>>>
>>>>>>
>>>>>>
>>>>>> Deborah
>>>>>>
>>>>>>
>>>>>>
>>>>>> *From:* oracle-l-bounce_at_freelists.org [mailto:
>>>>>> oracle-l-bounce_at_freelists.org] *On Behalf Of *max scalf
>>>>>> *Sent:* Tuesday, May 19, 2015 10:09 AM
>>>>>> *To:* Oracle Mailing List
>>>>>> *Subject:* hp to linux...Redhat upgrade ?
>>>>>>
>>>>>>
>>>>>>
>>>>>> Hello List,
>>>>>>
>>>>>>
>>>>>>
>>>>>> I wanted to get some thought from the list with regards to our
>>>>>> migration plan. We have an oracle database(10.2.0.3) running on HP paric
>>>>>> 11.11 and we want to move to Linux 6.5 and oracle 11.2.0.4. We have moved
>>>>>> couple of our system from HP 11.31(oracle 11g) to Linux 6.5(oracle 11g)
>>>>>> using cross platform incremental transportable tablespace. My question is
>>>>>> how does one goes about using the same process for 10g to 11g migration and
>>>>>> also hp to linux. When i say Linux i am talking about RedHat.
>>>>>>
>>>>>>
>>>>>>
>>>>>> We were thinking to do the following
>>>>>>
>>>>>>
>>>>>>
>>>>>> - Install oracle version 10.2.0.3 on Linux(5.5), cant use 6.5 as
>>>>>> oracle 10.2 is not supported with 6.5
>>>>>> - If we do above, then i can migrate to 10.2.0.3 followed by an
>>>>>> upgrade to 11g
>>>>>> - But the step above poses another huddle, oracle 11g is not
>>>>>> supported on Linux 5.5
>>>>>> - so would we upgrade the RHEL version to 6.5 --> but if we
>>>>>> upgrade to 6.5 and oracle remains on 10g that is not supported
>>>>>>
>>>>>>
>>>>>>
>>>>>> I know we can use Golden Gate for something like this but we are
>>>>>> trying to find a cheap options and not have additional cost(Golden gate),
>>>>>> also if we were to go down using Golden Gate i am guessing Golden Gate
>>>>>> version 10 is probably not supported for HP 11.11(source server).
>>>>>>
>>>>>>
>>>>>>
>>>>>> What has the community done for such a migration project?
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>> Confidentiality Notice: This email message, including all
>>>>> attachments, is for the sole use of the intended recipient(s) and may
>>>>> contain confidential student and/or employee information. Unauthorized use
>>>>> of disclosure is prohibited under the federal Family Educational Rights &
>>>>> Privacy Act (20 U.S.C. §1232g, 34 CFR Part 99, 19 TAC 247.2, Gov’t Code
>>>>> 552.023, Educ. Code 21.355, 29 CFR 1630.14(b)(c)). If you are not the
>>>>> intended recipient, you may not use, disclose, copy or disseminate this
>>>>> information. Please call the sender immediately or reply by email and
>>>>> destroy all copies of the original message, including attachments.
>>>>>
>>>>
>>>>
>>>
>>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 19 2015 - 18:57:47 CEST

Original text of this message