Oracle tnsnames.ora listener.ora 配置_(description=(address=(protocol=tcp)(host=orcl-db-

作者：小蓝xlanll | 2024-05-15 11:01:03

踩

(description=(address=(protocol=tcp)(host=orcl-db-01)(port=1521)))

环境描述：

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

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小蓝xlanll/article/detail/572554