Ora-27101: Shared Memory Realm Does not exist

Posted on 2004-11-08
Last Modified: 2011-10-03
I m getting this error since 2 days, I m using Oracle 9i on Windows NT Server,
Also where would i find the alert.log file in my folder
Question by:kdp1982
    LVL 47

    Accepted Solution

    Startup the listener:
    c:>lsnrctl start

    Look if the ORACLE_HOME variable in Registry points to a valid set of Oracle software.

    Startup the instance:
    c:>sqplus /nolog
    SQL>connect sys/password as sysdba
    SQL>connect / as sysdba

    alert<SID>.ora is in the admin directory pointed by the ORACLE_BASE variable.
    LVL 7

    Expert Comment

    Your instance hasnt been 'created'

    Before starting it up, you will need to start the service OracleService<SID>, and then start the instance if it doesnt start automatically - schwertner's code should work fine.

    Your alert log will be found wherever the background_dump_dest is set to in your init.ora/spfile.
    or if you get your instance started, from SqlPlus
      SHOW PARAMETER backg

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now