While upgrade four-node Oracle RAC environment from 11.2.0.1
to 11.2.0.3, DBUA started to throw ORA-17502 error while creating a new SPFILE
for the upgraded database. Not only did DBUA err out but it also deleted the
existing SPFILE.
Below is the screenshot of the error:
In order to complete the
upgrade process, we have to manually perform the following:
- Re-create the SPFILE,
- Complete Post-installation steps (like executing “utlrp.sql”), and
- Re-create the Cluster Services
I later found out on MOS
that this situation can be avoided by pinning the nodes as shown below:
$GRID_HOME/bin/crsctl
pin css -n
To find out whether
node(s) is pinned or not:
$GRID_HOME/bin/olsnodes
-t –n
So, make sure that you pin the nodes before running DBUA to avoid the above errors.
