RE: Changing the spfile on 9.2.0.3

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Fri, 12 Nov 2004 09:15:45 -0500
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6501CC9AF9@25exch1.vicorpower.vicr.com>

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_at_wesbank.co.za]=20 Sent: Thursday, November 11, 2004 5:07 AM To: oracle-l_at_freelists.org
Subject: RE: Changing the spfile on 9.2.0.3

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_at_wesbank.co.za
=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_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> =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_at_tfmc.co.za> 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

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

--
http://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                              ________________________________
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 12 2004 - 08:11:41 CST