RE: Changing the spfile on 9.2.0.3
- From: "Leonard, George" <GLeonard@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Nov 2004 12:07:29 +0200
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
Oracle Database Administrator
New Dawn Technologies @ Wesbank
E-mail:gleonard@xxxxxxxxxxxxx
=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@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> =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@xxxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
--
//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 ________________________________
--
//www.freelists.org/webpage/oracle-l
Other related posts:
