Oracle tnsnames.ora listener.ora 配置

环境描述：

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)
    )
  )