SGA_MAX_SIZE PROBLEM

[ashley75]

Could someone help me with this problem please........

I have these values set on my parameter:


sga_max_size = 128M
db_cache_size = 20M
shared_pool_size = 30M
log_buffer = 524288
# large_pool_size = 32M
# java_pool_size = 20971520

Everytime I have SGA_MAX_TIME in my parameter, I got the following message:

ORA-00445: background process "PMON" did not start after 120 seconds


If I comment out the SGA_MAX_SIZE, I was able to create my database without having any problem.

I read the docs dynamic SGA but I am not quite clear about the values and all,

Could some senior or maybe Jeff or Julian help me to understand better????

thanks

[saurabhg29]

please let me know what is the database version and os because there is a bug but you need to tell me what is the os and database version

saurabh

[julian]

Increase the number of semaphores if using UNIX. But with these samll values, it looks like you run on NT or 2000. Can you mount the instance with SGA_MAX_SIZE = 64M? How much RAM do you have? I have gotten once the same error. I just don't rememebr now how I solved it :-)

[ashley75]

I am running Oracle9.0.1 on Windows 2000

I have plenty of RAM(512K).

Please advise what I need to do????

Thanks

[julian]

Tell me first, are you able you mount the instance with SGA_MAX_SIZE = 64M?

[ashley75]

Julian,

Yes, I was able to mount the database with the size of SGA_MAX_SIZE=64M. could you please explain to me what happen??? Why I got the above error????

Please let me know and thanks million as always

[julian]

Originally posted by ashley75
Julian,

Yes, I was able to mount the database with the size of SGA_MAX_SIZE=64M. could you please explain to me what happen??? Why I got the above error????

Please let me know and thanks million as always

OK, that's what I expected. It is a memory issue/system resources. That, in case it is not an Oracle bug. Which 9i version are you using?

[ashley75]

I am using 9.0.1

Please explain more detail for me.

Thanks Julian

[julian]

Originally posted by ashley75
I am using 9.0.1

Please explain more detail for me.

Thanks Julian

Have you applied any patches? Sounds like a bug to me. I remember I faced something similar with the unpatched 9.0.1.

[ashley75]

So it's a bug in 9.0.1(early version). Do they have Oracle 9i release 2 for windows yet ??? If yes, could you refer the patch number ???

Thanks so much and have a great weekend