Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help ORACLE 9i spfile and pfile

Help ORACLE 9i spfile and pfile

From: <aprinsloo_at_sagetelecom.net>
Date: 27 Oct 2006 16:56:55 -0700
Message-ID: <1161993415.278069.11430@m73g2000cwd.googlegroups.com>


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 Fri Oct 27 2006 - 18:56:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US