메모리를 좀 아껴볼려고, MTS test 를 하는데 잘 안되는 군요.
remote client 가 listener 를 통해서 dispatcher 중 하나랑 connect 되야 할 것
같은데, 잘 안되는 군요.
shell>> netstat -tanp
tcp 0 0 xxx:1521 yyy:1241 ESTABLISHED 6695/oracleORCL
tcp 0 0 xxx:1521 0.0.0.0:* LISTEN 6692/tnslsnr
tcp 0 0 0.0.0.0:1255 0.0.0.0:* LISTEN 6461/ora_d000_ORCL
* xxx : server ip
yyy : client ip
위와 같이 나오면 dispatcher 랑 connect 안된 거 맞죠.
initORCL.ora
listener.ora
tnsnames.ora
를 다음과 같이 바꾸었습니다.
[initORCL.ora]
mts_dispatchers = "tcp,1"
mts_max_dispatchers = 10
mts_servers = 2
mts_max_servers = 10
mts_listener_address = "(address=(protocol=tcp)(host=xxx)(port=1521))"
mts_service=martdb;
[listener.ora]
STARTUP_WAIT_TIME_LISTENER = 0
LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))
(ADDRESS = (PROTOCOL = TCP)(Host = xxx)(Port = 1521))
)
CONNECT_TIMEOUT_LISTENER = 10
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(GLOBAL_DBNAME = martdb)
(ORACLE_HOME = /u01/app/oracle/product/8.1.6)
(server=shared)
)
)
TRACE_LEVEL_LISTENER = OFF
[tnsnames.ora]
testdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = xxx)(Port = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xxx)
)
)
|