RE: sigh

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Thu, 4 Nov 2004 14:18:18 -0700
Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B439040@fiji.arraybp.com>

1. $ strings spfilexxxx > initsid.ora
2. vi initsid.ora # make your changes
3. sqlplus /nolog
4. SQL> connect / as sysdba
5. SQL> create spfile=3D'spfilexxxx' from pfile=3D'initsid.ora';
6. SQL> startup

   ---

Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of aj wells Sent: Thursday, November 04, 2004 2:15 PM To: oracle-l_at_freelists.org
Subject: sigh

okay.. I'm a dumb @$$

I need to restart a down database that is on linux with an spfile parameter that sets db_32k_cache_size...

how do I get rid of/reset that parameter and bring up the database?
--

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

This electronic message transmission is a PRIVATE communication which = contains
information which may be confidential or privileged. The information is = intended=20
to be for the use of the individual or entity named above. If you are = not the=20
intended recipient, please be aware that any disclosure, copying, = distribution=20
or use of the contents of this information is prohibited. Please notify = the
sender of the delivery error by replying to this message, or notify us = by
telephone (877-633-2436, ext. 0), and then delete it from your system.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 04 2004 - 16:20:04 CST