Mladen, Mladen, Mladen, have you ever known me to be wrong? :)
The syntax is just the 9i version - works perfectly well as you 've seen for either a pfile or spfile with 9i. * (in case you didn 't know) simply means all instances in a RAC environment.
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@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Mladen Gogala
Sent: Thursday, 19 February 2004 12:51 PM
To: oracle-l@(protected)
Subject: Re: Re[2]: Shooting yourself in the spfile
Yup, you 're right! It works!
$ svrmgrl
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Feb 18 20:46:21 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to an idle instance.
SQL > create pfile= '/tmp/pete.ora ' from spfile;
File created.
SQL >
But the result is less then encouraging:
SQL > Disconnected
$ less /tmp/pete.ora
Total System Global Area 268435456 bytes
Fixed Size 778416 bytes
Variable Size 91234128 bytes
Database Buffers 176160768 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
SQL >
On 02/18/2004 08:41:09 PM, Pete Sharman wrote:
> Well, that 's the whole point isn 't it? You don 't NEED to have the =
> instance running to be able to issue either the create pfile or create =
> spfile commands.
>
> =20
> Pete
> =20
> "Controlling developers is like herding cats. "
> Kevin Loney, Oracle DBA Handbook
> =20
> "Oh no, it 's not. It 's much harder than that! "
> Bruce Pihlamae, long-term Oracle DBA
>
> -- --Original Message-- --
> From: oracle-l-bounce@(protected) =
> [mailto:oracle-l-bounce@(protected)] On Behalf Of Jonathan Gennick
> Sent: Thursday, 19 February 2004 12:21 PM
> To: Alexander.Feinstein@(protected)
> Subject: Re[2]: Shooting yourself in the spfile
>
>
> Wednesday, February 18, 2004, 8:00:29 PM, =
> Alexander.Feinstein@(protected) (Alexander.Feinstein@(protected)) =
> wrote:
> AFmc > With spfile one can use followin steps:
> AFmc > 1. sqlplus /nolog
> 2. SQL > > create pfile=3D '/tmp/pfile ' from spfile=3D '?/dbs/spfileSID.ora '
> 3. SQL > > host vi /tmp/pfile
> 4. SQL > > create spfile=3D '?/dbs/spfileSID.ora ' from pfile=3D '/tmp/pfile '
> 5. SQL > > host rm /tmp/pfile
> 6. SQL > > startup
>
> In my case, I couldn 't start my instance at all, so I
> wouldn 't have been able to issue the create pfile command in
> step 2.
>
> Best regards,
>
> Jonathan Gennick --- Brighten the corner where you are
> http://Gennick.com * 906.387.1698 * mailto:jonathan@(protected)
>
> Join the Oracle-article list and receive one
> article on Oracle technologies per month by=20
> email. To join, visit =
> http://four.pairlist.net/mailman/listinfo/oracle-article,=20
> or send email to Oracle-article-request@(protected) and=20
> include the word "subscribe " in either the subject or body.
>
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> To unsubscribe send email to: oracle-l-request@(protected)
> put 'unsubscribe ' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
>
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> To unsubscribe send email to: oracle-l-request@(protected)
> put 'unsubscribe ' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
>
--
Mladen Gogala
Oracle DBA
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
