Re: Upgrade from 11.2.0.4 to 12.1.0.2 using EM12c failed

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Tue, 29 Sep 2015 16:37:10 -0500
Message-ID: <CAEueRAWam5kX7yf-e=_qrCZmsiwEaoPB3FVghVoZVGhXEKjnQA_at_mail.gmail.com>



Peter,

login.sql and glogin.sql files can be in several places. Take a look at the default search paths in the documentation to see if there is one being picked up in another directory.

Seth Miller
On Sep 29, 2015 2:39 PM, "Alfredo Abate" <alfredo.abate_at_gmail.com> wrote:

> Peter,
>
> I see several My Oracle Support documents referencing the glogin.sql file
> as causing problems with upgrades and even patching.
>
> Did the file exist in the QA database where the upgrade was successful?
> What happens if you follow their suggestion and just rename the file then
> continue with the upgrade?
>
> Alfredo
>
> On Tue, Sep 29, 2015 at 2:27 PM, Schauss, Peter (ESS) <
> peter.schauss_at_ngc.com> wrote:
>
>> My environment: 64 bit Linux release 6.7
>> Oracle 11.2.0.4 going to 12.1.0.2
>>
>> I was able to upgrade my QA copy (running on my QA database server) using
>> EM12c.
>>
>> When I tried the same thing in production it failed with :
>>
>> Unexpected error encountered in catconInit; exiting
>>
>> Oracle support said that I should look for a file called glogin.sql in
>> $ORACLE_HOME/sqlplus/admin and rename it. This file has no executable sql
>> statements in it, only comments. Does this suggestion make sense? This is
>> a production environment so my ability to test is limited and, of course,
>> the error does not happen in QA.
>>
>> Any ideas?
>>
>> Thanks,
>> Peter
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 29 2015 - 23:37:10 CEST

Original text of this message