Leonard is correct. Startup with "Startup pfile=3D'<your new = init.ora>'" then you can create the spfile & restart using that file.=20 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: Leonard, George [mailto:GLeonard@xxxxxxxxxxxxx]=20 Sent: Thursday, November 11, 2004 5:07 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Changing the spfile on 9.2.0.3 Hi You can create a spfile even if it already exist, the problem is the database is probably started using that file at the moment so the file is locked. To re-create over the same file the database needs to be shut down, otherwise to make changes use the alter system command. George =3D20________________________________________________ George Leonard Oracle Database Administrator New Dawn Technologies @ Wesbank E-mail:gleonard@xxxxxxxxxxxxx =3D20 You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! =3D20 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Sharples Sent: 11 November 2004 11:43 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Changing the spfile on 9.2.0.3 If you already have an spfile you cant create another one. You can delete the old one of you wish and re-create it like that. If you didnt know you can change any parameters with alter system set <parameter> =3D3D <value> scope =3D3D spfile; Dont have to keep creating a new one On Thu, 11 Nov 2004 11:40:55 +0200, Denham Eva <evad@xxxxxxxxxx> wrote: > Hello Folks >=3D20 > I am trying to "update"/"change" the spfile with the edited init.ora > file under pfile in admin. >=3D20 > I start the database startup mount; >=3D20 > Then use the >=3D20 > CREATE SPFILE FROM PFILE=3D3D'PATH\TO\INIT\PFILE\INIT.ORA'; >=3D20 > But Oracle complains that the spfile is already in use. >=3D20 > Must I use a different name ie change the name of spfile? OR can I > update/alter spfile? >=3D20 > OR is there something with the method? >=3D20 > TIA >=3D20 > Denham >=3D20 > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l ________________________________________________________________________ _=3D __________________________ The views expressed in this email are, unless otherwise stated, those of =3D the author and not those of the FirstRand Banking Group an Authorised Financial Service Provider o=3D r its management. The information in this e-mail is confidential and is intended solely for=3D =3D20the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribut=3D ion or any action taken or=3D20 omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrit=3D y of information and data=3D20 transmitted electronically and to preserve the confidentiality thereof, n=3D o liability or=3D20 responsibility whatsoever is accepted if information or data is, for what=3D ever reason, corrupted=3D20 or does not reach its intended destination. =3D20 ________________________________ -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l