URGENTLY Need feedback:Database dose not start at all
Suddenly when I try to start the server given me the following message: ORA27101 shared memory realm dose not exist and ORACLE NOT AVAILABLE…
I need the urgent feed back on because I have important data on it..
Thanks in advance.
you don't have enough memory in your server.
need to allocate contiguous memory from can't.
exit other applications or other db running,
or might as well restart server.
or you might have over configure your SGA.
Dear Mr. REY,
I have all basic file like control file,redolog file datafile, parameter file (pfile) and database name is "PROD" now can u tell me how can I reinstall oracle as well as database using existing file..????
could u tell us first the O.S.?
Oracle version installed?
can still invoke sqlplus?
and what is the banner of your v$version?
I feel nothing went wrong. Is this windows platform? if so, login as sys using sqlplus and give STARTUP.
I guess that service is started but the database is not started. In order to start the db automatically when the server is re-stared, u need to make the following registry entry to TRUE.
Italics are variables and specific to your database.
yes my OS is window(2000 server) and oracle version is 9i
yes my OS is window(2000 server) and oracle version is 9i noted please i can't logon by sqlplus at all.
open cmd prompt
sqlplus "/ as sysdba"
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
make sure corresponding SERVICE is started.
Thanks all here problems have resolved. It’s really great help.
Click Here to Expand Forum to Full Width