牛X的直连,通过 IP、端口、实例名 连接
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=
服务器地址)(PORT=
端口)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=
实例名)));User Id=
用户名;Password=
密码;
sqlplus
scott/midtiger@127.0.0.1:1521/orcl
参考:
http://s.yanghao.org/program/viewdetail.php?i=26700