Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: !! oracle startup problem - need help
Hi Wolfgang , sorry only pointing to a problem in your solution.
I agree that is the solution
the problem I think is he don't know how to do that.
-------Original Message-------
From: oracle-l_at_freelists.org
Date: 07/21/04 18:22:58
To: oracle-l_at_freelists.org
Subject: 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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:26:12 CDT
![]() |
![]() |