RAC环境有节点vip不起作用，但查看其他状态都正常，查看grid的监听日志报错，已解决...

路径：
[grid@mi6 trace]$ cd /u01/app/oracle/diag/tnslsnr/mi6/listener/trace
[grid@mi6 trace]$ 
[grid@mi6 trace]$ tail -200 listener.log 




[grid@mi7 trace]$ tail -f listener.log 
30-OCT-2014 11:16:13 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))(SERVICE_NAME=mi)(FAILOVER_MODE=(TYPE=select)(METHOD=basic)(RETRIES=180)(DELAY=2))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.10.11)(PORT=42751)) * establish * mi * 0
30-OCT-2014 11:16:13 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))(SERVICE_NAME=mi)(FAILOVER_MODE=(TYPE=select)(METHOD=basic)(RETRIES=180)(DELAY=2))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.10.11)(PORT=42752)) * establish * mi * 0
30-OCT-2014 11:16:13 * service_update * mi2 * 0
30-OCT-2014 11:16:14 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))(SERVICE_NAME=mi)(FAILOVER_MODE=(TYPE=select)(METHOD=basic)(RETRIES=180)(DELAY=2))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.10.11)(PORT=42767)) * establish * mi * 0
30-OCT-2014 11:16:14 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))(SERVICE_NAME=mi)(FAILOVER_MODE=(TYPE=select)(METHOD=basic)(RETRIES=180)(DELAY=2))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.10.11)(PORT=42768)) * establish * mi * 0
Thu Oct 30 11:16:16 2014
30-OCT-2014 11:16:16 * service_update * mi2 * 0
Thu Oct 30 11:16:43 2014
30-OCT-2014 11:16:43 * service_update * mi2 * 0
30-OCT-2014 11:16:52 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=mi7)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0






[grid@mi6 trace]$ tail -f listener.log 
   TNS-00517: Lost contact
    Linux Error: 32: Broken pipe
30-OCT-2014 11:16:14 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))(SERVICE_NAME=mi)(FAILOVER_MODE=(TYPE=select)(METHOD=basic)(RETRIES=180)(DELAY=2))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.10.11)(PORT=60505)) * establish * mi * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12547: TNS:lost contact
  TNS-12560: TNS:protocol adapter error
   TNS-00517: Lost contact
    Linux Error: 32: Broken pipe
Thu Oct 30 11:16:17 2014
30-OCT-2014 11:16:17 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=mi6)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Thu Oct 30 11:17:17 2014
30-OCT-2014 11:17:17 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=mi6)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
30-OCT-2014 11:17:19 * service_update * +ASM1 * 0


******************
权限设置有问题
解决办法如下
1、查看
第一个节点（不正常状态）
[oracle@mi6 bin]$ pwd
/u01/app/oracle/product/11.2.0/db_1/bin
[oracle@mi6 bin]$ 
[oracle@mi6 bin]$ ls -l $ORACLE_HOME/bin/oracle
-r-xr-sr-x 1 oracle asmadmin 210824720 Oct 12 12:19 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
第二个节点（正常状态）
[oracle@mi7 bin]$ ls -l $ORACLE_HOME/bin/oracle
-r-sr-s--x 1 oracle asmadmin 210824720 Oct 12 12:23 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
两个节点上的权限不一致，节点一的oracle用户真的少了setuid


2、修改权限,把节点一的权限修改为跟节点二一样
[oracle@mi6 bin]$ chmod u+s oracle
[oracle@mi6 bin]$ chmod o-r oracle


查看是否和节点二一样
[oracle@mi6 bin]$ ls -l $ORACLE_HOME/bin/oracle
-r-sr-s--x 1 oracle asmadmin 210824720 Oct 12 12:19 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
如果不一样再修改
我出现的情况是：
1）修改完后组的s权限没了
[oracle@mi6 bin]$ ls -l $ORACLE_HOME/bin/oracle
-r-sr-x--x 1 oracle asmadmin 210824720 Oct 12 12:19 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
2）再添加授权
[oracle@mi6 bin]$ chmod g+s oracle
查看，发现还没有改变
[oracle@mi6 bin]$ ls -l $ORACLE_HOME/bin/oracle
-r-sr-x--x 1 oracle asmadmin 210824720 Oct 12 12:19 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
3）查看数据库的告警日志
[oracle@mi6 ~]$ tail -f /u01/app/oracle/diag/rdbms/mi/mi1/trace/alert_mi1.log 
发现节点一的实例挂掉了
再用命令查看，确实挂掉了
[root@mi6 ~]# srvctl status database -d mi
Instance mi1 is not running on node mi6
Instance mi2 is running on node mi7
4）单独启动节点一的实例，再查看
[root@mi6 ~]# srvctl start  instance  -d mi -i mi1
[root@mi6 ~]# srvctl status database -d mi
Instance mi1 is running on node mi6
Instance mi2 is running on node mi7
5）节点一的实例起来后，发现权限也改变成和节点二一样了
[oracle@mi6 bin]$ ls -l $ORACLE_HOME/bin/oracle
-r-sr-s--x 1 oracle asmadmin 210824720 Oct 12 12:19 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
6）在客户端修改tnsnames，分别用各自的vip地址连接数据库查看，是否都可以正常登录

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

转载于:http://blog.itpub.net/29819001/viewspace-1321048/