Printable View
I think it is memory issue. decrease the size of following parameters in your init.ora file and try to startup database on svrmgrl> prompt.
shared_pool_size
log_buffer
db_block_buffers
try it. if you still get same error try again and reduce the size of above mentioned parameters.
Thanks
Decreasing these values will not really help much, if at all.
julian,
I encountered with same problem in past i have 10 database working on my production server out of 10 4 database with JVM and i have 1G.B memory still sometime i am getting the same error cuse memory issue i alway rduce three parameters which i mentioned before it's not always tru that decreasing valu naver help at all.try it.
Minesh
I've encountered this problem in the past. I have never done it via SQL*Plus, only from the command line. What I did to solve the seemingly annoying problem is:
1) stop and then start the Oracle service
2) try to startup the database from svrmgrl> prompt.
Occasionally, you will be given an error message "Oracle service not available." Don't panic, just stop & re-start the service and this will allow you to start up the database.
I also remember seeing another Oracle error message "Oracle instance is up-you must first shutdown and ..."-well, in this case, shutdown and startup will do.
Hope this help.
P.S: Mine is Oracle 8.16 running on NT 4.0
I had the same error on Win NT Oracle 8.1.7. The problem:
One of my config files was linked to a non-existent file. Fixed the link and now everything is ok.
If (s)he is swapping, of course, they have to be decreased.