本文详细介绍了Oracle数据库中listener.ora、tnsnames.ora及sqlnet.ora三个关键配置文件的内容。这些文件用于定义监听器设置、网络连接和服务名称等，是确保Oracle数据库网络通信正常的重要组成部分。
以下是我的三个文件：
##########################################below is listener.ora
# LISTENER.ORA Network Configuration File: E:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = websvr)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ickey)
(ORACLE_HOME = E:\Oracle\Ora81)
(SID_NAME = ickey)
)
)
#############################################below is tnsnames.ora
# TNSNAMES.ORA Network Configuration File: E:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ICKEY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = websvr)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DEDICATED)
)
)
ICKEY_127.0.0.1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ickey)
(SERVER = ickey)
)
)
EXTPROC_CONNECTION_DATA.CHINAWEBHOME.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
####################################
# Date..........: Wed Oct 17 21:38:48 CST 2001
####################################
########################################################below is sqlnet.ora
# SQLNET.ORA Network Configuration File: E:\Oracle\Ora81\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = chinawebhome.com
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
扫一扫
5427
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
