Link to home
Start Free TrialLog in
Avatar of mjimison1956
mjimison1956Flag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Daniel Stanley
Daniel Stanley
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mjimison1956

ASKER

what is syntax for mounting from command line using only the init.ora
startup mount pfile='%DIRECTORY_PATH%/init.ora'