Solved

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

Posted on 2006-10-25
3
3,267 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
  • 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

856 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