如果自己配置的监听文件总是出错,可以复制线面的信息进到自己配置文件中更改主机信息即可
[[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]$
以上是内存溢出为你收集整理的配置oracle监听文件全部内容,希望文章能够帮你解决配置oracle监听文件所遇到的程序开发问题。
如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)