Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help ORACLE 9i spfile and pfile
Try create spfile from pfile;
Regards, Ranko
aprinsloo_at_sagetelecom.net wrote:
> 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.
>
> 1. Therefore you need to first export the SPFILE content to a PFILE
> which
> will necessarily be an ASCII text file:
>
> 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 Sat Oct 28 2006 - 09:23:54 CDT
![]() |
![]() |