直接写不用配置:sqlplus portal/portal@192.168.11.10:1521/orcl @前不能空格
文件目录:F:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN
文件名:tnsnames.ora
XTJK是连接名 随便自定义
PROTOCOL:连接的协议
HOST:连接的IP地址
PORT:端口
Service_Name: 要连接数据库的实例名
XTJK =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.54)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)