Re: !! oracle startup problem

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Wed, 21 Jul 2004 16:25:17 -0600
Message-Id: <6.1.0.6.2.20040721162317.02eba670@pop.centrexcc.com>

Just create a pfile from the spfile. The database doesn't have to be started to do that. Then edit the pfile and either start from it or create the spfile from the modified pfile.

At 04:12 PM 7/21/2004, you wrote:

>Oracle 9i.
>
>The DBA used enterprise manager to change memory parameters and restart
>the database, but the database can't grab all the data specifiied, so it
>won't start back up.
>
>He can't get enterprise manager to change the memory parameters back
>because the database isn't started.
>
>The parameters are stored in an spfile, which appears to be partially binary.
>(I'm used to using the init.ora text file, no big deal to edit that!)
>
>What can we do to get the spfile contents edited?
>
>Needless to say, the database is down.

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

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 Jul 21 2004 - 17:22:45 CDT

Re: !! oracle startup problem - need help