URGENTLY Need feedback:Database dose not start at all

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