DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Stupid NT Oracle error

  1. #1
    When rebooting the server and going to services and manually starting the oracle database (by starting the service).

    On logging into the database I am greeted with

    ORA-27101 shared memory realm does not exist

    Anyone know why this is?

    All the correct services are running, i'm sure of it.

    (Oracle 8.1.7)


  2. #2
    Join Date
    Aug 2000
    Posts
    462
    I've seen that error when the init.ora is incorrectly configured. Are you trying to set up standby database and working on redo log destinations?
    Oracle DBA and Developer

  3. #3
    Simply put - When booting up the server.

    The service OracleSeviceSID is not started manually.

    I start this service thinking this is starting the database.


    If I was to go into the Server Manager, connect as internal and issue the startup command. This works fine.


    I am thinking the init.ora file is ok.


    It seems that the database is shutdown overnight for the backups and won't restart. Every morning I come in and I reboot the server and startup the database via server manager.

    I just thought that starting the service would also do the same job.

    Hope that helps a bit.

  4. #4
    Join Date
    Jun 2000
    Posts
    179

    Talking

    maybe there is smothing wrong with the service , recreat it using oradim.exe
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

  5. #5
    So you do agree that starting the service should in effect start and open the database .

    I will suggest they recreate the service.

  6. #6
    I have since found out that starting the service IS NOT the same as starting the database.

    Starting the service is the equilavent of creating the instance. You must start the database after starting the service.

  7. #7
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    with NT, instance and services ARE different !!!
    for example, when you start your database, you should use something like :
    oradim80 -startup -sid ... -usrpwd ... -starttype srvc,inst -pfile ...
    where you specify that you start the service, then the instance

  8. #8
    Ok, thankyou.

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