SEO

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.

Try create spfile from pfile;

Regards, Ranko
aprinsloo@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.

Try create spfile from pfile;

Regards, Ranko
aprinsloo@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.