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.
