Re: hp to linux...Redhat upgrade ?

From: max scalf <oracle.blog3_at_gmail.com>
Date: Tue, 19 May 2015 12:23:57 -0500
Message-ID: <CAKoJ+qBavgOgN+9aDa59uHtNG+XKCYXOm2zEymLvk7cyDv1_VQ_at_mail.gmail.com>



I believe the 11.2.0.4 is the destination, the source can be 10.2 ?

On Tue, May 19, 2015 at 11:57 AM, Alfredo Abate <alfredo.abate_at_gmail.com> wrote:

> 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 - 19:23:57 CEST

Original text of this message