远程SQLPLUS连接失败 tns12560

来源：互联网发布：制作班徽用什么软件编辑：程序博客网时间：2024/04/29 10:58

lsnrctl status

TNS-12543

TNS-12560

TNS-00513

Linux Error 101

是因为listener没有启动

解决方法:

删除了服务器$ORACLE_HOME\NETWORK\ADMIN\目录下的listener和tnsnames文件之后

使用netca进行重建监听

随后关闭系统防火墙

编辑tnsnames文件，把ip地址和oracle实例名写入tnsnames文件

客户端PC

首先配置好tnsnames文件

1. ping 服务端

2. tnsping tns服务名

3 conn username/password@tnsname 的方式去连接服务器

附上服务器/客户机tnsnames.ora和listener文件

服务器：

Lsnr：

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = Centos)(PORT = 1521))    )  )ADR_BASE_LISTENER = /u01/app/oracle

Tns：

zytest =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.17)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )

Client：

Tns：

zytest =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.17)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )

阅读全文

0 0