URGENTLY Need feedback:Database dose not start at all
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: URGENTLY Need feedback:Database dose not start at all

  1. #1
    Join Date
    Jan 2007
    Posts
    36

    Question 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

  2. #2
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    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.
    ---------------

  3. #3
    Join Date
    Jan 2007
    Posts
    36
    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

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    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?
    ---------------

  5. #5
    Join Date
    Jun 2006
    Location
    Chennai, INDIA
    Posts
    72

    Wink

    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.

  6. #6
    Join Date
    Jan 2007
    Posts
    36
    yes my OS is window(2000 server) and oracle version is 9i

    thanks
    jubraz

  7. #7
    Join Date
    Jan 2007
    Posts
    36
    yes my OS is window(2000 server) and oracle version is 9i noted please i can't logon by sqlplus at all.


    thanks
    jubraz

  8. #8
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    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

  9. #9
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    make sure corresponding SERVICE is started.
    ---------------

  10. #10
    Join Date
    Jan 2007
    Posts
    36
    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
  •  


Click Here to Expand Forum to Full Width