-
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
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.
Oracle DBA
-
make sure corresponding SERVICE is started.
---------------
-
Thanks all here problems have resolved. It’s really great help.
Jubraz
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|