1 客户端配置
这个比较简单,只需要配置TNSNAMES.ORA就可以了,例如:
stdm =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.243.216.185)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =stdm)
)
)
2 CMAN服务器配置
先配置好CMAN服务器的TNSNAMES.ORA文件:
STDM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.243.216.185)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = stdm)
)
)
默认情况下,ORACLE安装不会包含CMAN,所以需要另外安装,安装好后,配置CMAN文件,如cman.ora
cman=
(configuration=
(address=(protocol=tcp)(host=DWGW1)(port=1522))
(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> administer cman
TNS-04077: WARNING: No password set for the Oracle Connection Manager instance.
Current instance cman is already started
Connections refer to (address=(protocol=tcp)(host=DWGW1)(port=1522)).
The command completed successfully.
CMCTL:cman> startup
3 数据库服务器配置
SQL> ALTER SYSTEM SET REMOTE_LISTENER="(address=(protocol=tcp)(host=10.243.216.185)(port=1522))"
SQL> ALTER SYSTEM SET LOCAL_LISTENER="(address=(protocol=tcp)(host=10.243.216.74)(port=1521))";
System altered.
SQL> alter system register;
System altered.
至此,整个配置完成,可以在客户端SQLPLUS连接数据库了。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/58242/viewspace-966678/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/58242/viewspace-966678/