|
|
[ÀϹÝ] ÀÓÀÇ°èÁ¤À¸·Î sqlplus ½ÇÇà½Ã ¿¡·¯ ORA-27121 & Permission denied ÀÏ°æ¿ì |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 211.¢½.74.31 |
ÀÐÀ½:4802 |
|
|
ErrorsORA 1034 Oracle not available ORA-27121 unable to determine size of shared memory segment
SymptomsCustomer is getting the following errors when a user other than oracle tries to log into the database:
$ sqlplus test SQL*Plus: Release 10.1.0.2.0 - Production on Fri Apr 9 11:00:52 2004 Copyright (c) 1982, 2004, Oracle. All rights reserved. Enter password: ERROR: ORA-01034: ORACLE not available ORA-27121: unable to determine size of shared memory segment Linux Error: 13: Permission denied
ChangesThis is a new RAC 10g installation in a 2-node RAC environment
CauseThe problem is that the permissions for the $ORACLE_HOME/bin/oracle executable is not 6751 in the second node:
[opcbrh1]/u01/app/oracle/product/10.1.0/bin> ls -l oracle -rwsr-s--x 1 usupport usupport 71288062 Apr 5 15:40 oracle*
[opcbrh1]/u01/app/oracle/product/10.1.0/bin> rsh opcbrh2 ls -l oracle /u01/app/oracle/product/10.1.0/bin/oracle -rwxr-x--x 1 usupport usupport 71288062 Apr 5 15:40 /u01/app/oracle/product/10.1.0/bin/oracle << HERE THE PERMISSIONS ARE WORNG>
FixChange the permissions to 6751 in the second node using chmod:
$chmod 6751 $ORACLE_HOME/bin/oracle
ReferencesBug 3563714 - Setuid Bit For Oracle Does Not Get Propagated To Remote Node During Rac Install
|
|
|
|
|
|