使用的是MyEclipse2014+Oracle12c+JDK8+Tomcat8+PLSQL,所以另安了Oracle的32位客户端。下图为安装后的Oracle文件位置:
PLSQL照下图配置的话能登陆,但是MyEclipse却连不上数据库。
下面这张是MyEclipse的数据库连接配置:
现在的问题是报错:
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'pt.common.codeComparison' defined in class path resource [common-context.xml]: Cannot resolve reference to bean 'bill.database.tableaccessor' while setting bean property 'accessor'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'bill.database.tableaccessor' defined in class path resource [billtype-context.xml]: Cannot resolve reference to bean 'borm.objectRunService' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'borm.objectRunService' defined in class path resource [dm-context.xml]: Cannot resolve reference to bean 'borm.objectEngine' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'borm.objectEngine' defined in class path resource [dm-context.xml]: Cannot resolve reference to bean 'gap.cacheService' while setting bean property 'cacheService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'gap.cacheService' defined in class path resource [grp/pt/util/util-context.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [grp.pt.common.bs.CacheService]: Constructor threw exception; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12528, TNS:listener: all appropriate instances are blocking new connections
The Connection descriptor used by the client was:
127.0.0.1:1521:NIUyh
下图为查看监听状态:
下面5张图为监听器配置:
下图为Oracle各服务启动状态:
下图为listener.ora文件内容及其位置:
下图为两个tnsnames.ora文件内容及其地址(因为安装客户端时拷贝了一个到客户端文件下):
最后这张图是Oracle12c自带的jdbc文件下的包,换了ojdbc7dms_g到MyEclipse里无效,还是报错。
另外修改listener.ora文件和tnsnames.ora文件的方法已经试过,只是在NIUyh服务下多了一个静态监听实例,动态监听实例仍然是一个BLOCKED一个READY,还是无效。
求教到底哪里出问题了?我是新人,请尽量说详细一点,谢谢~