A 3 node Oracle extended RAC has been successfully upgrade from 126.96.36.199 to 188.8.131.52 just last week. As part of the upgrade planning, we started off with GRID home upgrade process from 184.108.40.206 to 220.127.116.11, followed by DB upgrade from 18.104.22.168 to 22.214.171.124 and finally DB upgrade to 126.96.36.199. This was done over the 3 weeks. As there was no direct in-place database upgrade option for a database v188.8.131.52 to 184.108.40.206, we had to take the alternative route.
In previous two blog posts, I have shared the details about the challenges faced and resolved. So, here is another challenge encountered during the database upgrade. Encountered the below pre-requisites failure during the pre-requisites validation by DBUA:
Below is the details of the error:
It was wired to see the message despite the fact that the GRID was successfully upgraded, including ASM. After a quick search we have come across of two MOS references , mentioned below, and the solution was just straight forward.
To expedite the post DB upgrade requirements, we did prepare complete environment for EB database.
The solution was to rename the sqlnet.ora file from the 12c network/admin directory. One we did this and resumed DBUA, it went through.
Upgrade database to 220.127.116.11.0, DBUA fails: COULD NOT FIND ANY DISKGROUPS [2039864.1]
Database Upgrade From 18.104.22.168 To 22.214.171.124 Pre-checks Failing while using DBUA [2317976.1]