远程登陆oracle
两台solaris机器a/b,都装了oracle 10g
如何用sql+从一台机器登陆到另一台机器?我只知道用户system/manager。
在a的tnsnames.ora中我加入了:
lion =
(DESCRIPTION =
(ADDRESS = (PROTOCOL=TCP) (HOST=139.24.222.73) (PORT=1521))
(CONNECT_DATA =
(SID = T001)
(SERVICE = lion)
)
)
139.24.222.73 是b的地址,然后在a上登陆:
root@seabird> sqlplus system/manager@lion
SQL*Plus: Release 10.1.0.4.0 - Production on Fri Feb 2 10:10:56 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12537: TNS:connection closed
本人新手。请教大牛解决方法,谢谢了!