ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 解决11gR2 Rac ORA-12537: TNS:connection closed 一例

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

原创 Linux操作系统 作者:快乐的大个子 时间:2012-06-12 16:02:22 0 删除 编辑

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/onerror=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/onerror=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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-01-21

  • 博文量
    5
  • 访问量
    22018