DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: ORA-27101: shared memory realm does not exist

  1. #1
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    Okay I have 8.1.7 installed on Win 2K Pro it was working just fine, I have not changed anything, All the services are running fine, but when I tried to connect I got Folloing error.

    ORA-27101: shared memory realm does not exist


    Thanks in Advance

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    from sqlplus windows or dos?

  3. #3
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    Both...

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    check and make sure that your environment had been set properly. i.e ORACLE_SID and ORACLE_HOME


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    Everything seams to be fine, but still the same error.

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Choose the database configuration assistant and look into updating your database to 8.1.7. This could occour when you have a wrong oracle_home, or oracle_sid set. Or on the case where your database was created on a different version and the you are trying to use the higher listner version or so...

    Need more information:

    1. Is this a fresh install or an upgrade?
    2. Others

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    Fresh install, I did it yesturday. It was working fine but today I'm getting all these errors.

    I 'm trying to connect to pre configured Database that comes with the CD, so no upgrade or manual configuration was done.

  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Try the above one by one and see whether you were able to solve it:

    1.Chnage SQLNET.AUTHENTICATION_SERVICES= (NTS) in
    %ORACLE_HOME%/network/admin/sqlnet.ora file and see whether you were able to succeed.

    2. Check your registry and see

    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\...\ORA_ORCL_AUTOSTART = FALSE

    and Try changing it to TRUE and see whether you were able to succeed.



    Curtesy to Metalink

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  9. #9
    Join Date
    Aug 2001
    Posts
    390
    Sam,

    I think I run to this problem too after I aplly the patches for 8.1.7 . this is upgrade from 8.1.6 to 8.1.7

    can you tell me what happened here ???

    thanks

  10. #10
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    Well since it was a demo database I just deleted it and recreated it, now it works fine. Thanks

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