Solved

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

947 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now