OraFAQ Forum: Server Administration » ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY

Home » RDBMS Server » Server Administration » ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 (Linux 2.6.18-128.1.10.el5 Oracle Release 11.1.0.7.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 [message #425154]

Wed, 07 October 2009 17:03

conty109
Messages: 3
Registered: October 2009
Location: Australia

Junior Member

Out of 50 virtual servers, this server was shutdown since last 3 to 4 weeks. When started & attempted to startup database, it gives me this message.
Connected to an idle instance.

SQL> startup
ORA-00844: Parameter not taking MEMORY_TARGET into account
ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504.

I tried a lot to change SGA_MAX_SIZE, but not able to change any of the two parameters because the db is in idle state. I don't know how to circumvent this situation. Any suggestions or help available from you all experts please?

Thanks

Mukesh

Report message to a moderator

[Message index]

		ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: conty109 on Wed, 07 October 2009 17:03
		Re: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: BlackSwan on Wed, 07 October 2009 17:43
		Re: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: Michel Cadot on Wed, 07 October 2009 23:19
		Re: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: ursusca on Thu, 08 October 2009 14:25
		Re: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: BlackSwan on Thu, 08 October 2009 14:32
		Re: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: ursusca on Thu, 08 October 2009 14:58
		Re: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: Michel Cadot on Thu, 08 October 2009 23:51
		Re: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: romelboza on Sat, 14 September 2019 19:00
		Re: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: conty109 on Sun, 11 October 2009 17:32
		Re: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: BlackSwan on Sun, 11 October 2009 17:48
		Re: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: conty109 on Sun, 11 October 2009 19:35
		Re: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: EdStevens on Sun, 15 September 2019 13:08
		Re: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: cookiemonster on Mon, 16 September 2019 09:19
		Re: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: EdStevens on Mon, 16 September 2019 12:50
		Re: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: romelboza on Mon, 16 September 2019 15:19
		Re: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504 By: cookiemonster on Tue, 17 September 2019 03:21

Previous Topic:	Query to get the maxsize and unlimited of the TableSpace
Next Topic:	is it possible to move the datafiles from non CDB architecture to CDB architecture not just copy as

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 22:36:07 CDT 2024