Dear 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.
jubraz
Printable View
Dear 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.
jubraz
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..????
thanks
jubrazas
hi jubraz,
could u tell us first the O.S.?
Oracle version installed?
can still invoke sqlplus?
and what is the banner of your v$version?
Hi,
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.
HKEY\LOCAL_MACHINE\SOFTWARE\ORACLE\ORAHOME\
ORA_SID_AUTOSTART=TRUE
Italics are variables and specific to your database.
yes my OS is window(2000 server) and oracle version is 9i
thanks
jubraz
yes my OS is window(2000 server) and oracle version is 9i noted please i can't logon by sqlplus at all.
thanks
jubraz
open cmd prompt
set ORACLE_SID=PROD
sqlplus "/ as sysdba"
startup
make sure corresponding SERVICE is started.
Thanks all here problems have resolved. It’s really great help.
Jubraz