RE: sigh
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: <awellsdba@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 4 Nov 2004 14:18:18 -0700
1. $ strings spfilexxxx > initsid.ora
2. vi initsid.ora # make your changes
3. sqlplus /nolog
a. SQL> connect / as sysdba
b. SQL> create spfile=3D'spfilexxxx' from pfile=3D'initsid.ora';
c. SQL> startup
-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of aj wells
Sent: Thursday, November 04, 2004 2:15 PM
To: oracle-l@xxxxxxxxxxxxx
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?
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
