Creating spfile

[oraclegirl]

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.....

[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.

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

[oraclegirl]

Thanks!

[LKBrwn_DBA]

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.

[oraclegirl]

Yep, I created the spfile, bounced the database (it was a test database), and now it is using the spfile.

Thanks guys!