2台机器都装了orcal 11
一台机器(A机器 192.168.0.111)自己连自己的数据库是成功的.
另外一台(B机器192.168.0.222)也是一样配置的，也是可以连自己.
问题:
那么我A机器如何连接B机器orcl?我用下面的设置不行,哪里不对?下面的密码输入的是B机器的密码
------解决方案--------------------
除了楼上的，还要添加从访问机器oracle到被访问机器oracle的服务！用netca命令配置
------解决方案--------------------
我单机的数据库监听配置文件，参考
# listener.ora Network Configuration File: C:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oracle\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = npcs)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.128.151.99)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\oracle