Re: !! oracle startup problem - need help

On July 21, 2004 03:12 pm, david wendelken 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.
>

Command line.

sqlplus /nolog

connect / as sysdba

startup nomount or startup mount

then change parameters from the command line.

--
Lyndon Tiu
----------------------------------------------------------------
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
-----------------------------------------------------------------