Skip to Content
avatar image
Former Member

ORA-32002: cannot create SPFILE already being used by the instance

Hi,

i have changed database parameters. after that i create spfile in oracle using " CREATE SPFILE FROM PFILE", it is giving following error.

ORA-32002: cannot create SPFILE already being used by the instance.

please suggest me to change database parameters.

thanks & regards

Ramesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 31, 2009 at 12:15 PM

    Hi ,

    It says that your instance is already running via spfile .To change parameters this is always recomomnded to change it in pfile after generating it via command ::

    create pfile from spfile ;

    Now change the parameter in pfile crated & after changing the parameter you need to again change this file to spfile via command::

    create pfile from spfile ;

    Or another method to change the parameter directly via command prompt as said by previous thread .

    Hope this should solve your issue.

    Thanks..

    Mohit

    Edited by: mohit gupta on Aug 31, 2009 2:15 PM

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 31, 2009 at 11:40 AM

    Hello Ramesh,

    > please suggest me to change database parameters.

    with the SQL command "ALTER SYSTEM SET" ... it is explained very well in sapnote #601157

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 31, 2009 at 04:19 PM

    Is your database running?

    You changed in PFILE? Then shutdown the database, then use the commad which you were using.

    For safety, have a backup of your SPFILE.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Lokesh,

      You have altered parameters when DB was online. At that time have you provided SCOPE of that change, by default it will be BOTH, i.e. MEMORY and SPFILE.

      If your DB is already using SPFILE, then DB restart will do.

      In your case you can try following.

      1. Check if your system is using SPFILE or not (use the V$SPPARAMETER view to check if you are using a PFILE or not)

      2. If using SPFILE, then create PFILE from spfile, while creating PFILE, specify location where you want that file to be present as you will be using this PFILE to check parameters.

      3. Open PFILE in notepad and check the parameters which you have changed are reflected or not.

      4. If not then alter those parameters in PFILE.

      5. Take backup of current SPFILE (This is Must)

      6. Create SPFILE from PFILE you have altered.

      7. Start DB

      8. Or other wise you can start DB with PFILE also by specifying PFILE at startup.

      Regards,

      Abhay

  • Sep 01, 2009 at 12:18 PM

    Lokesh Krishna = Ramesh Sammiti ?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear all,

      thanks for your valuable suggessions and quick reply for my question.

      finally i changed the database parameters with this message.

      thanks......................................................................

      regards

      ramesh

  • avatar image
    Former Member
    Sep 01, 2009 at 02:27 PM

    i got quick reply for change the DB parameters

    Add comment
    10|10000 characters needed characters exceeded