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

Stringdriver="oracle.jdbc.driver.OracleDriver";//这个应该没错Stringurl="jdbc:oracle:thin:@localhost:1521:jbitdb";//我的数据库名称就是jbitdbtnsnames.ora文件JBITDB=(DESCRIP...

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也导进去了，请问这是什么问题？

展开