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

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

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Posts
    203

    ORA-27101: shared memory realm does not exist

    Hello,

    I just installed 10.2.0.4 ASM and DBMS instance on AIX 5.3. Both instances are running. I can connect to to the sid

    Greece/home/dbora>sqlplus '/as sysdba'

    SQL*Plus: Release 10.2.0.4.0 - Production on Mon Aug 23 08:12:17 2010

    Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SQL> conn system/manager
    Connected.
    SQL>

    But while connecting as system/manager@testdt, getting following errors

    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    IBM AIX RISC System/6000 Error: 2: No such file or directory


    Instance Status

    10204/network/admin>ps -ef|grep smon
    dbora 160060 1 0 06:22:57 - 0:00 asm_smon_+ASM
    dbora 181024 115202 0 08:19:30 pts/2 0:00 grep smon
    dbora 82998 1 0 06:23:31 - 0:00 ora_smon_testdt


    TNSENTRY

    testdt =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = fl1.greece.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = testdt)
    )
    )


    Listener
    10204/network/admin>lsnrctl status

    LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 23-AUG-2010 08:15:24

    Copyright (c) 1991, 2007, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fl1.greece.com)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
    Start Date 23-AUG-2010 06:47:15
    Uptime 0 days 1 hr. 28 min. 9 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP ON
    Listener Parameter File /fldb1/RDBMS/oracle/product/10204/network/admin/listener.ora
    Listener Log File /fldb1/RDBMS/oracle/product/10204/network/log/listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.12.10.165)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
    Services Summary...
    Service "testdt" has 1 instance(s).
    Instance "testdt", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

    LISTENER File


    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = fl1.greece.com)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = extproc))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = testdt)
    (ORACLE_HOME = /fldb1/RDBMS/oracle/product/10204/)
    )
    )

    DIRECT_HANDOFF_TTC_LISTENER=OFF
    SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF


    what am I missing?

    Rgds
    sumit

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    did you run root.sh correctly to set the permissions, what is $ORACLE_HOME/bin/oracle set to?

  3. #3
    Join Date
    Dec 2001
    Posts
    203
    yup, I did.

    anyway, we can close this thread as the problem got resolved ... How?


    in listener file ... 1 additional / (in red below) caused the problem

    (ORACLE_HOME = /fldb1/RDBMS/oracle/product/10204/)

    Grrrr......

    Regards
    sumit

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