Re: Upgrade ASM and database to 12c - No GRID or RAC

That's a nice trick Andy, thanks.

I actually did it the hard way - installed 12c GI and applied patch 12.1.0.2.160119 (JAN2016) and was about to run rootupgrade. To my surprise this was not possible with Oracle Restart. The only solution was to deconfigure the 11g GI (roothas.pl -deconfig -force) and then configure the new 12c one (roothas.pl). The only downside is that you need to add all of your resources back manually - ASM, listener and all databases.

Regards,
Sve

On Thu, May 12, 2016 at 11:18 PM, Andy Colvin <acolvin_at_gmail.com> wrote:

> The rootupgrade.sh script should create a log file in
> $GRID_HOME/cfgtoollogs/crsconfig/roothas_<timestamp>.log. That will most
> likely tell you what was running and where the error lies. It's also
> worthwhile to check the ASM alert log to see if it threw any specific
> errors.
>
> One question - did you apply the latest GI PSU to the home before running
> rootupgrade.sh? Normally, the procedure that I follow when upgrading GI is:
>
> - Apply latest PSU to the old GI home
> - Install the new home with ./runInstaller
> - When the files have been installed and the screen pops up telling
> you to run rootupgrade.sh, install the latest GI PSU
> - Run rootupgrade.sh
> - After rootupgrade.sh completes, click the ok button on the window
> - Let the installer finish the upgrade
>
> Note that the PSU on the new home needs to be installed manually, rather
> than using opatch auto. This is because there isn't anything running out
> of the home. MOS note #1591616.1 includes the order that you should apply
> the various patches in:
>
> $ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local
> <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%
> $ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local
> <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%ACFS TRACKING BUG%
> $ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local
> <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%DBWLM TRACKING BUG%
> $ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local
> <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%RDBMS PSU TRACKING BUG%
>
> Thanks,
>
> Andy
>
> On Thu, May 12, 2016 at 2:51 PM, Sandra Becker <sbecker6925_at_gmail.com>
> wrote:
>
>> We have an SR open with Oracle, but so far they haven't come back with
>> anything useful.
>>
>> Sandy
>>
>> On Tue, May 10, 2016 at 8:17 PM, Andrew Kerber <andrew.kerber_at_gmail.com>
>> wrote:
>>
>>> open an SR with Oracle.
>>>
>>> Sent from my iPhone
>>>
>>> On May 10, 2016, at 5:12 PM, Sandra Becker <sbecker6925_at_gmail.com>
>>> wrote:
>>>
>>> Current environment:
>>>
>>> - Oracle EE 11.2.0.4
>>> - Linux x86-64
>>> - ASM 11.2.0.4
>>>
>>> We have several environments that were set up as single-instance
>>> databases using ASM, no GRID or RAC. We have been unsuccessful in trying
>>> to upgrade ASM to 12.1.0.2. We have not attempted to upgrade the databases
>>> since we were told that ASM must be upgraded to 12c first. Steps we have
>>> taken:
>>>
>>> - unzip the grid files
>>> - unset variables like ORACLE_HOME, ORA_CRS_HOME, etc.
>>> - from the unzipped location, kick off runInstaller
>>> - execute the rootupgrade.sh script
>>>
>>> The last step is where we have problems. The last entry in the log is
>>> for "asmca -silent -upgradeLocalASM". After a couple of hours (had a
>>> meeting in between), we just pressed the <Enter> key a few times to see if
>>> it was waiting for something. Apparently, it was prompting for something,
>>> but no prompts appeared on the screen so we have no idea what we should
>>> have answered to the prompts. The log did show one prompt for "Enter
>>> password". We did verify that the ASMSNMP user was in there and had the
>>> sysdba privilege. We verified that the orapw+ASM password in the 11g OHome
>>> was correct for SYS and ASMSNMP.
>>>
>>> Can someone point us to documentation or a step-by-step guide that will
>>> guide us in upgrading this kind of environment? Unfortunately, this is a
>>> secure system so I am unable to supply any logs.
>>> Thank you for any suggestions and guidance.
>>> --
>>> Sandy B.
>>>
>>>
>>
>>
>> --
>> Sandy B.
>>
>>
>

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