Re: !! oracle startup problem - need help
- From: "Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Jul 2004 18:24:22 -0400
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@xxxxxxxxxxxxx
Date: 07/21/04 18:22:58
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
