SGA_MAX_SIZE PROBLEM

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

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

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 :-)

I am running Oracle9.0.1 on Windows 2000

I have plenty of RAM(512K).

Please advise what I need to do????

Thanks

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

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

Quote:

---

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?

I am using 9.0.1

Please explain more detail for me.

Thanks Julian

Quote:

---

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.

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

Quote:

---

Originally posted by 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

---

Yes, there is 9.2 for Windows. It is not a patch. It's a new installation.