Solved

ORA-00824: cannot set sga_target due to existing internal settings

Posted on 2006-10-25
3
3,270 Views
Last Modified: 2012-06-21
Help............

I thought I had followed the advice in the memory advisor of my OEM.  Now I can not starut up the db.

In OEM I get a shared realm memory and via command line I get the above message when I try to do a startup nomount or mount.

I had evoked the ASMM in oem and applied the advice for SGA and PGA.  What parameter do I have incorrect and where....in the SPILE or initora file?

High priority ...........help
0
Comment
Question by:mjimison1956
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
Daniel Stanley earned 500 total points
ID: 17809238
look in your alert.log, it should tell you more information and how do correct it; you will most likely be able to change a param in your init.ora and mount from there instead of spfile; then when you get it mounted and opened, recreate your spfile.

good luck,
daniels
0
 

Author Comment

by:mjimison1956
ID: 17809288
what is syntax for mounting from command line using only the init.ora
0
 
LVL 7

Expert Comment

by:Daniel Stanley
ID: 17813296
startup mount pfile='%DIRECTORY_PATH%/init.ora'


0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to recover a database from a user managed backup

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question