tomcat上发布项目报错ORA-12505, TNS:listener does not currently know of SID given in con
tomcat上发布项目报ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
我的java接口连接是
oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@210.41.166.92:1521:ORCL
以上两个也都没错呀
我的数据库用的oracle 11g r2在网上查到很多都说是oracle监听的问题我的监听配置如下:
# listener.ora Network Configuration File: /opt/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/app/oracle/product/11.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /opt/app/oracle/product/11.2.0/db_1)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 210.41.166.92)(PORT = 1521))
)
)
哪位大侠帮帮忙