Ora-01034 Ora-27121 Linux-x86_64 Error 13 Permission Denied
Contents |
ORA-27121: unable to determine size of shared memory segment [message #297610] Fri, 01 February 2008 12:55 monto Messages: 60Registered: November 2007 Location: DALLAS Member Hi , I am facing the below ora-27123: unable to attach to shared memory segment permission denied error when trying to connect through sqlplus client, but can logon to database
Ora-27123 Unable To Attach To Shared Memory Segment Linux-x86_64 Error 13 Permission Denied
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
Ora-27123 Unable To Attach To Shared Memory Segment Linux-x86_64 Error 22 Invalid Argument
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
Ora-27123 Unable To Attach To Shared Memory Segment Aix
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" Permission on oracle [testA:server:test] /oracle/product/8.1.7ee/bin > ll oracle -rwxrwx--- 1 ora-27122: unable to protect memory 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. owner of binaries id uid=117(testB) gid=105(testdba) groups=104(dba) owner of db id uid=122(testA) gid=105(testdba) groups=104(dba) Please any suggestions would be great. Report message to a moderator Re: ORA-27121: unable to determine size of shared memory segment [message #297611 is a reply to message #297610] Fri, 01 February 2008 13:01 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member I suspect the listener.ora has a problem; possibly a incorrect ORACLE_HOME. Report message to a moderator Re: ORA-27121: unable to determine size of shared memory segment [message #297613 is a reply to message #297610] Fri, 01 February 2008 13:17 monto Messages: 60Registered: November 2007 Location: DALLAS Member Here is my listener.ora. STARTUP_WAIT_TIME_LISTENER_SERVER = 0 SID_LIST_LISTENER_SERVER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcldb.kk.xxx.com) (ORACLE_HOME = /oracle/product/8.1.7ee) (SID_NAME = orcldb) ) (SID_DESC = (GLOBAL_DBNAME = test.kk.xxx.com) (ORACLE_HOME = /oracle/product/8.1.7ee) (SID_NAME = test) ) ) LISTENER_SERVER = (ADDRESS_LIST = (ADDRESS =(HOST = SERVER.kk.xxx.com)(PROTOCOL = TCP)(PORT = 1131)) ) CONNECT_TIMEOUT_LISTENER_LISTENER_SERVER = 10 CONNECT_TIMEOUT_LISTE
Oracle ACE Award. I have extensive experience with Oracle 8i, 9i, 10g & 11g, and Oracle E-Business Suite 11i, ora-27123 unable to attach to shared memory segment solaris Specializing in Installation, Configuration and Administration of Oracle 8i, 9i, 10g, svr4 error: 13: permission denied & 11g Oracle 10g/11g RAC, and Oracle E-Business Suite 11i on different UNIX and Linux OS including oracle support Solaris, HP-Unix, IBM AIX and Red Hat. Experience in Upgrading Oracle 8i, 9i, 10g, & 11g and Oracle E-Business Suite 11i. Good exposure in implementing of backup & recovery http://www.orafaq.com/forum/t/96598/ strategies, applications cloning & refreshing, applications patching, and performance tuning, Written and published a couple of articles on Oracle Metalink Customer Knowledge Exchange. And also, I'm an Oracle Certified Professional (OCP) in 8i, 9i, 10g, & 11g, Oracle 11i Applications DBA Certified Professional, and Oracle Certified Expert in Oracle 10g RAC Administration as well.You can contact me at http://sabdarsyed.blogspot.com/2009/01/ora-27123-unable-to-attach-to-shared.html sabdar.syed @ gmail.com View my complete profile View my page on Oracle Community My other blogs About Me in eBizOCP-Blog My OTN Profile Syed RAC DBA Oracle Apps DBA Blogs Fadi Hasweh OnlineAppsDBA practicalappsdba www.appsdba.com OracleAppsBlog becomeappsdba appsdbablog Oracle DBA Blogs http://oracleonline.info/ http://blogs.oracle.com/ dizwell jonathanlewis JaffarDBA Oracle OCA/OCP/OCE eBizOCP Free DBA & Apps DBA Training www.exforsys.com Downloads Oracle SQL Developer 1.1 DBA Cheet Sheet Wednesday, January 28, 2009 ORA-27123: unable to attach to shared memory segment Hello,Of late, in one of our test unix (Sun Solaris) boxes, a database user is trying to connect to the database, but getting an error "ORA-27123: unable to attach to shared memory segment" with permission denied issue.Initially we thought that there might be an issue with SGA memory area or may be an issue with the shared memory segments and semaphores for the instance allocated. But later we found that the permission on ORACLE_HOME directory got changed accidentally with the full permission.Here are our findings:$ sqlplus testusr/password@testdbSQL*Plus: Release 10.2.0.2.0 - Production on Tue Jan
webmail ! solucionesintranet ! com [Download message RAW] Thank you very much Werner and Martin, the key was in $ORACLE_HOME/bin/oracle permissions, I left it with "-rwsr-s--x" and it worked perfectly. I http://marc.info/?l=suse-oracle&m=114235752209418 never changed this before in other oracle installations with SLES9 and x86 architecture, maybe the installation process for x86_64 is different... or the patchset... Well anyways, thanks a lot! Jorge Quoting Werner Flamme