环境描述：

Linux + Oracle

问题描述：

Oracle tnsnames.ora listener.ora 配置

解决办法：注意红色的标注

[root@orcl-db-01 ~]# cd $ORACLE_HOME/network/admin

[root@orcl-db-01 admin]# ls
listener.ora samples shrept.lst sqlnet.ora tnsnames.ora

listener.ora 配置：

[oracle@orcl-db-01 admin]$ cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/12.1.0.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl-db-01)(PORT =1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(SID_NAME = orcl)
)
)

tnsnames.ora配置：

[oracle@orcl-db-01 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 11.11.180.101)(PORT =1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl) ) )