Oracle RAC does not start Fault Handling from SPfile

One instance of RAC is found to be abnormal. view the spfile

SQL> show parameter spfile

NAME TYPE VALUE

-----------------------------------------------------------------------------

Spfile string

The result value does not contain spfile and is not started from spfile. view the pfile file under dbs and find that the Pfile content of the instance has been changed.

Instance 2

SQL> show parameter spfile

NAME TYPE VALUE

-----------------------------------------------------------------------------

Spfile string/dev/spfilegis. ora

 

Database parameter files include spfile and pfile. The RAC parameter file is special. By default, RAC spfiles are stored on shared devices (RAW devices or ASM disk groups ). The pfile file of each node only records the position of the spfile.

Solution

1. Back up the pfile file under dbs

Cp initgis1.ora initgis. ora. bak

2. Stop instance gis1

Sqlplus> shutdown immediate

3. Edit initgis1.ora in vi

Spfile =/dev/spfilegis. ora

Save and exit

4. Start instance 1

Sqlplus> startup

5. Check that SGA is normal.