Oracle 11g:
sqlplus username/password@ip:port/dbname
Oracle 9i:
Sqlplus username/password@ DATABASENAME
把oci.dll所在的目录拷贝到plsql Toolspreferences OracleHome
D:\app\Administrator\product\11.1.0\db_1\BIN
在OCI Library添加oci.dll
d:\app\Administrator\product\11.1.0\db_1\bin\oci.dll
注:DATABASENAME在tnsnames.ora定义,它里面定义了ip和port
#DATABASENAME =
# (DESCRIPTION =
# (ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
# )
# (CONNECT_DATA =
# (SERVICE_NAME = servicename)
# )
# )
Oracle实现远程连接:
Username/Password@IP : Port/DBName Ps: sys/maksim@127.0.0.1:1521/orcl