psd 链接本地tnsnames

客户端工具plsql developer 链接windows上的tnsname - NEW ，再通过NEW去链接linux上的监听。去链接数据库

1 验证linux上的监听状态

1 查看监听状态

[oracle@dan ~]$ lsnrctl status

监听中3个必不可少的：ip、端口号、service。说明linux监听正常。所以我们通过xshall是通过密码文件可以链接进入数据库的

[oracle@dan ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun Mar 8 20:59:48 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

如果要走网络的话，就需要下面的tnsnames.ora

2 查看linux上的listener.ora

[oracle@dan admin]$ pwd
/u01/app/oracle/product/11.2/db_1/network/admin/

[oracle@dan admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = tcp) (HOST = dan)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

从listener.ora可以看出ip和端口号，但是看不到服务

2 查看linux上的tnsnames.ora，没有的话，可以手工添加

NEW=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.56)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

走网络验证：

[oracle@dan admin]$ sqlplus system/oracle@NEW

SQL*Plus: Release 11.2.0.4.0 Production on Sun Mar 8 21:22:53 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

能进入 ，说明tnsnames.ora没有问题。

如果不能进入，先查看防火墙，

service iptables status

sestatus

如果都关闭了，再就需要验证ip、端口、服务

[oracle@dan admin]$ pin g 192.168.56.56 

[oracle@dan admin]$ telnet 192.168.56.56 1521

服务的话，就通过查看监听lsnrctl stauts 中的service 查看。

同样也可以验证串名：

[oracle@dan admin]$ tnspin g NEW

最后的最后。文件名一定要记住是tnsnames.ora     。。。。。。是有s的。这个搞了很傻

2 本地tnsnames