>>이창훈 님께서 쓰시길<<
:: 메모리를 좀 아껴볼려고, 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)
:: )
:: )
//버젼별 MTS셋팅방법
8.1.6
MTS_DISPATCHERS = "(ADDRESS= (PROTOCOL= TCP)(Host=hostip))(dispatchers=5)"
MTS_MAX_SERVERS = 10
MTS_SERVERS = 5
LOCAL_LISTENER = "(ADDRESS_LIST= (ADDRESS=(PROTOCOL= TCP)(Host=hostip)(Port= 1521)))"
8.0.5
mts_dispatchers="ipc,1"
mts_dispatchers="tcp,5"
mts_max_dispatchers=10
mts_servers=30
mts_max_servers=100
mts_service=SID
mts_listener_address="(ADDRESS= (PROTOCOL= IPC))"
mts_listener_address="(ADDRESS= (PROTOCOL= TCP)(Host=hostip)(Port= 1521))"
8.1.5
mts_max_dispatchers=20
MTS_DISPATCHERS = "(PROTOCOL=TCP)(DISPATCHERS=15)(SERVICE=ORA8)(LISTENER=LISTENER)"
# (MULTIPLEX=BOTH)
# (POOL=ON)
# (SSESSIONS=254)
# (TICKS=1)
mts_servers=20
mts_max_servers=50
//확인방법
%>lsnrctl service
Services Summary...
ORCL has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
ORCL has 6 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
D06 <machine: xxx, pid: 16742>
(ADDRESS=(PROTOCOL=tcp)(HOST=xxx)(PORT=39202))
...
%>sqlplus scott/tiger@ORCL
%>lsnrctl service
Services Summary...
ORCL has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
ORCL has 6 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
DISPATCHER established:1 refused:0 current:0 max:1022 state:ready <------
D06 <machine: xxx, pid: 16742>
(ADDRESS=(PROTOCOL=tcp)(HOST=xxx)(PORT=39202))
...
DISPATCHER established:1 <-----이렇게 나오면
아님
%>sqlplus system/manager@ORCL
SQL>select username,server from v$session;
하심
USERNAME SERVER
------------------------------ ---------
DEDICATED
DEDICATED
DEDICATED
DEDICATED
DEDICATED
DEDICATED
SYSTEM SHARED <------ㅡMTS접속
이겠죠.참고로 접속시
scott/tiger@alias명으로 접속해야 MTS
scott/tiger는 DEDICATED접속입니다.
|