How to Reconfigure Oracle Restart

In this article, we are going to reconfigure oracle restart step by step. Why we need to reconfigure the oracle restart. Actually, in my organization, they rename the server name, if the server renamed and rebooted the ASM instance failed showing error ORA-29701 unable to connect to cluster synchronization service.

Read: How to create ASM diskgroup

Steps to Reconfigure Oracle Restart

Step 1. Remove the old Configuration of Oracle Restart, run below command from Root user.

#$GRID_HOME/crs/install/roothas.pl -deconfig -force

Successfully deconfigured Oracle Restart stack

Step 2. Reconfigure the Oracle Restart service.

#$GRID_HOME/crs/install/roothas.pl

Successfully configured Oracle Grid Infrastructure for a Standalone Server

Step 3. Its time to add ASM back into Oracle Restart. (Run as Grid user)

$srvctl add asm

Step 4. Start the ASM instance using below query.

$ srvctl start asm

The above command will start the ASM service if the server parameter file exists. If failed to restart so don’t worry just make a parameter file and start again.

Read: How to drop the ASM disk group?

Step 5. Recreate the parameter file (/tmp/init+ASM.ora) using below parameters. (As Grid user)

asm_diskgroups='DATA','FRA'
large_pool_size=15M
remote_login_passwordfile='EXCLUSIVE'

Step 6. Login in ASM instance and mout the diskgroups.

$sqlplus / as sysasm

SQL> alter diskgroup DATA mount;

Diskgroup altered.

SQL> create spfile='+DATA' from pfile='/tmp/init+ASM.ora';

File created.

SQL> show parameter spfile

NAME   TYPE   VALUE
------ ------ -------------------------------------------------
spfile string +DATA/asm/asmparameterfile/registry.125.6077451

Step 7. Restart the HAS stack

$ crsctl stop has
$ crsctl start has

Note: Add the database, the listener and other components, back into the Oracle Restart configuration.

Step 8. Add the Database, run bellow commands as ORACLE user.

For 11g

$ srvctl add database -d db_unique_name -o oracle_home

For 12c

$ srvctl add database -db db_unique_name -oraclehome oracle_home

Step 9. Add Listener (run as Grid user)

$ srvctl add listener

I hope you found this article usefull, Thanks for reading. You can subscribe me on YouTube Click Here.

Read: Oracle Database Migration from Non-ASM to ASM

Read the Doc Reference Click here

3 thoughts on “How to Reconfigure Oracle Restart”

  1. Its not *.pl , Its *.sh

    #$GRID_HOME/crs/install/roothas.pl –> is Wring
    #$GRID_HOME/crs/install/roothas.sh –> is correct to Re-configure Oracle Restart

    Reply
    • Hi Harender Singh,

      Thank you for visiting my website.

      I know there are two files roothas.pl & roothas.sh but if you see inside the roothas.sh it is directly run the roothas.pl

      Reply

Leave a Comment

%d bloggers like this:
Enable Notifications    OK No thanks