Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: !! oracle startup problem - need help
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
-- 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
![]() |
![]() |