64bit-AIX平台下,Oracle10g数据库 使用SQLPLUS登陆报错

登陆客户数据库报错:

SQL> conn xxx/xxx
 ERROR:
 ORA-01034: ORACLE not available
 ORA-27121: unable to determine size of shared memory segment
 IBM AIX RISC System/6000 Error: 13: Permission denied
 [zwq_kfdb1:/home/oraeye/enmotech]uname -a
 AIX zwq_kfdb1 1 6 00C5C4764C00

Google了下,很多文章说是由于“重建oracle用户和组引起的ORA-27121错误”,还有说是内存问题,需要重启。大致翻了一些,感觉都不太靠谱,故上MOS搜索,输入“ORA-27121”,第一篇文章即为:Cannot Use SQLPlus as a Non-Oracle User on AIX 64 Bit ORA-01034 and ORA-27121 [ID 1058928.1],内容如下:

Applies to:
Oracle Server – Enterprise Edition – Version: 10.2.0.3 to 11.1.0.7 – Release: 10.2 to 11.1
IBM AIX on POWER Systems (64-bit)
Symptoms
On AIX 64 Bit, using Oracle 10.2 or 11.1, unable to use SQLPLUS as any user other than the UNIX user Oracle. The following occurs:
ERROR:
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
IBM AIX RISC System/6000 Error: 13: Permission denied

Symptoms associated with this issue are:
– no errors in alert.log
– cannot connect to sqlplus other than as UNIX user oracle
– platform is 212 AIX 64 Bit
– errors that occur in a core dump are
ORA-1034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment

Changes
Running Oracle version 10.2.0.3, 10.2.0.4, 11.1.0.6 or 11.1.0.7

Cause
Bug 6973208 which is a duplicate of Bug 6800649
Abstract: AIX: Client side “map:permission denied” or “sh: /usr/bin/procmap: not found”
============
Client side executables may report errors such as
sh: /usr/bin/procmap: not found
or if procmap exists but the client executable is setuid then
the client may report an error like:
map:permission denied

Solution
Apply Patch 6800649 for effected Oracle version
Workaround:
For the case “sh: /usr/bin/procmap: not found” install “procmap”.
This is an AIX executable. See Note:435576.1 for more details.
For the case of “map:permission denied” make sure that the client
executable is not marked as setuid to some other user.

解决方案:
修改oracle文件权限:

[xxx:/oracle10/app/product/db/10.2.0/bin]ls -l oracle
 -rwsr-s--x 1 oracle10 oinstall 133933734 Jan 16 2011 oracle
普人特福的博客cnzz&51la for wordpress,cnzz for wordpress,51la for wordpress