Re: hp to linux...Redhat upgrade ?

Yes you can have a source of 10.2 to go to 11.2.0.4.

As with anything it would be highly recommended to practice this a few times in a non-production environment that is hopefully similar (duplicate?) of Production. By the time you get to Production it should be easy to perform.

Alfredo

On Tue, May 19, 2015 at 12:23 PM, max scalf <oracle.blog3_at_gmail.com> wrote:

> 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