Shining’s blog–与君博弈,智者为王~

面：
1 客户端配置使用连接管理器(CMAN),可以让客户端通过装有CMAN的服务器来访问DB，而不是直接访问DB，因此CMAN整个配置涉及到三方
2 CMAN服务器配置    192.168.110.200
3 数据库服务器配置  192.168.110.100

以下是配置过程
1 客户端配置
这个比较简单，只需要配置TNSNAMES.ORA就可以了，例如：
orcl =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.110.200 )(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
2 CMAN服务器配置
先配置好CMAN服务器的TNSNAMES.ORA文件,与客户端配置一样.
默认情况下，ORACLE安装不会包含CMAN，所以需要另外安装，安装好后，配置CMAN文件，如cman.ora
cman=
(configuration=
  (address=(protocol=tcp)(host=192.168.110.200)(port=1521))
  (parameter_list =
    (aso_authentication_filter=off)
    (connection_statistics=yes)
    (log_level=off)
    (max_connections=256)
    (idle_timeout=0)
    (inbound_connect_timeout=0)
    (session_timeout=0)
    (outbound_connect_timeout=0)
    (max_gateway_processes=16)
    (min_gateway_processes=2)
    (remote_admin=on)
    (trace_level=off)
    (trace_timestamp=off)
    (trace_filelen=1000)
    (trace_fileno=1)
    (max_cmctl_sessions=4)
    (event_group=init_and_term,memory_ops)
  )

  (rule_list=
    (rule=
       (src=*)(dst=*)(srv=*)(act=accept)
       (action_list=(aut=off)(moct=0)(mct=0)(mit=0)(conn_stats=on))
    )
  )
CMAN安装好后，在samples下会有关cman.ora各个参数的详细说，在此不在列举。
cman.ora配置好后，启动CMAN
$cmctl
CMCTL> admin cman
Current instance cman is not yet started
Connections refer to (address=(protocol=tcp)(host=192.168.110.200)(port=1521)).
The command completed successfully.
CMCTL:cman> startup
3 数据库服务器配置

SQL> ALTER SYSTEM SET REMOTE_LISTENER=”(address=(protocol=tcp)(host=192.168.110.200)(port=1521))” 
SQL> ALTER SYSTEM SET LOCAL_LISTENER=”(address=(protocol=tcp)(host=192.168.110.100)(port=1521))”；
System altered.
SQL> alter system register;
System altered.
至此，整个配置完成，可以在客户端SQLPLUS连接数据库了。

有关文档可见Oracle® Database Net Services Administrator’s Guide

还需要做一次测试看看效果

• No Related Post