Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: Shooting yourself in the spfile

RE: Re[2]: Shooting yourself in the spfile

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Thu, 19 Feb 2004 16:20:37 +1100
Message-ID: <001501c3f6a8$1be1fe40$0301470a@au.oracle.com> 





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.



=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_at_freelists.org =


[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala
Sent: Thursday, 19 February 2004 12:51 PM
To: oracle-l_at_freelists.org


Subject: Re: Re[2]: Shooting yourself in the spfile



Yup, you're right! It works!


$ svrmgrl

                                                                         =
      =20
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Feb 18 20:46:21 2004
                                                                         =
      =20
Copyright (c) 1982, 2004, Oracle.  All rights reserved.
                                                                         =
      =20
Connected to an idle instance.
                                                                         =
      =20
SQL> create pfile=3D'/tmp/pete.ora' from spfile;
                                                                         =
      =20
File created.
                                                                         =
      =20




SQL>


But the result is less then encouraging:
SQL> Disconnected


$ less /tmp/pete.ora


10g.__db_cache_size=3D176160768
10g.__java_pool_size=3D4194304
10g.__large_pool_size=3D4194304
10g.__shared_pool_size=3D79691776




*.background_dump_dest=3D'/oracle/product/10g/admin/oracle/bdump'

*.compatible=3D'10.1.0.2.0'

*.control_files=3D'/oradata/10g/oracle/control01.ctl','/oradata/10g/oracl=

e/control02.ctl','/oradata/10g/oracle/control03.ctl'


*.core_dump_dest=3D'/oracle/product/10g/admin/oracle/cdump'

*.db_block_size=3D8192

*.db_domain=3D''

*.db_file_multiblock_read_count=3D16

*.db_name=3D'oracle'

*.db_recovery_file_dest=3D'/oradata/10g/flash'

*.db_recovery_file_dest_size=3D8589934592

*.dispatchers=3D'(protocol=3DTCP)(disp=3D1)'

*.filesystemio_options=3D'ASYNCH'

*.job_queue_processes=3D10

*.max_dispatchers=3D4

*.max_shared_servers=3D10





This doesn't look very much like your friendly neighborhood
init.ora that I'm used to since version 4, but it works.
$ svrmgrl

                                                                         =
      =20
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Feb 18 20:50:00 2004
                                                                         =
      =20
Copyright (c) 1982, 2004, Oracle.  All rights reserved.
                                                                         =
      =20
Connected to an idle instance.
                                                                         =
      =20




SQL> startup pfile=3D/tmp/pete.ora


ORACLE instance started.


=20


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 =3D
> instance running to be able to issue either the create pfile or create =
=3D

> spfile commands.
>=20
> =3D20
> Pete
> =3D20
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
> =3D20
> "Oh no, it's not.  It's much harder than that!"
> Bruce Pihlamae, long-term Oracle DBA
>=20
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org =3D
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jonathan Gennick
> Sent: Thursday, 19 February 2004 12:21 PM
> To: Alexander.Feinstein_at_mitchell1.com
> Subject: Re[2]: Shooting yourself in the spfile
>=20
>=20
> Wednesday, February 18, 2004, 8:00:29 PM, =3D
> Alexander.Feinstein_at_mitchell1.com (Alexander.Feinstein_at_mitchell1.com) =


=3D

> wrote:
> AFmc> With spfile one can use followin steps:
> AFmc> 1. sqlplus /nolog
> 2. SQL>> create pfile=3D3D'/tmp/pfile' from =


spfile=3D3D'?/dbs/spfileSID.ora'


> 3. SQL>> host vi /tmp/pfile


> 4. SQL>> create spfile=3D3D'?/dbs/spfileSID.ora' from =
pfile=3D3D'/tmp/pfile'

> 5. SQL>> host rm /tmp/pfile
> 6. SQL>> startup
>=20
> 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.
>=20
> Best regards,
>=20
> Jonathan Gennick --- Brighten the corner where you are
> http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com
>=20
> Join the Oracle-article list and receive one
> article on Oracle technologies per month by=3D20
> email. To join, visit =3D
> http://four.pairlist.net/mailman/listinfo/oracle-article,=3D20
> or send email to Oracle-article-request_at_gennick.com and=3D20
> include the word "subscribe" in either the subject or body.
>=20
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request_at_freelists.org
> 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
> -----------------------------------------------------------------
>=20
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request_at_freelists.org
> 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
> -----------------------------------------------------------------
>=20





--=20


Mladen Gogala


Oracle DBA




Please see the official ORACLE-L FAQ: http://www.orafaq.com




To unsubscribe send email to:  oracle-l-request_at_freelists.org
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_at_freelists.org
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
-----------------------------------------------------------------


Received on Wed Feb 18 2004 - 23:20:37 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US