-
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.....
-
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
-
-
Originally Posted by BeefStu
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|