Re: Upgrade from 11.2 to 12.2

(Hope I'm responding right, it has been such a long time)

Ensure that have a very good backup of everything, "just in case"!

I had just a RMAN backup on 5/2/2017, and went to upgrade Apex to the newest version on my development server. That failed with the dreaded ORA-600 errors, and I was unable to go go backwards, and support didn't have me revert to the last backup, but instead kept me trying different things to get past it.

Finally, after week, support said there was nothing they could do until I either upgraded to the newest version of 12.1.xxxx or for me to upgrade to the newest version of 12.2.xxxx. So I opted for the 12.2.xxx upgrade, and that failed as well. Of course by then my RMAN backups had cycled out, so I had no viable backups left.

Here it is now almost 4 months later and I have received one patch, which seemed to fix some of the ORA-600 errors, but I still have a few remaining, and a whole bunch of new errors I don't remember seeing before (but perhaps that was because they were hidden amongst all of the ORA-600 errors).

This is on a Windows 2012 server, so if you are on a different platform, perhaps you'll be okay. But for me in my case, my "Unbreakable Oracle" has been broken for (2 days short of) 4 months. And as a disclaimer, I have been doing DBA and programming work on Oracle since 1990, so I'm not a simple newbie at this. :)

This link/document seems mainly to be in upgrading once you are already up to version 12 and using the multi-tenant architecture, but it is a really good article. https://community.oracle.com/docs/DOC-995765

Good luck!
Bill Ferguson

On Wed, Aug 23, 2017 at 10:15 AM, Kim Berg Hansen <kibeha_at_gmail.com> wrote:

> Hi, Michael
>
> In my opinion, *the* authority on Upgrading is Mike Dietrich: https://
> mikedietrichde.com/
> There is an (in)famous 555 page slide deck detailing all steps:
> https://mikedietrichde.com/slides/
>
> Have a look at his blog and slides - then after that you'll probably have
> some more specific questions you can ask then ;-)
>
>
> Happy upgrading :-)
>
>
> Regards
>
>
> Kim Berg Hansen
>
> http://www.kibeha.dk
> kibeha_at_kibeha.dk
> _at_kibeha <http://twitter.com/kibeha>
>
>
> On Wed, Aug 23, 2017 at 5:27 PM, Michael Calisi <oracle455_at_gmail.com>
> wrote:
>
>> can any one recommend a document that provide the steps. I will be using
>> data pump for the initial export/import and utilize Golden Gate to keep it
>> current before the switch over.
>>
>> --
>> Michael
>>
>
>

-- 
-- Bill Ferguson

--
http://www.freelists.org/webpage/oracle-l