Recreating the spfile on ASM from pfile
1/26/2012 05:23:00 PM
Gönderen Mete Karar
You may face with one of the errors below or such while you are starting your database, probably after you alter some parameters' values and restart.
- ORA-15124 : ASM file name '...' contains an invalid alias name
- ORA-01078 : Failure in processing system parameters
1. Logon to your server as Oracle owner, such as oracle
2. Get the spfile from ASM:
SQL> CREATE PFILE FROM SPFILE='+DATA/<DBID>/spfile<DBID>.ora;
File is saved as /u01/app/oracle/product/11.2.0/dbhome_1/dbs/init<DBID>.ora over pfile by default.
Alternatively you can specify the output file by giving pfile='/tmp/pfile.ora' option to the statement above. If you don't, it's better backup your original pfile.
3. Change what is wrong in the pfile with your favorite text editor
Note: If there is, remove the line "spfile='+DATA/<DBID>/spfile<DBID>.ora'" at the end of the file. If you don't, Oracle read the spfile in ASM as it's set in that line.
4. Create a new spfile from the pfile you have just edited:
SQL> STARTUP MOUNT PFILE='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/init<DBID>.ora';
SQL> CREATE SPFILE='+DATA/<DBID>/spfile<DBID>.ora' FROM PFILE;
ASMCMD> cd +DATA/<DBID>
ASMCMD> ls -l spfile*
SQL> SHUTDOWN IMMEDIATE;
7. Change the pfile back to its original state by restoring pfile backup you got in step 2 or create a new one. Its contents should be like:
spfile=’+DATA/<DBID>/spfile<DBID>.ora’
(Backup the new pfile you created first, just in case)
8. Start your database
If it's a RAC:
$ srvctl start database -d <DBID>
Otherwise:
SQL> STARTUP
9. See that the spfile being used is the one in the ASM:
SQL> SHOW PARAMETER spfile;
That's all...
This entry was posted on October 4, 2009 at 12:14 pm, and is filed under
Oracle
. Follow any responses to this post through RSS. You can leave a response, or trackback from your own site.
Subscribe to:
Post Comments (Atom)
31/10/18 21:32
judi sabung ayam