Solaris 10, oracle 11.2.0.3, RAC, 非ASM, 使用SCAN和DNS
状况:
# tnsping ISUITE
TNS Ping Utility for Solaris: Version 11.2.0.3.0 - Production on 12-JUN- 08:04:45
Copyright (c) 1997, , 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)
# tnsping ISUITE1
TNS Ping Utility for Solaris: Version 11.2.0.3.0 - Production on 12-JUN- 08:04:55
Copyright (c) 1997, , 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)
# sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 12 06:12:38
Copyright (c) 1982, , Oracle. All rights reserved.
ERROR:
ORA-12537: TNS:connection closed
# sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 12 06:12:38
Copyright (c) 1982, , 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目录下是否有权限
# 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。我开始流汗了。。。。
# 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
我靠,居然中招了,系统组的同事,我要吐槽!!!
@*((*&(*&(!(&$))%)*(&
发邮件,15分钟反馈,改好了,变成setuid了。问题解决。
# 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
# sqlplus xxx
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 12 07:50:30
Copyright (c) 1982, , 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