环境描述：

Linux + Oracle

问题描述：

Oracle tnsnames.ora listener.ora 配置@H_301_7@

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

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

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

listener.ora 配置：@H_301_7@

[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@H_301_7@ # Generated by Oracle configuration tools.@H_301_7@ @H_301_7@ LISTENER =@H_301_7@ (DESCRIPTION_LIST =@H_301_7@ (DESCRIPTION =@H_301_7@ (ADDRESS = (PROTOCOL = TCP)(HOST = orcl-db-01)(PORT =1521))@H_301_7@ (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))@H_301_7@ )@H_301_7@ )@H_301_7@ @H_301_7@ SID_LIST_LISTENER = @H_301_7@ (SID_LIST = @H_301_7@ (SID_DESC = @H_301_7@ (GLOBAL_DBNAME = orcl)@H_301_7@ (SID_NAME = orcl)@H_301_7@ )@H_301_7@ )@H_301_7@

tnsnames.ora配置：@H_301_7@

[oracle@orcl-db-01 admin]$ cat tnsnames.ora@H_301_7@ # tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0.2.0/dbhome_1/network/admin/tnsnames.ora@H_301_7@ # Generated by Oracle configuration tools.@H_301_7@ @H_301_7@ ORCL =@H_301_7@ (DESCRIPTION =@H_301_7@ (ADDRESS = (PROTOCOL = TCP)(HOST = 11.11.180.101)(PORT =1521))@H_301_7@ (CONNECT_DATA =@H_301_7@ (SERVER = DEDICATED)@H_301_7@ (SERVICE_NAME = orcl) ) )