Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81

    Unanswered: AIX: ORA-27101: shared memory realm does not exist

    Hi,
    I've upgraded 8.1.6 to 8.1.7.
    and now sqlplus returns the following:

    kia:/oracle/oracle8i/8.1.7/bin> sqlplus system/manager

    SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jul 10 22:21:02 2003

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    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
    ----

    Below are the quotes of my env:
    PATH=/oracle/oracle8i/8.1.7/bin:/usr/bin/:/bin:/usr/bin/X11/:/usr/local/bin:.:/usr/ccs/bin:/opt/langtools/bin:/usr/sbin
    ORACLE_HOME=/oracle/oracle8i/8.1.7/
    ORACLE_INSTALL_STAGE_JRE_LOC=/kits/oracle/Disk1/stage/Components/oracle.swd.jre/1.1.8.3/1/DataFiles/Expanded/jre/aix
    ORACLE_SID=test86a2
    LIBPATH=/oracle/oracle8i/8.1.7/lib:/oracle/ora8/jre/1.1.8/lib/aix/native_threads

    and also results of "ps-ef |grep ora" :
    oracle 13726 1 0 21:53:37 pts/5 0:00 /oracle/oracle8i/8.1.7//bin/tnslsnr LISTENER -inherit
    oracle 15104 21496 0 11:21:34 pts/3 0:01 -csh
    oracle 16012 1 0 21:45:08 - 0:00 ora_lgwr_test86a2
    oracle 16264 1 0 21:45:08 - 0:00 ora_dbw0_test86a2
    oracle 16570 1 0 21:45:09 - 0:00 ora_smon_test86a2
    oracle 17044 1 0 21:45:08 - 0:00 ora_ckpt_test86a2
    oracle 17300 1 0 21:45:07 - 0:00 ora_pmon_test86a2
    oracle 21496 13060 0 11:21:11 pts/5 0:03 xterm
    oracle 22880 1 0 09:28:09 - 0:03 xterm
    oracle 24516 15104 16 22:47:35 pts/3 0:00 ps -ef
    oracle 27144 1 0 21:45:09 - 0:00 ora_reco_test86a2
    oracle 28972 15104 0 22:47:35 pts/3 0:00 grep ora
    --
    kukuk

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    did you adjusts the unix kernel parameters shared memory max and semaphores ++ to fit with 8.1.7 requirements

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •