当前位置:文档之家› oracle网络连接配置

oracle网络连接配置

网络连接配置实验
实验目的:掌握Oracle数据库的网络配置方法,熟悉掌握网络配置的各参数内容。

实验内容:Oracle网络连接配置过程的实验。

实验环境:Windows Server 2003 Enterprise Edition
实验步骤:
1、熟悉与网络配置相关的三个参数文件sqlnet.ora、tnsname.ora和listener.ora
Sqlnet.ora(位于客户端和服务器端,用于主机命名法和目录命名法)
路径:c:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
Sqlnet.ora文件内容:
# sqlnet.ora Network Configuration
#File: C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
tnsname.ora(位于客户端和与其它服务器通信的服务器端,主要用于本地命名法) 路径同上
Tnsname.ora内容:
# tnsnames.ora Network Configuration
#File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ydxz-5f49a22351)(PORT = 1521)) (CONNECT_DATA =
(SERVER = shared)
(SERVICE_NAME = test)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ydxz-5f49a22351)(PORT = 1521)) (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Listener.ora(只存在于服务器端)
路径同上
文件内容:
# listener.ora Network Configuration
#File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(sid_desc =
(sid_name = orcl)
(global_dbname = orcl)
(oracl_home = c:\oracle\product\10.2.0\db_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = ydxz-5f49a22351)(PORT = 1521))
)
)
2、熟悉网络连接中的五种命名方法,重点掌握本地命名方法。

3、用户和Oracle数据库服务器建立连接的过程
4、配置监听器
5、配置客户端
6、配置共享连接
7、调用外部过程。

相关主题