Question

MyEclipse SSH三大框架用tomcat链接数据库报错

MyEclipse 10 + Struts 1 + Hibernate + Spring + Tomcat6.0 + Oracle 11g 启动tomcat时报错：ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
application.xml配置
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="oracle.jdbc.driver.OracleDriver">
</property>
<property name="jdbcUrl" value="jdbc:oracle:thin:127.0.0.1:1521:hlxk"></property>
<property name="user" value="userss"></property>
<property name="password" value="userss"></property>
<property name="maxPoolSize" value="40" />
<property name="minPoolSize" value="1" />
<property name="initialPoolSize" value="5" />
<property name="maxIdleTime" value="20" />
</bean>
listener.ora中相关配置：

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(SID_NAME = hlxk)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = hlxk)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)

ADR_BASE_LISTENER = D:\app\Administrator

数据库实例名：hlxk

Answer 1

hbwhypw 你的oracle版本和楼主的不是一个版本，楼主的是11g你的是10g，楼主的监听有问题，一般oracle安装后不用改配置文件，除非是你本机想连接服务器的时候需要加上个监听，但是不应该加到listener.ora这个文件，是在listener.ora这个文件添加实例和IP的。楼主的监听是他自己改过，安装初始listener.ora的HOST不是127.0.0.1是本机的计算机名字。楼主只需在重新配置监听即可。

Answer 2

freedomwang987说的是对的SID 有问题,但不是struts配置文件
我的是
(SID_DESC =
(GLOBAL_DBNAME = ORCL)<---
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)<---
)
你的是
(SID_DESC =
(SID_NAME = hlxk)<---
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = hlxk)<---
)

Answer 3

SID 有问题 可能是你的struts配置文件有错

Answer 4

服务名 是否正确