找到
%oracle_home%\network\ADMIN\tnsnames.ora
然后用记事本打开,将要连接数据库的信息加到里面就可以了。服务名 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 主机名或IP)(PORT = 端口))
)
(CONNECT_DATA =
(SID = 数据库的SID)
(SERVER = DEDICATED)
)
)
%oracle_home%\network\ADMIN\tnsnames.ora
然后用记事本打开,将要连接数据库的信息加到里面就可以了。服务名 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 主机名或IP)(PORT = 端口))
)
(CONNECT_DATA =
(SID = 数据库的SID)
(SERVER = DEDICATED)
)
)
sqlplus /nolog
conn user_name/user_passwd@myorcl_192.168.0.150
回车就可以了。
很好用的。