DanBrother的部落格

Change SPFILE location to ASM:

[oracle@RAC1 ~]$ srvctl config database -d TESTDB
Database unique name: TESTDB
Database name: TESTDB
Oracle home: /oracle/db11gr2
Oracle user: oracle
Spfile: +DATA/TESTDB/spfileTESTDB.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: TESTDB
Database instances: TESTDB1,TESTDB2
Disk Groups: DATA,ARCH
Mount point paths:
Services:
Type: RAC
Database is administrator managed

# sqlplus / as sysdba
SQL> sho parameter spfile

NAME                                 TYPE                 VALUE
------------------------------------ -------------------- ------------------------------
spfile                               string               /oracle/db11gr2/dbs/spfileTESTDB1.ora

SQL> create pfile from spfile;
SQL> exit

srvctl stop instance -d TESTDB -i TESTDB1
rm /oracle/db11gr2/dbs/spfileTESTDB1.ora
srvctl start instance -d TESTDB -i TESTDB1

TESTDB/TESTDB1/> sho parameter spfile

NAME                                 TYPE                 VALUE
------------------------------------ -------------------- ------------------------------
spfile                               string               +DATA/TESTDB/spfileTESTDB.ora