OraFAQ Forum: Server Administration » Error creating spfile from pfile

Home » RDBMS Server » Server Administration » Error creating spfile from pfile

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

Error creating spfile from pfile [message #315959]

Wed, 23 April 2008 06:14

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

Oralce 10.2.0.3.0
Redhat AS 4

My DB instance is Up with pfile='/u01/app/oracle/initprimary1.ora' ,now i want to create spfile from this pfile and start the instance with spfile but when i try to create the spfile

SQL>  create spfile from pfile='/u01/app/oracle/initprimary1.ora';
create spfile from pfile='/u01/app/oracle/initprimary1.ora'
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kspsetpao1], [1234], [1201], [*],
[STANDBY_FILE_MANAGEMENT], [4], [], []

Please suggest!

Report message to a moderator

Re: Error creating spfile from pfile [message #315974 is a reply to message #315959]

Wed, 23 April 2008 06:49

Georgi
Messages: 2
Registered: April 2008

Junior Member

Hi,

Check the value for the parameter STANDBY_FILE_MANAGEMENT - is it with single quotas - 'AUTO' or 'MANUAL'.
The value in pfile should be (AUTO or MANUAL)

*.standby_file_management='AUTO'

If it is OK, check user_dump_dest - is it correctly defined and accesible. Also, check log_file_name_convert.

Regards

Report message to a moderator

Re: Error creating spfile from pfile [message #315979 is a reply to message #315959]

Wed, 23 April 2008 06:54

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Also check if all entries in init.ora is of valid syntax.

Regards
Michel

Report message to a moderator

Re: Error creating spfile from pfile [message #316010 is a reply to message #315959]

Wed, 23 April 2008 08:46

dzt52r
Messages: 19
Registered: July 2007
Location: PA

Junior Member

is this reallly the command you ran. It isn't correct.

create spfile '/spfile_file_name'
from pfile '/pfile_file_name' ;

Report message to a moderator

Re: Error creating spfile from pfile [message #316020 is a reply to message #316010]

Wed, 23 April 2008 09:04

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What's wrong with the command?
It is perfectly correct (as long as default spfile is not in use).

Regards
Michel

Report message to a moderator

Previous Topic:	Data movement from one partition to another
Next Topic:	Creating Trigger to prevent dropping/truncating tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 21:32:02 CST 2024