ORA-27121: unable to determine size of shared memory segment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-27121: unable to determine size of shared memory segment

Hybrid View

  1. #1
    Join Date
    Oct 2005
    Posts
    90

    ORA-27121: unable to determine size of shared memory segment

    Hi ,
    I am facing the below error when trying to connect through sqlplus client but can logon to database locally .

    sqlplus testq@test.com
    SQL*Plus: Release 8.1.7.0.0 - Production on Fri Feb 1 18:18:49 2008

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

    Enter password:
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27121: unable to determine size of shared memory segment
    HP-UX Error: 13: Permission denied

    But can connect locally.

    ORACLE_BASE=/oracle
    ORACLE_SID=test
    PS1=[${ME}:${UNAME}:${ORACLE_SID}] ${PWD} >
    ORACLE_ADMIN=/oracle/admin
    ORACLE_HOME=/oracle/product/8.1.7ee

    sqlplus testq

    SQL*Plus: Release 8.1.7.0.0 - Production on Fri Feb 1 18:18:22 2008

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

    Enter password:

    Connected to:
    Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
    With the Partitioning option
    JServer Release 8.1.7.4.0 - 64bit Production

    SQL> show user
    USER is "testq"



    [testA:server:test] /oracle/product/8.1.7ee/bin > ll oracle
    -rwxrwx--- 1 oracle testdba 38264760 Sep 14 23:30 oracle

    NOTE:database created user(testA) is different from the one who own the binaries(testB) but belongs to same dba group.

    id
    uid=117(testB) gid=105(testdba) groups=104(dba).

    uid=122(testA) gid=105(testdba) groups=104(dba).

    Please any suggestions would be great.

  2. #2
    Join Date
    Sep 2007
    Location
    Mexico
    Posts
    19
    Is the file system mounted with nosuid? ... execute

    #mount | grep $ORACLE_HOME

    if it contains mount option nosuid it should be remounted with suid.

  3. #3
    Join Date
    Oct 2005
    Posts
    90
    Didn't get any output after executing the command.

    mount | grep $ORACLE_HOME

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    your oracle executbale doesnt have the setuid bit set, either you didnt run root.sh or someone has been playing with your installation

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