Home » RDBMS Server » Server Administration » Issue with the ALTER SYSTEM command
Issue with the ALTER SYSTEM command [message #206761] Fri, 01 December 2006 06:55 Go to next message
sreehari
Messages: 101
Registered: May 2006
Senior Member
Hi all

I have created a new database and when i try to give the following command....

alter system set open_cursors=400 scope=spfile;

i am getting the below error message..

ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup


can some one tell me why i am getting the above error..

Thanks


Re: Issue with the ALTER SYSTEM command [message #206763 is a reply to message #206761] Fri, 01 December 2006 06:58 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup

Self explanative.
You have used a pfile to start the database.
But asking oracle to write to spfile.
Re: Issue with the ALTER SYSTEM command [message #206768 is a reply to message #206763] Fri, 01 December 2006 07:12 Go to previous messageGo to next message
sreehari
Messages: 101
Registered: May 2006
Senior Member
Thanks Mahesh

But how to know which file is being used by the oracle isntance..

The DBS folder contain the following files..

SPFILEORCL.ora ( Is this not an SPFILE..?)
initdw.ora

Please bare me if they are fundamental questions since i am still learning administration

Thanks

Re: Issue with the ALTER SYSTEM command [message #206773 is a reply to message #206768] Fri, 01 December 2006 07:21 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just Search~!.
Most of the questions asked here are already answered in form or other.
http://www.orafaq.com/forum/m/194067/42800/?srch=show+parameter+spfile#msg_194048
Regards
Previous Topic: Dropping Tablespace and datafiles
Next Topic: crontab failure
Goto Forum:
  


Current Time: Sat Dec 03 05:47:08 CST 2016

Total time taken to generate the page: 0.06611 seconds