RE: 9i poll on spfile feature

Pete,

I bet that's it.  I would only do an "alter system", leaving out the "scope"
part.  So the changes were made in memory only.  And actually, we did the
changes with OEM - which does not give you an option for "scope" (maybe
unless the database was started with the spfile).

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Pete Sharman [mailto:peter.sharman@xxxxxxxxxx] 
Sent: Friday, September 24, 2004 2:14 PM
To: DGoulet@xxxxxxxx; Mercadante, Thomas F; oracle-l@xxxxxxxxxxxxx
Cc: Peter Ross Sharman
Subject: RE: 9i poll on spfile feature


That's because you tried to do an ALTER SYSTEM ... SCOPE=BOTH or
SCOPE=SPFILE.  To do either of those you needed to start up with an SPFILE,
IIRC.

 
Pete
 
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
 
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Goulet, Dick
Sent: Saturday, 25 September 2004 3:43 AM
To: Mercadante, Thomas F; oracle-l@xxxxxxxxxxxxx
Subject: RE: 9i poll on spfile feature

Tom,

        That's odd because I tried that on an instance that I had started
from = a pfile(by mistake) & it yacked saying an spfile had not been used at
= startup.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante@xxxxxxxxxxxxxxxxx]
Sent: Friday, September 24, 2004 1:40 PM
To: Goulet, Dick; oracle-l@xxxxxxxxxxxxx
Subject: RE: 9i poll on spfile feature


Dick,

Sure I can.  I can alter any SGA param on the fly wether I have an = spfile
or not.  The "alter system" commands work just fine.

I think I'm missing your point.

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Goulet, Dick [mailto:DGoulet@xxxxxxxx]=20
Sent: Friday, September 24, 2004 1:32 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: 9i poll on spfile feature


Tom,

        If you rely soly on a PFILE, no you can't unless you restart the =3D
instance which is a pretty hard thing to do in the middle of the day, = =3D
especially when there are robots that are your clients.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante@xxxxxxxxxxxxxxxxx]
Sent: Friday, September 24, 2004 1:21 PM
To: Goulet, Dick; BSpears@xxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: 9i poll on spfile feature


Dick,

What do you mean you can't modify system params?  I can modify any =3D =
system param on the fly.  I just have to also to update the init.ora file.

Again, I'm not losing any functionality.  And the number of times I =3D =
modify the init.ora params I can count on one hand every three months.

I also added a database shutdown trigger to issue an "alter database =3D
backup controlfile to trace" in all my databases.

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Goulet, Dick [mailto:DGoulet@xxxxxxxx]=3D20
Sent: Friday, September 24, 2004 1:11 PM
To: BSpears@xxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: 9i poll on spfile feature


Well, I'll disagree with Rachel.  True having an INIT file is not =3D3D
currently broke, but without it you can't modify system parameters, like =
=3D =3D3D shared_pool_size on the fly.  So yes I have migrated to them, of =
course =3D =3D3D I'va also added "create pfile=3D3D3D<name> from spfile" to
my = shutdown =3D3D =3D script, along with "alter database backup
controlfile to = trace".

Save that there bacon, it's mine!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Spears, Brian [mailto:BSpears@xxxxxxxxxxxxxxxxx]
Sent: Friday, September 24, 2004 11:17 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 9i poll on spfile feature



 Just wanted to see what people have resorted to using in real world
practice with the spfile.

 With 9i, are you still using the init file  or have you migrated to = =3D3D
=3D using the spfile ?

If still using the Init file.. What is the main reason for continuing to
using the init file.

Brian

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

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

Other related posts: