RE: Changing the spfile on 9.2.0.3

From: Leonard, George <GLeonard_at_wesbank.co.za>
Date: Thu, 11 Nov 2004 12:07:29 +0200
Message-ID: <1831A554E8800049B6B970790D2513C001C35D4D@fnbkrkmx01.fnb.co.za>

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
Oracle Database Administrator
New Dawn Technologies @ Wesbank
E-mail:gleonard_at_wesbank.co.za
=20
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! =20

-----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

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

>=20

> I start the database startup mount;

>=20

> Then use the

>=20

> CREATE SPFILE FROM PFILE=3D'PATH\TO\INIT\PFILE\INIT.ORA';

>=20

> But Oracle complains that the spfile is already in use.

>=20

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

>=20

> OR is there something with the method?

>=20

> TIA

>=20

> Denham

>=20

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

--
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-l

Received on Thu Nov 11 2004 - 04:03:34 CST