Error creating spfile from pfile [message #315959] |
Wed, 23 April 2008 06:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
|