我在本机装了ORACLE客户端,在command窗口中如何连接不同服务器的数据库实例。
如:机器名SERVER1 实例名:ORCL1,test1
机器名SERVER2 实例名:ORCL2,test2
都用sys 密码:abcc:\>sqlplus /nolog
SQL>conn ?????如何连接上面的4个实例?
谢谢
如:机器名SERVER1 实例名:ORCL1,test1
机器名SERVER2 实例名:ORCL2,test2
都用sys 密码:abcc:\>sqlplus /nolog
SQL>conn ?????如何连接上面的4个实例?
谢谢
如:机器名SERVER1 实例名:ORCL1,test1
机器名SERVER2 实例名:ORCL1,test1
都用sys 密码:abc 如果实例名相同,我怎么连接?
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)ORCL_LOCALHOST.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
(SERVER = DEDICATED)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
) ORCL_LOCALHOST.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
(SERVER = DEDICATED)
)
)红色部分应该是你要连接的服务器地址吧比如192.168.1.1等等你写的server和localhost.localdomain,肯定连不上么
就是command连不上那应该写什么?