创建与管理侦听器.PPT

本章主要内容 使用DBC创建附加侦听器 使用DBC创建Oracle NET服务别名 使用DBC配置连接故障转移 使用Listener特性 使用Oracle Net Manager配置客户与中间层连接 使用tnsping测试Oracle Net连通性 描述Oracle Net服务 描述Oracle Net名称解析方法 1、Oracle的C/S实现 用户与服务器交互方式 odbc oci sql*plus(w) 用户与服务器进程的区别 用户进程生成SQL语句，服务器进程执行SQL语句。 2、Oracle Net与通信协议简介 3、建立会话 1）连接本地实例 2）名称解析 @ocp10g的解析： 希望使用的协议 运行数据库侦听器的ip地址 侦听器引入连接请求的端口 希望连接的实例名称 3）启动服务器进程 位置： %Oracle_home%:disk\oracle\product\10.2.0\db_1\ Listener、sqlnet、tnsname位置：%Oracle_home%\network\admin Tnsname内容 # tnsnames.ora Network Configuration File: c:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. OCP10G = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ibm)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ocp10g) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) Listener内容 # 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) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = ibm)(PORT = 1521)) ) ) 4、创建与管理侦听器 修改后的listener.ora文件 # listener.ora Network Configuration File: c:\oracle\product\10.2.0\db_1\network\admin\listener.ora # Generated by Oracle configuration tools. TRACE_LEVEL_L2 = OFF L2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.52)(PORT = 1522)) ) ) (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ibm)(PORT = 1522)) ) ) ) LOGGING_L2 = OFF SID_LIST_LISTENER = (SID_LIST