CHANGE IP FOR ASM-ORACLE RESTART STANDALONE – CRS-2799 FAILED TO SHUTDOWN RESOURCE

There was a need for a customer, to have a deconfigured Oracle Restart Standalone template (removed IP and configuration and be ready to configured with a new one).

This can be done by following the guidelines of deconfiguring – configuring IP based on the Oracle document: Document 1552810.1

The problem occurred when trying to run the deconfig command:

sudo runuser -l grid -c ‘$ORACLE_HOME/crs/install/roothas.sh -deconfig -force’

When running the above, it tries to remove the existing configuration.
Removes ASM (Automatic Storage Management) configuration, ONS (Oracle Notification Service), HAS (High Availability Services) and CSS (Cluster Synchronization Services).

In our case, it failed in the middle of the process because it could not shutdown the HAS.

The error was: CRS-2799: Failed to shutdown resource ‘ora.DATA.dg’

Nikos Minaidis - Art of Coding

So, the deconfiguration could not be completed in that way.

I tried also to force stop manually the HAS first but it failed again giving the same error:

sudo runuser -l grid -c ‘$ORACLE_HOME/bin/crsctl stop has -f’

Nikos Minaidis - Art of Coding

After many tries and with different users (e.g. root), one thought was to reboot the machine:

sudo -i -u root

reboot

So after rebooting it, the service that was stuck ora.DATA.dg became offline.

The status can be found by running:

sudo runuser -l grid -c ‘$ORACLE_HOME/bin/crsctl stat res -t’

After checking the offline status, then the deconfig command ran successfully without any errors. Giving the message: Successfully deconfigured Oracle Restart stack.

Another workaround, that we found later on which is not exactly recommended and is not best practice:
1)Shutdown the database
2)Stop the HAS manually:
sudo runuser -l grid -c ‘$ORACLE_HOME/bin/crsctl stop has -f’
3)Then run the deconfig process


Written by Nikos Minaidis
19/01/2022

Σχολιάστε