oarcle使用ipc协议配置方法

最新推荐文章于 2021-04-15 09:20:40 发布

huhu2007

最新推荐文章于 2021-04-15 09:20:40 发布

阅读量2k

点赞数 1

CC 4.0 BY-SA版权

分类专栏：数据库 oracle 文章标签：数据库网络

本文链接：https://blog.youkuaiyun.com/huhu2007/article/details/84509188

oracle 同时被 2 个专栏收录

3 篇文章

订阅专栏

数据库

2 篇文章

订阅专栏

本文介绍了如何在Windows 7 32位系统上配置Oracle 11g R2的IPC协议来实现同一台机器上的客户端与服务器之间的连接。通过详细设置listener.ora和tnsnames.ora文件，并展示具体的配置内容，使读者能够了解整个配置过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

使用ipc协议连接oracle，前提客户端与oracle server要在一台机器上。

When a process is on the same machine as the server, use the IPC protocol for connectivity instead of TCP. Inner Process Communication
on the same machine does not have the overhead of packet building and deciphering that TCP has.

一下是我本机window 7 32 bit；oracle 11g r2 的配置，我本地配置了多个oracle，我以ETL实例为例子。
1）配置listener.ora

# listener.ora Network Configuration File: 
C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
	  (ADDRESS = (PROTOCOL = IPC)(KEY = ETL))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = C:\app\Administrator

2）配置tnsnames.ora

# tnsnames.ora Network Configuration File: 
C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ETL_IPC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = ETL))
    )
    (CONNECT_DATA =
      (SID = ETL)
      (PRESENTATION = RO)
    )
  )

查看listener 状态
使用windows命令：lsnrctl -status

[img]http://dl2.iteye.com/upload/attachment/0091/8212/5dab7bf7-aea7-3947-b929-a2dad80764e3.jpg[/img]

OK，登录试下。

[img]http://dl2.iteye.com/upload/attachment/0091/8214/c4c8be2b-6f43-3e06-8049-d38f2e71c3ba.jpg[/img]