Home » RDBMS Server » Server Administration » issue creating pfile from spfile (10.2.0.3 running on AIX 5.3)
issue creating pfile from spfile [message #349066] Thu, 18 September 2008 15:24 Go to next message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
Hi all,

I'm having the following error trying to create a pfile from my spfile which was used to start the database:

SQL> create pfile='/medstat/advantage/advprod/db_home/ddl_templates/initmedstat.ora' from spfile='/medstat/advantage/common/app/oracle/product/10.2.0.2/dbs/spfileadvprod.ora'
2 /
create pfile='/medstat/advantage/advprod/db_home/ddl_templates/initmedstat.ora' from spfile='/medstat/advantage/common/app/oracle/product/10.2.0.2/dbs/spfileadvprod.ora'
*
ERROR at line 1:
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
Additional information: 2541
Additional information: 512


Can someone help me with this?

Thanks,

divroro12
Re: issue creating pfile from spfile [message #349070 is a reply to message #349066] Thu, 18 September 2008 15:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
most probably your spfile is corrupt.
did you ever manually edit the spfile?
Re: issue creating pfile from spfile [message #349073 is a reply to message #349066] Thu, 18 September 2008 15:42 Go to previous messageGo to next message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
Yes, i did...
Re: issue creating pfile from spfile [message #349087 is a reply to message #349073] Thu, 18 September 2008 18:58 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You can not manually edit a spfile, it is a binary file. At this point, if you don't have a backup of the spfile or you don't have a pfile to use, you can open the spfile and copy all the text and save it to another text file. Then you can start the database using:

SQL> startup pfile='<new_text_file>'

You can recreate a spfile at this point by using:

SQL> create spfile from pfile='<new_text_file>';
Re: issue creating pfile from spfile [message #349653 is a reply to message #349066] Mon, 22 September 2008 09:11 Go to previous message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
thank you all for your contributions. I did have a backup pfile from which i recreated the spfile, & all is now perfect.

Regards,

divroro12
Previous Topic: Moving Cluster to another Tablespace
Next Topic: Database Jobs getting halted.
Goto Forum:
  


Current Time: Thu Dec 08 21:54:07 CST 2016

Total time taken to generate the page: 0.06265 seconds