Re: Upgrade from 10g1 to latest 19c
Date: Mon, 12 Aug 2024 09:05:15 -0700
Message-ID: <CAORjz=MkcroDRKF8pfQPGzQ81pjc2nfyU89DmDChqwVrqYEYcA_at_mail.gmail.com>
Hi Mladen,
For many small businesses, maybe medium size ones as well, I tend to shy away from GG due to the onerous license cost.
That Shareplex info is good to know, thanks.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Oracle ACE Alumni
Pythian Blog http://www.pythian.com/blog/author/still/
Github: https://www.pythian.com/blog/technical-track/author/jared-still
<https://github.com/jkstill>
Personality: http://www.personalitypage.com/INTJ.html
On Sun, Aug 11, 2024 at 12:45 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:
> On 8/11/24 3:12 PM, Jared Still wrote:
>
> I believe the upgrade method requires upgrading to another version first,
> such as 11.2.0.4.
>
> From there, a direct upgrade to 19c is possible.
>
> But, there is no single-hop route to 19c bliss from 10g via database
> upgrade methods
>
> Depending on the size of the database, you may want to go the
> datapump route, as it results in a 'cleaner' database.
>
> There will be no extra baggage from whatever has been done to that
> database the past few years.
>
> That said, the datapump method requires more effort and planning, as there
> may be related schemas, public synonyms and other objects that are not in
> the schema.
>
> This is the route we have taken in just this same situation with a client
> recently.
>
> Only by using DP did we discover the app has created required objects in
> SYS (oh my!)
>
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
> Principal Consultant at Pythian
> Oracle ACE Alumni
> Pythian Blog http://www.pythian.com/blog/author/still/
> Github: https://www.pythian.com/blog/technical-track/author/jared-still
> <https://github.com/jkstill>
> Personality: http://www.personalitypage.com/INTJ.html
>
> Did Oracle 10g support SECUREFILES LOBs? I forgot. If it didn't, you may
> end up with BASICFILES LOB columns, which may not be what the users want.
> There are very significant changes from Oracle 10g --> Oracle 19c. Another
> method would be to use Golden Gate or Quest SharePlex and replicate the
> data into the pre-created 19c schema. That would also minimize the
> downtime, because the source database can remain active during the
> replication.
>
> Speaking of the choice between GG and SharePlex, I would go with the
> latter because it's significantly cheaper. Also, Quest is very flexible
> with the licenses and can "rent" you a license for 6 months or so, until
> your task is done.
>
> Regards
>
>
>
> --
> Mladen Gogala
> Database Consultant
> https://dbwhisperer.wordpress.com
> -- http://www.freelists.org/webpage/oracle-l
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 12 2024 - 18:05:15 CEST