Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
=20________________________________________________George Leonard
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Sharples
Sent: 11 November 2004 11:43 AM
To: oracle-l_at_freelists.org
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> =3D <value> scope =3D spfile;
Dont have to keep creating a new one
On Thu, 11 Nov 2004 11:40:55 +0200, Denham Eva <evad_at_tfmc.co.za> wrote:
> Hello Folks
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
-- http://www.freelists.org/webpage/oracle-l _________________________________________________________________________= __________________________ The views expressed in this email are, unless otherwise stated, those of = the author and not those of the FirstRand Banking Group an Authorised Financial Service Provider o= r its management. The information in this e-mail is confidential and is intended solely for= =20the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribut= ion or any action taken or=20 omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrit= y of information and data=20 transmitted electronically and to preserve the confidentiality thereof, n= o liability or=20 responsibility whatsoever is accepted if information or data is, for what= ever reason, corrupted=20 or does not reach its intended destination. =20 ________________________________ -- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 11 2004 - 04:03:34 CST