在CentOS5.1上安装了Oracle 10.2.0创建了同样的表空间和用户并导入了9.2下导出的dmp 文件,在em里可以看到导入的各数据库对象。Oracle 10.2.0的实例和监听器,emctl dbconsole可正常启动,但sqplus连不上数据库!同样的连接类和配置文件下,WEB应用连9i的库没问题,但改到10.2.0的库就出错,出错信息如下:CreateConnectionPool() Error in Connecting to the Database java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
Exception in BaseAction = . Exception Message : SQLException error on getting connection.Io 异常: The Network Adapter could not establish the connection
cn.gov.gzga.ksxt.services.common.SystemException: . Exception Message : SQLException error on getting connection.Io 异常: The Network Adapter could not establish the connection
at cn.gov.gzga.ksxt.persistence.common.JDBCConnection.getConnection(JDBCConnection.java:115)
at cn.gov.gzga.ksxt.persistence.common.PersistenceBase.getConnection(PersistenceBase.java:32)
at cn.gov.gzga.ksxt.persistence.login.LoginPersistence.checkUserExist(LoginPersistence.java:94)
at cn.gov.gzga.ksxt.services.login.LoginController.login(LoginController.java:38)
at cn.gov.gzga.ksxt.web.login.LoginAction.actionPerform(LoginAction.java:79)
at cn.gov.gzga.ksxt.web.common.BaseAction.perform(BaseAction.java:126)
at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1787)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at cn.gov.gzga.ksxt.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:619)
2008-6-11 15:40:19 org.objectweb.jotm.TransactionImpl timeoutExpired
信息: set rollback only (tx=469da3f805801_0_469da3f805801_0_)
我在VM6下装了多个虚拟机,再别的虚拟机的CentOS5.1里可成功连上,但在当前虚拟机里重新安装10g并导入dmp文件后却怎么也连不上。
请教高人这是什么原因?该如何解决?
Exception in BaseAction = . Exception Message : SQLException error on getting connection.Io 异常: The Network Adapter could not establish the connection
cn.gov.gzga.ksxt.services.common.SystemException: . Exception Message : SQLException error on getting connection.Io 异常: The Network Adapter could not establish the connection
at cn.gov.gzga.ksxt.persistence.common.JDBCConnection.getConnection(JDBCConnection.java:115)
at cn.gov.gzga.ksxt.persistence.common.PersistenceBase.getConnection(PersistenceBase.java:32)
at cn.gov.gzga.ksxt.persistence.login.LoginPersistence.checkUserExist(LoginPersistence.java:94)
at cn.gov.gzga.ksxt.services.login.LoginController.login(LoginController.java:38)
at cn.gov.gzga.ksxt.web.login.LoginAction.actionPerform(LoginAction.java:79)
at cn.gov.gzga.ksxt.web.common.BaseAction.perform(BaseAction.java:126)
at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1787)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at cn.gov.gzga.ksxt.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:619)
2008-6-11 15:40:19 org.objectweb.jotm.TransactionImpl timeoutExpired
信息: set rollback only (tx=469da3f805801_0_469da3f805801_0_)
我在VM6下装了多个虚拟机,再别的虚拟机的CentOS5.1里可成功连上,但在当前虚拟机里重新安装10g并导入dmp文件后却怎么也连不上。
请教高人这是什么原因?该如何解决?
cn.gov.gzga.ksxt.services.common.SystemException: . Exception Message : SQLException error on getting connection.No suitable driver found for
at cn.gov.gzga.ksxt.persistence.common.JDBCConnection.getConnection(JDBCConnection.java:115)
at cn.gov.gzga.ksxt.persistence.common.PersistenceBase.getConnection(PersistenceBase.java:32)
at cn.gov.gzga.ksxt.persistence.login.LoginPersistence.checkUserExist(LoginPersistence.java:94)
at cn.gov.gzga.ksxt.services.login.LoginController.login(LoginController.java:38)
at cn.gov.gzga.ksxt.web.login.LoginAction.actionPerform(LoginAction.java:79)
at cn.gov.gzga.ksxt.web.common.BaseAction.perform(BaseAction.java:126)
at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1787)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at cn.gov.gzga.ksxt.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:619)
我关了CentOS5.1的放火墙和Selinux问题依旧,是端口问题还是CentOS5.1的设置问题?希望高人给点线索
sqlplus ksxt/1234@remoteGZGA命令? 然后让这批处理命令随着XP系统的启动而自动执行?
双击后直接打开一个命令行终端 并自动进入C:\installClient目录下执行
sqlplus SYS/long0411@remoteGZGA as sysdba命令连接到远程的CentOS5.1中的10G服务端。该批处理命令可随着XP系统的启动而自动弹出一个命令行终端并执行sqlplus SYS/long0411@remoteGZGA as sysdba命令!
最好是能自动判断出如果远程Oracle 10g服务端是否正在开启、数据库实例能否连接上或局域网络中断时能判断出来,并在终端命令行中给出相应错误信息提示!
请教该如何实现?