用SQL developer连数据库时报错ora-12537，数据库是11g R2 RAC，操作系统是suse 11。
监听日志信息：
0.58)(PORT=53959)) * establish * jzh * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNSprotocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
13-MAY-2013 12:27:01 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=Administrator))(SERVICE_NAME=jzh)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.58)(PORT=53960)) * establish * jzh * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNSprotocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
官方解释这个问题是因为$ORACLE_HOME/bin/oracle权限不对，于是查看两节点的权限，果然不对
修改权限 chmod 6751 oracle
然后登陆就正常了。
监听日志信息：
0.58)(PORT=53959)) * establish * jzh * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNSprotocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
13-MAY-2013 12:27:01 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=Administrator))(SERVICE_NAME=jzh)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.58)(PORT=53960)) * establish * jzh * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNSprotocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
官方解释这个问题是因为$ORACLE_HOME/bin/oracle权限不对，于是查看两节点的权限，果然不对
修改权限 chmod 6751 oracle
然后登陆就正常了。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10271187/viewspace-1127930/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
BBED学习之一
请登录后发表评论
登录
全部评论
最新文章
- 12.2新特性之ADG多节点启动MRP进程
- ORA-01511 error in renaming log/data files ORA-00261 log 4 of thread 1 is being
- Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent
- 恢复数据库hang住/parallel recovery read buffer free
- ORA-00600: 内部错误代码，参数: [6002], [6], [28], [1], [52], [], [], []
- ORA-13639: The CURRENT operation was interrupted because it timed OUT
- 表空间小写导致ORA-31655错误
- ORA-12154:TNS:无法解析指定的连接标识符
- 测试将表缓存到keep池
- ASM file metadata operation
