Home > Database > Mysql Tutorial > TNS-12547和TNS-12555错误解决

TNS-12547和TNS-12555错误解决

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 17:31:50
Original
2158 people have browsed it

解決Oracle启动监听时错误 一、TNS-12547: TNS-12547: TNS:lost contactTNS-12560: TNS:protocol adapter errorTNS-00517: Lost

解決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错误

Oracle 10g RAC监听报TNS-12545 TNS-12560 TNS-00515

Oracle 11gR2 RAC TNS-12542: TNS:address already in use 故障一例

TORA-12154 和 TNS-03505:无法解析名称

遭遇TNS-01150: The address of the specified listener name is incorrect 

linux

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template