SQLPlus的可用参数如下:
tnsnames.ora文件的内容举例:
net_service_name =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = localhost)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = orcl)
)
)
使用 SQLPlus连接数据库的方式如下:
1. 使用服务别名
CONNECT scott/tiger@net_service_name
2. 使用完整连接字符串
CONNECT scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com)))
连接字符串中不能有空格,除非使用 (') 或 (")将它包起来
CONNECT scott/tiger@'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com)))'
参考文档
Oracle Database - Connect String (Client Connection Initiation)