Shooting yourself in the spfile 2004-02-19 - By Pete Sharman
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
10g.__db_cache_size=176160768
10g.__java_pool_size=4194304
10g.__large_pool_size=4194304
10g.__shared_pool_size=79691776
*.background_dump_dest= '/oracle/product/10g/admin/oracle/bdump '
*.compatible= '10.1.0.2.0 '
*.control_files= '/oradata/10g/oracle/control01.ctl ', '/oradata/10g/oracle/control02.ctl ', '/oradata/10g/oracle/control03.ctl '
*.core_dump_dest= '/oracle/product/10g/admin/oracle/cdump '
*.db_block_size=8192
*.db_domain= ' '
*.db_file_multiblock_read_count=16
*.db_name= 'oracle '
*.db_recovery_file_dest= '/oradata/10g/flash '
*.db_recovery_file_dest_size=8589934592
*.dispatchers= '(protocol=TCP)(disp=1) '
*.filesystemio_options= 'ASYNCH '
*.job_queue_processes=10
*.max_dispatchers=4
*.max_shared_servers=10
This doesn 't look very much like your friendly neighborhood
init.ora that I 'm used to since version 4, but it works.
$ svrmgrl
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Feb 18 20:50:00 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to an idle instance.
SQL > startup pfile=/tmp/pete.ora
ORACLE instance started.
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
