Home » RDBMS Server » Server Administration » Error creating spfile from pfile
Error creating spfile from pfile [message #315959] Wed, 23 April 2008 06:14 Go to next message
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!
Re: Error creating spfile from pfile [message #315974 is a reply to message #315959] Wed, 23 April 2008 06:49 Go to previous messageGo to next message
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
Re: Error creating spfile from pfile [message #315979 is a reply to message #315959] Wed, 23 April 2008 06:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also check if all entries in init.ora is of valid syntax.

Regards
Michel
Re: Error creating spfile from pfile [message #316010 is a reply to message #315959] Wed, 23 April 2008 08:46 Go to previous messageGo to next message
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' ;
Re: Error creating spfile from pfile [message #316020 is a reply to message #316010] Wed, 23 April 2008 09:04 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Data movement from one partition to another
Next Topic: Creating Trigger to prevent dropping/truncating tables
Goto Forum:
  


Current Time: Sun Dec 04 08:34:09 CST 2016

Total time taken to generate the page: 0.07357 seconds