RE: Changing the spfile on 9.2.0.3

I think Oracle uses spfile as default when the instance starts. You could probably do something like

1. Shutdown DB
2. Move the spfile to another temp directory
3. Edit your "init.ora"
4. Start DB (which will use init.ora)
5. run CREATE SPFILE FROM PFILE.. command
6. Shutdown DB
7. Start DB again (this time it will use spfile by default)

But my question is why going through this process? I am not using spfile for my 9i DB. I am still using init.ora text file and it works fine.

Hope this helps.

Guang

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Denham Eva Sent: Thursday, November 11, 2004 4:41 AM To: oracle-l_at_freelists.org
Subject: Changing the spfile on 9.2.0.3

Hello Folks

I am trying to "update"/"change" the spfile with the edited init.ora file under pfile in admin.

I start the database startup mount;

Then use the

  CREATE SPFILE FROM PFILE='PATH\TO\INIT\PFILE\INIT.ORA'; But Oracle complains that the spfile is already in use.

Must I use a different name ie change the name of spfile? OR can I update/alter spfile?

OR is there something with the method?

TIA Denham

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 11 2004 - 10:24:20 CST