用plsql能直接连上数据库吗?
在oracle里面通过sid连接,一般情况下sid与实例名相同,如果实例名连接不上,
可以通过登录system账号。
select instance_name from V$instance
通过上面这条sql查询sid.
//用的sid
private static String url = "jdbc:oracle:thin:@localhost:1521:neworcl";
//用的service_name,我的这两个一样
private static String url = "jdbc:oracle:thin:@localhost:1521/neworcl";
service_name是下面这种
tns配置,需要的是这个service_name
ceshi =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = neworcl)
)
)
参考这个
https://www.cnblogs.com/lixuwu/p/7127148.html