Welcome 微信登录

首页 / 数据库 / MySQL / TNS-12547和TNS-12555错误解决

解決Oracle启动监听时错误一、TNS-12547:TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer发现/etc/hosts中并没有127.0.0.1 localhost.修改/etc/hosts,修改后如下
$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost
 
二、TNS-12555:TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted解决如下:# chmod 777 /var/tmp/.oracle原因分析:Oracle卸载不干净,导致/var/tmp/.oracle目录权限不足,故而报错。相关阅读:Oracle之TNS-04415错误 http://www.linuxidc.com/Linux/2013-05/84781.htmOracle 10g RAC监听报TNS-12545 TNS-12560 TNS-00515 http://www.linuxidc.com/Linux/2013-04/83538.htmOracle 11gR2 RAC TNS-12542: TNS:address already in use 故障一例 http://www.linuxidc.com/Linux/2013-02/79832.htmTORA-12154 和 TNS-03505:无法解析名称 http://www.linuxidc.com/Linux/2012-12/75562.htm遭遇TNS-01150: The address of the specified listener name is incorrect  http://www.linuxidc.com/Linux/2012-12/75558.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12数据块损坏后修复 ORA-01578Oracle中用户之间复制表数据相关资讯      TNS-12547  TNS-12555 
  • RAC 客户端连接TNS-12547: TNS: 丢  (05/28/2014 17:11:59)
本文评论 查看全部评论 (0)
表情: 姓名: 字数