加入收藏 | 设为首页 | 会员中心 | 我要投稿 源码网 (https://www.900php.com/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

配置oracle监听文件

发布时间:2020-12-24 11:22:23 所属栏目:百科 来源:网络整理
导读:配置oracle监听文件 如果自己配置的监听文件总是出错,可以复制线面的信息进到自己配置文件中更改主机信息即可 [[email?protected] admin]$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /oracle/oracle/11g/network/admin/tnsnames.ora

配置oracle监听文件
如果自己配置的监听文件总是出错,可以复制线面的信息进到自己配置文件中更改主机信息即可

[[email?protected] admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /oracle/oracle/11g/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.10)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
[[email?protected] admin]$ cat listener.ora
# listener.ora Network Configuration File: /oracle/oracle/11g/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = master.example.com)(PORT = 1521))
)
)

ADR_BASE_LISTENER = /oracle/oracle

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /oracle/oracle/11g)
(SID_NAME = orcl)
)
)
[[email?protected] admin]$

(编辑:源码网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    热点阅读