Creating spfile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Creating spfile

  1. #1
    Join Date
    Mar 2010
    Location
    North Carolina, USA
    Posts
    18

    Creating spfile

    Hi All,

    We are using version 10.2.0.4.0 on Windows here. My question is, if your database is up and running using a pfile, but you would like to create an spfile using the following command:

    create spfile from pfile;

    Can the database be up when you execute that command, or does it have to be shut down?

    Thanks.....

  2. #2
    Join Date
    Jul 2006
    Posts
    195
    It should let you create the file, but in order for it to be used you need to
    shutdown the db and start it up at least that is true on UNIX.

    Once you create the file I would remove the init.ora file so there is not confusion as to which one the DB grabbed during startup.


    Use this query to tell you what is being used:

    SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter WHERE name = 'spfile'

    Good luck

  3. #3
    Join Date
    Mar 2010
    Location
    North Carolina, USA
    Posts
    18
    Thanks!

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478

    Cool

    Quote Originally Posted by BeefStu View Post
    It should let you create the file, but in order for it to be used you need to
    shutdown the db and start it up at least that is true on UNIX.
    It is also true for WinDoze.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  5. #5
    Join Date
    Mar 2010
    Location
    North Carolina, USA
    Posts
    18
    Yep, I created the spfile, bounced the database (it was a test database), and now it is using the spfile.

    Thanks guys!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width