帮小弟看看,十分感谢
我使用如下可以连接,但是把"server=dedicated"改为"server=shared"怎么就连不上了?
MISDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.10.251)(PORT = 1521))
(CONNECT_DATA = (SERVICE_NAME = misdb1.db.chnsys)(SERVER = shared))
)
我的oracle是MTS模式呀:
----------------------------
LSNRCTL> service
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
Services Summary...
PLSExtProc has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
misdb1 has 4 service handler(s)
DISPATCHER established:1 refused:0 current:1 max:254 state:ready
D002 <machine: misserver2, pid: 1547>
(ADDRESS=(PROTOCOL=tcp)(HOST=misserver2)(PORT=32773))
DISPATCHER established:1 refused:0 current:1 max:254 state:ready
D001 <machine: misserver2, pid: 1545>
(ADDRESS=(PROTOCOL=tcp)(HOST=misserver2)(PORT=32771))
DISPATCHER established:0 refused:0 current:0 max:254 state:ready
D000 <machine: misserver2, pid: 1543>
(ADDRESS=(PROTOCOL=tcp)(HOST=misserver2)(PORT=32770))
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
The command completed successfully