spfile scope

nobleit
nobleit used Ask the Experts™
on
The database was started using pfile for sure..
also I create spfile from pfile..
file created
then what is the meaning of this message..

SQL> alter system set control_files='/u01/app/+DATA/ctf1.dbf' scope=spfile;
alter system set control_files='/u01/app/+DATA/ctf1.dbf' scope=spfile
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup


SQL>

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
See your previous question.

You started with a pfile not an spfile.

Even if you created the spfile from the pfile, you need to startup the database with it.

Bounce the database and use the spfile.
Top Expert 2011

Commented:
- to add from earlier expert, my assumption is you haven't create the spfile.

create spfile from pfile='/pfile location/pfilename.ora';
shutdown immediate;
startup;
show parameter spfile;
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
OP,

See original question "also I create spfile from pfile.."
Top Expert 2011

Commented:
- thanks slightwv. i miss that. slightwv's earlier suggestion in ID 36332521 should corrected the error.
Top Expert 2011

Commented:
- nobleit, slightwv already mention that you need to bounce the database much earlier than my post in ID: 36332521. if you find the steps provided in my suggestion is helpful for you, then i suggest that you split the answer points between ID: 36332521 and ID: 36332555.
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
OP_Zaharin,

If you prefer a split just say so.
Top Expert 2011

Commented:
- i do prefer a split since he accepted mine earlier. i believe the step i provided able to assist him in addition to your suggestion.
Top Expert 2011

Commented:
- noted. thank you for the clarification :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial