Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Help ORACLE 9i spfile and pfile
Hi,
I modified the spfile using the Oracle metalink approach below.
When I run the last step:
SQL> create spfile='spfilecab3.ora' from pfile='pfilecab3.ora' ;
create spfile='spfilecab3.ora' from pfile='pfilecab3.ora'
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [908], [], [], [], [], [],
[], []
I get the error above, what do I need to do, nothing is reported in the alert.log.
Thx in advance.
>From metalink:
B. Use the export method.
SQL> create pfile='initDB1test.ora' from spfile; File created. The initDB1test.ora is created in directory $ORACLE_HOME/dbs. Name the SPFILE used: * If the instance directly used an spfile, the spfile is named spfileSID.ora * If the instance used an spfile through an init.ora, its name is defined in the init.ora in SPFILE=spfileSID.ora. In this case, you would use the following SQL command: SQL> create pfile='initDB1test.ora' from spfile='spfileDB1.ora'; File created.
2. You modify the PFILE 'initDB1test.ora' parameter values:
You want to change the UNDO_MANAGEMENT value from AUTO to MANUAL:
change the value in the PFILE 'initDB1test.ora'.
3. Recreate the SPFILE from the modified PFILE 'initDB1test.ora':
Be aware that if the spfile to be recreated has the same name as the one
used at startup, you will get the following error even if you used PFILE
at startup :
SQL> create spfile='spfileDB1.ora' from pfile='initDB1test.ora'; ORA-32002 cannot create SPFILE already being used by the instance Recreate the spfile with a different name than the one used at startup: for example "spfileDB1NEW.ora" : SQL> create spfile='spfileDB1NEW.ora' from pfile='initDB1test.ora'; File created.Received on Fri Oct 27 2006 - 18:56:55 CDT
![]() |
![]() |