oracle rac spfile change attention

the customer will meet this kind of situation to change the path of spfile in a rac environment, such as you need to change the old disk array or something else,just pay attention when execute the implementation.

you know there are something more to consider about when you operate in a rac environment comparing with single instance.It’s better to use “srvctl” tool to do operations,as many configuration was recorded in OCR, the sqlplus will take no effect on it,u need to use srvctl tools.

for example:

you want toe change the path of spfile for each nodes,it’s better to do following behind:

//to show the path registered in OCR

[oracle@rac1 ~]$ srvctl config database -d rac -a
rac1 rac1 /opt/app/oracle/product/10.2.0/db_1
rac2 rac2 /opt/app/oracle/product/10.2.0/db_1
DB_UNIQUE_NAME: rac
DB_NAME: null
ORACLE_HOME: /opt/app/oracle/product/10.2.0/db_1
SPFILE: /opt/app/oradata/rac/spfile.dbf
DOMAIN: world
DB_ROLE: null
START_OPTIONS: null
POLICY: AUTOMATIC
ENABLE FLAG: DB ENABLED

——————————————————————-

do confirm the correctness of the path in ocr and the exact configuration in your envrionments.

or use following cmd to make a change

[oracle@rac1 ~]$ srvctl modify database -d rac -p ‘$pathOfSpfile’

 

if you don’t……the node can not be bring up normally and u will receive  errors 

CRSAPP][2592017296]0StartResource error for ora.ora10.ora101.inst error code = 1
[  CRSRES][2592017296]0Start of `ora.ora10.ora101.inst` on member `node1` failed.
[  CRSRES][2592017296]0node2 : CRS-1019: Resource ora.ora10.ora101.inst (application) cannot run on node2

[  CRSRES][2623486864]0Start of `ora.ora10.ora102.inst` on member `node2` failed.
[  CRSRES][2623486864]0node1 : CRS-1019: Resource ora.ora10.ora102.inst (application) cannot run on node1

[  CRSAPP][2633976720]0StartResource error for ora.ora10.db error code = 1
[  CRSRES][2633976720]0Start of `ora.ora10.db` on member `node1` failed.
[  CRSRES][2633976720]0Attempting to start `ora.ora10.db` on member `node2`
[  CRSRES][2675936144]0startRunnable: setting CLI values