2 DB's on Win2K, one gives "Shared Mem Realm does not exist"
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: 2 DB's on Win2K, one gives "Shared Mem Realm does not exist"

  1. #1
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    I have 2 different databases DB01 and DB02 on a Win2k Server.

    When I try connect to DB01 whru SQLPlus from a Workstation, I get this :

    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist

    I dont have this problem with DB02.

    I have set ORACLE_SID=DB01 in Registry. If I remove this and restart the server, the database does not come up. When I get bring the database up from Svrmgrl, every thing works fine. When I have have ORACLE_SID=DB01, the database starts but the "shared Mem realm" problem occurs.

    Wy dont I have any problems with DB02.

    Please help.
    Sridhar R Patnam

  2. #2
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203

    Thumbs up

    Dear first let us know which Oracle version you are using.
    If oyu are using Oracle 8i then before issuing svrmgrl write this on command prompt
    c:\ set oracle_sid=DB01
    c:\set o
    /* this should display DB01 */
    C:\svrmgrl

    Hope it should work fine with this. Just try this...
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

  3. #3
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    Problem will reoccur after a restart of server. The work is in development phase and restarting is a common thing here. I want things to be ok in my absence.
    Sridhar R Patnam

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    1. Set SQLNET.AUTHENTICATION_SERVICES=(NTS) to SQLNET.AUTHENTICATION_SERVICES=(NONE) in SQLNET.ORA

    2. Change the user that starts the OracleService to the Oracle DBA user who is defined to the Windows domain.
    Go to Control Panel, Services, select the OracleService, right click and select properties, select the Log On tab. Click on the Account radio button and fill in the domain qualified dba user and password (e.g. ORACLE-UK\ORADBA) and click the okay button.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Apr 2002
    Posts
    55
    Also do a run on regestary editor and go to HKEY USERS select software and for oracle services set the properties to true.
    VenDe ChukPeen Zuri

    Someone who quotes himself as a DBA and posts simple question in forums is a big idiot to me . I donot care what others think

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