JDBC连接Oracle数据库时出现的ORA-12505错误及解决办法.
补充:JDBC连接Oracle数据库时,jdbc.properties常用配置:
如下
bme.driver=oracle.jdbc.driver.OracleDriver
bme.url=jdbc:oracle:thin:@10.166.37.16:1521:ora11g
bme.username=sdu
bme.password=2J3VOd8/5+VzWR+LOPYXjA==
但是在67环境配置时,出现出现的ORA-12505错误
通过另一种配置,可以解决,
如下:
bme.driver=oracle.jdbc.driver.OracleDriver
bme.url=jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.166.46.67)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora11g)))
bme.username=sdu
bme.password=2J3VOd8/5+VzWR+LOPYXjA==