Question

Java连接oracle异常(error:ORA-12505)！

String driver = "oracle.jdbc.driver.OracleDriver"; //这个应该没错 String url = "jdbc:oracle:thin:@localhost:1521:jbitdb"; //我的数据库名称就是jbitdb

tnsnames.ora文件
JBITDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 20120916-1441)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = JBITDB) ) )
ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 20120916-1441)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )

listener.ora文件:
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = E:\oracle\product\10.2.0\db_1) (PROGRAM = extproc) ) )
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = 20120916-1441)(PORT = 1521)) ) )

异常情况

我的SID是jbitdb端口是1521都没写错啊，驱动JAR也导进去了，请问这是什么问题？

Answer 1

打开你的服务，然后看看oracle的listener启动正常吗，刷新一下。
然后确认一下你的服务里的oracle的sid是叫这个名字？
从报错信息看，jbitdb写错了

Answer 2

把HOST = 20120916-1441改为：localhost或127.0.0.1 确定你的数据库是否为jbitdb? 重启listener

Answer 3

是不是服务有个监听器没有启动，你只启动了数据库实例

Answer 4

数据能正确进入吗？先用客户端看看数据库能不能正确进去啊？