• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3314
  • Last Modified:

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

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
mjimison1956
Asked:
mjimison1956
  • 2
1 Solution
 
Daniel StanleyDatabase engineerCommented:
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
 
mjimison1956Author Commented:
what is syntax for mounting from command line using only the init.ora
0
 
Daniel StanleyDatabase engineerCommented:
startup mount pfile='%DIRECTORY_PATH%/init.ora'


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now