SID格式:
jdbc:oracle:thin:@<host>:<port>:<SID>
如: jdbc:oracle:thin:@192.168.1.1:1521:orcl
ServiceName格式:
jdbc:oracle:thin:@//<host>:<port>/<service_name>
如: jdbc:oracle:thin:@//192.168.1.1:1521/orcl
查看数据库SID名(查询窗口)select instance_name from v$instance;
查看数据库服务名(命令窗口)show parameter service;