帮小弟看看,十分感谢

taxmma 2006-04-04 05:29:14
我使用如下可以连接,但是把"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
...全文
155 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
taxmma 2006-04-04
  • 打赏
  • 举报
回复
但是我在安装oracle的那台机器上却可以使用
MISDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.10.251)(PORT = 1521))
(CONNECT_DATA = (SERVICE_NAME = misdb1.db.chnsys)(SERVER = shared))
)
登陆上
taxmma 2006-04-04
  • 打赏
  • 举报
回复
报这个错误:
-----------------------------------------------------------------------
SQL> conn fb@misdb
Enter password:
ERROR:
ORA-12545: Connect failed because target host or object does not exist
-------------------------------------------------------------------------
有哪为大哥知道这是为什么呀!

3,491

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 高级技术相关讨论专区
社区管理员
  • 高级技术社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧