解决11gR2 Rac ORA-12537: TNS:connection closed 一例

Solaris 10, oracle 11.2.0.3, RAC, 非ASM, 使用SCAN和DNS

状况：

oracle@US1S-ISTORDB03A # tnsping ISUITE

TNS Ping Utility for Solaris: Version 11.2.0.3.0 - Production on 12-JUN-2012 08:04:45

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=us1s-istordb03-scan)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ISUITE)))
OK (10 msec)

oracle@US1S-ISTORDB03A # tnsping ISUITE1

TNS Ping Utility for Solaris: Version 11.2.0.3.0 - Production on 12-JUN-2012 08:04:55

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=us1s-istordb03a-vip)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=us1s-istordb03b-vip)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ISUITE)))
OK (0 msec)

oracle@US1S-ISTORDB03A # sqlplus xxx/xxxxxx@isuite

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 12 06:12:38 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-12537: TNS:connection closed

oracle@US1S-ISTORDB03A # sqlplus xxx/xxxxx@isuite1

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 12 06:12:38 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-12537: TNS:connection closed

tnsping可以通说明tnsnames.ora写的没问题，但是怎么还回有连接问题呢？

由于是11G的RAC，listener不归oracle用户管，是grid用户管的。查了GI下listener相关，也没发现异常。

在metalink上找到一篇，ID 1069517.1相关的，开始检查

1. 用listener的owner用户检查rdbms_home目录下是否有权限

grid@US1S-ISTORDB03A # ls -l /xxx/app/oracle/product/11.2.0.3/db/bin/oracle
-rwsr-s--x   1 oracle   oinstall 233186712 May 10 09:00 /xxx/app/oracle/product/11.2.0.3/db/bin/oracle

这项没有问题。

2. 查看该目录权限 是否是6751：

-rwsr-s--x  也没有问题，如果这里不是这样，请使用：

chmod 6751  /xxx/app/oracle/product/11.2.0.3/db/bin/oracle

修改。

3. 检查oracle软件目录的文件系统是否支持setuid/suid，或者是被设置成了nosetuid。我开始流汗了。。。。

grid@US1S-ISTORDB03A # mount| grep /xxx
/xxx on /dev/md/dsk/d56 read/write/nosetuid/nodevices/intr/largefiles/logging/xattr/οnerrοr=panic/dev=1540038 on Fri May 11 23:22:40 2012

我靠，居然中招了，系统组的同事，我要吐槽！！！

@*((*&(*&(!(&$))%)*(&

发邮件，15分钟反馈，改好了，变成setuid了。问题解决。

grid@US1S-ISTORDB03A # mount| grep /xxx
/xxx on /dev/md/dsk/d56 read/write/setuid/devices/intr/largefiles/logging/xattr/οnerrοr=panic/dev=1540038 on Tue Jun 12 07:43:59 2012

oracle@US1S-ISTORDB03A # sqlplus xxx/xxxxxx@ISUITE1

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 12 07:50:30 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters and Real Application Testing options

SQL>

MOS ID 1069517

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22128702/viewspace-732589/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22128702/viewspace-732589/