A 3 node Oracle extended RAC has been successfully upgrade from 184.108.40.206 to 220.127.116.11 just last week. As part of the upgrade planning, we started off with GRID home upgrade process from 18.104.22.168 to 22.214.171.124, followed by DB upgrade from 126.96.36.199 to 188.8.131.52 and finally DB upgrade to 184.108.40.206. This was done over the 3 weeks. As there was no direct in-place database upgrade option for a database v220.127.116.11 to 18.104.22.168, 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 22.214.171.124.0, DBUA fails: COULD NOT FIND ANY DISKGROUPS [2039864.1]
Database Upgrade From 126.96.36.199 To 188.8.131.52 Pre-checks Failing while using DBUA [2317976.1]