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

[nisha]

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.

[OracleDisected]

Is the file system mounted with nosuid? ... execute

#mount | grep $ORACLE_HOME

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

[nisha]

Didn't get any output after executing the command.

mount | grep $ORACLE_HOME

[davey23uk]

your oracle executbale doesnt have the setuid bit set, either you didnt run root.sh or someone has been playing with your installation