OraFAQ Forum: Server Administration » issue creating pfile from spfile

Home » RDBMS Server » Server Administration » issue creating pfile from spfile (10.2.0.3 running on AIX 5.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

issue creating pfile from spfile [message #349066]

Thu, 18 September 2008 15:24

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

Report message to a moderator

Re: issue creating pfile from spfile [message #349070 is a reply to message #349066]

Thu, 18 September 2008 15:29

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

most probably your spfile is corrupt.
did you ever manually edit the spfile?

Report message to a moderator

Re: issue creating pfile from spfile [message #349073 is a reply to message #349066]

Thu, 18 September 2008 15:42

divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA

Senior Member

Yes, i did...

Report message to a moderator

Re: issue creating pfile from spfile [message #349087 is a reply to message #349073]

Thu, 18 September 2008 18:58

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>';

Report message to a moderator

Re: issue creating pfile from spfile [message #349653 is a reply to message #349066]

Mon, 22 September 2008 09:11

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 19:22:50 CST 2024