svrmgrl???
wasn't that supposed to be long gone?
- Mladen Gogala <mgogala_at_adelphia.net> wrote:
> 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_at_freelists.org =
> > [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
> >
> >
> > Wednesday, February 18, 2004, 8:00:29 PM, =
> > Alexander.Feinstein_at_mitchell1.com
> (Alexander.Feinstein_at_mitchell1.com) =
> > 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@gennick.com
> >
> > 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_at_gennick.com 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_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
> > -----------------------------------------------------------------
> >
>
> --
> 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
> -----------------------------------------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
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 - 20:38:17 CST