Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › rac一节点不能客户端登录

zxjlqh

0 积分	1 好友	9 主题

发消息

[Exadata常规管理] rac一节点不能客户端登录

1^#

发表于 2013-4-26 20:51:48 | 查看: 4863| 回复: 11

11GR2 RAC 双节点
REDHAT 64 5.8 节点1正常

目前问题，节点2 登录  sqlplus jeff/jeff@thirdb2

SQL*Plus: Release 11.2.0.3.0 Production on 星期五 4月 26 20:46:22 2013

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

ERROR:
ORA-12537: TNS: 连接关闭

请输入用户名:
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝

可以用sqlplus jeff/jeff在本机登录

listener.log

Fri Apr 26 20:46:22 2013
26-4月 -2013 20:46:22 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=thirdb)(SID=thirdb2)(CID=(PROGRAM=sqlplus)(HOST=db1.hshy.com)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.10.12)(PORT=40590)) * establish * thirdb * 12518
TNS-12518: TNS: 监听程序无法转接客户机连接
TNS-12546: TNS: 权限被拒绝
  TNS-12560: TNS: 协议适配器错误
TNS-00516: 许可被拒绝
Linux Error: 13: Permission denied

按照网上的方法：查看了var/tmp/.oracle的权限，没有问题
看了$ORACLE_HOME/bin/oracle的权限，也没有问题。

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2013-4-26 21:45:48

TNS-00516: 许可被拒绝
Linux Error: 13: Permission denied

strace 你listener 对应的tnslsnr 进程

并尝试登陆

并给出strace 日志

回复只看该作者道具举报

zxjlqh

3^#

发表于 2013-4-27 09:23:48

老大，trace日志里边就只有下面这些
Sat Apr 27 09:20:47 2013
27-4月 -2013 09:20:47 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=thirdb)(SID=thirdb2)(CID=(PROGRAM=sqlplus)(HOST=db1.hshy.com)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.10.12)(PORT=39313)) * establish * thirdb * 12518
TNS-12518: TNS: 监听程序无法转接客户机连接
TNS-12546: TNS: 权限被拒绝
TNS-12560: TNS: 协议适配器错误
TNS-00516: 许可被拒绝
Linux Error: 13: Permission denied

回复只看该作者道具举报

zxjlqh

4^#

发表于 2013-4-27 09:27:39

log.xml里边是：
<msg time='2013-04-27T09:26:58.562+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='db2.hshy.com'
host_addr='10.0.10.13'>
<txt>27-4月 -2013 09:26:58 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=thirdb)(SID=thirdb2)(CID=(PROGRAM=sqlplus)(HOST=db1.hshy.com)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.10.12)(PORT=39322)) * establish * thirdb * 12518
</txt>
</msg>
<msg time='2013-04-27T09:26:58.563+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='db2.hshy.com'
host_addr='10.0.10.13'>
<txt>TNS-12518: TNS: 监听程序无法转接客户机连接
TNS-12546: TNS: 权限被拒绝
TNS-12560: TNS: 协议适配器错误
TNS-00516: 许可被拒绝
Linux Error: 13: Permission denied
</txt>
</msg>

回复只看该作者道具举报

zxjlqh

5^#

发表于 2013-4-27 09:34:45

DB2 的监听：

# listener.ora Network Configuration File: /u01/app/11.2.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
   (GLOBAL_DBNAME = thirdb)
   (ORACLE_HOME = /u01/app/11.2.0/grid)
   (SID_NAME = thirdb2)
)
  )

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
)
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.10.13)(PORT = 1521))
)
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.10.33)(PORT = 1521))
)
  )

ADR_BASE_LISTENER = /u01/app/grid

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

LISTENER_SCAN1 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
  )

ADR_BASE_LISTENER_SCAN1 = /u01/app/grid

回复只看该作者道具举报

zxjlqh

6^#

发表于 2013-4-27 09:35:39

DB1 的监听：
# listener.ora Network Configuration File: /u01/app/11.2.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
   (GLOBAL_DBNAME = thirdb)
   (ORACLE_HOME = /u01/app/11.2.0/grid)
   (SID_NAME = thirdb1)
)
  )

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
)
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.10.12)(PORT = 1521))
)
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.10.32)(PORT = 1521))
)
  )

ADR_BASE_LISTENER = /u01/app/grid

LISTENER_SCAN1 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
  )

ADR_BASE_LISTENER_SCAN1 = /u01/app/grid

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON             # line added by Agent

回复只看该作者道具举报

zxjlqh

7^#

发表于 2013-4-27 09:36:09

host文件：
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1             localhost.localdomain localhost
::1          localhost6.localdomain6 localhost6
#Public IP
10.0.10.12    db1.hshy.com db1
10.0.10.13    db2.hshy.com db2

#Private IP
192.168.10.12 priv-db1
192.168.10.13 priv-db2

#Virtual IP
10.0.10.32    vip-db1
10.0.10.33    vip-db2

#SCAN IP
10.0.10.88    scan-hshy

回复只看该作者道具举报