change the path of control file

1.create a text based file for spfile

SQL> create spfile from pfile=’f:initAAA.ora’;

file created.

2.edit the flat file just created in the path of control file

3.start the database using pfile just created and recreate a new spfile
SQL> startup
Total System Global Area 612368384 bytes
Fixed Size 1304728 bytes
Variable Size 167774056 bytes
Database Buffers 436207616 bytes
Redo Buffers 7081984 bytes

SQL> show parameter spfile;

NAME TYPE
———————————— ————-
VALUE
——————————
spfile string
C:ORACLEPRODUCT10.2.0DB_1
DATABASESPFILEAAA.ORA