如果要连接这样的一个数据库
1.用pl/sql developer
user:user
password:password
database:_tech@202.113.13.84:1521
2.用命令行连接
语法:sqlplus usr/pwd@//host:port/sid
连接不上的话
可以在oracle的文件中配置一下
oracle/ora92/network/admin下的tnsnames.ora中添加:(这里地址可能不一样,但是只要找到tnsnames.ora即可,10g中好像是/oracle/product/10.2.0/db_1/NETWORK/ADMIN/tnsnames.ora)
_tech=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 202.113.13.84)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tech)
(SERVER = DEDICATED)
)
)