51Testing软件测试论坛

标题: 紧急求助！安装补丁后采用oracle的项目无法启动 [打印本页]
作者: softpk    时间: 2009-5-21 01:21
标题: 紧急求助！安装补丁后采用oracle的项目无法启动
QC服务器为2003，jboss平台，所建项目一个域的项目采用的是sqlserver，另一个域下的项目用的oracle。在安装了vss版本控制补丁后。采用oracle数据库的域其中一个项目无法启动，后卸载补丁，问题仍旧存在，启动项目时弹出提示“"Failed to get Project Properties" ”详细信息内容如下
  1. jdbc:mercury:oracle://qcserver:1521;sid=ora9

  3. Messages:
  4. Failed to Test Connection;
  5. Test connection failed;
  6. Cannot build directory item for key '[qualitymanager_dfshenma_db@jdbc:mercury:oracle://qcserver:1521;sid=ora9(qualitymanager_dfshenma_db)]' in TD Tables Struct Dir;
  7. Failed to fill table struct for table null in database qualitymanager_dfshenma_db@jdbc:mercury:oracle://qcserver:1521;sid=ora9(qualitymanager_dfshenma_db);
  8. [Mercury][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied;

  10. Stack Trace:
  11. com.mercury.jdbc.base.BaseSQLException: [Mercury][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied

  13. at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source)
  14. at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source)
  15. at com.mercury.jdbc.oracle.OracleImplConnection.connectAndAuthenticate(Unknown Source)
  16. at com.mercury.jdbc.oracle.OracleImplConnection.open(Unknown Source)
  17. at com.mercury.jdbc.base.BaseConnection.connect(Unknown Source)
  18. at com.mercury.jdbc.base.BaseConnectionStartup.run(Unknown Source)
  19.         wrapped in com.mercury.optane.core.CTdException:
  20. at com.mercury.optane.core.db.CTdDriverManager.getConnection(CTdDriverManager.java:81)
  21. at com.mercury.optane.core.db.CConnectionPool.newConnection(CConnectionPool.java:624)
  22. at com.mercury.optane.core.db.CConnectionPool.tryToGetConnection(CConnectionPool.java:468)
  23. at com.mercury.optane.core.db.CConnectionPool.getConnection(CConnectionPool.java:293)
  24. at com.mercury.optane.core.db.CConnectionManager.getNotTransactedConnection(CConnectionManager.java:288)
  25. at com.mercury.optane.core.db.CConnectionManager.getConnection(CConnectionManager.java:266)
  26. at com.mercury.optane.core.db.CDatabaseFieldsInfo.obtainInfo(CDatabaseFieldsInfo.java:135)
  27.         wrapped in com.mercury.optane.core.CTdException: Failed to fill table struct for table null in database qualitymanager_dfshenma_db@jdbc:mercury:oracle://qcserver:1521;sid=ora9(qualitymanager_dfshenma_db)
  28. at com.mercury.optane.core.db.CDatabaseFieldsInfo.obtainInfo(CDatabaseFieldsInfo.java:161)
  29. at com.mercury.td.CTdDatabaseFieldsInfo.obtainInfo(CTdDatabaseFieldsInfo.java:80)
  30. at com.mercury.optane.core.db.CDatabaseFieldsInfo.<init>(CDatabaseFieldsInfo.java:77)
  31. at com.mercury.td.CTdDatabaseFieldsInfo.<init>(CTdDatabaseFieldsInfo.java:58)
  32. at com.mercury.td.CTdTablesStructDirectory.createDirectoryItem(CTdTablesStructDirectory.java:167)
  33. at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:81)
  34.         wrapped in com.mercury.optane.core.CTdException: Cannot build directory item for key '[qualitymanager_dfshenma_db@jdbc:mercury:oracle://qcserver:1521;sid=ora9(qualitymanager_dfshenma_db)]' in TD Tables Struct Dir
  35. at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:87)
  36. at com.mercury.td.CTdTablesStructDirectory.getDirectoryItem(CTdTablesStructDirectory.java:151)
  37. at com.mercury.optane.core.db.CAbsTablesStructDirectory.getDatabaseFieldsInfo(CAbsTablesStructDirectory.java:101)
  38. at com.mercury.td.saserver.directory.CProject.getProjectDbContext(CProject.java:1311)
  39. at com.mercury.td.saserver.api.logics.CAdminLogic.testConnection(CAdminLogic.java:610)
  40.         wrapped in com.mercury.optane.core.CTdException: Test connection failed
  41. at com.mercury.td.saserver.api.logics.CAdminLogic.testConnection(CAdminLogic.java:624)
  42. at com.mercury.td.saserver.web.CTdSiteAdminServlet.redirectTestConnection(CTdSiteAdminServlet.java:736)
  43. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  44. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  45. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  46. at java.lang.reflect.Method.invoke(Method.java:324)
  47. at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:554)
  48.         wrapped in com.mercury.optane.core.CTdException: Failed to Test Connection
  49. at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:560)
  50. at com.mercury.optane.core.web.CAbsServlet.processRequest(CAbsServlet.java:535)
  51. at com.mercury.optane.core.web.CAbsServlet.doPost(CAbsServlet.java:418)
  52. at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  53. at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
  54. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
  55. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  56. at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
  57. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
  58. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  59. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
  60. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
  61. at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
  62. at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
  63. at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
  64. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
  65. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
  66. at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:481)
  67. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
  68. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
  69. at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
  70. at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
  71. at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
  72. at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
  73. at java.lang.Thread.run(Thread.java:534)
复制代码
采用oracle的另一个项目可正常启动，在DB Server标签中测试其链接正常，但在有问题的项目中测试链接却失败。通过错误提示分析，感觉像是用户名密码的问题，但对比之前备份的dbid.xml，并没有什么变化。

看到08年kasimxiao的【QC 还原项目】的帖子，其中提到“2.查询分析器进入qcsiteadmin_db，输入：sp_change_users_login 'report'，可以看到td用户被孤立，还原数据库后无法登录qc都是因为td用户被孤立了，输入：sp_change_users_login 'update_one','td','td'，使登录用户和数据库的孤立用户对应起来。
（完成后进入qc后台可以看到所有用户、域以及项目都显示出来了，剩下的只需要还原每一个项目的数据库）”
请问在oracle中如何操作？

[ 本帖最后由 softpk 于 2009-5-21 01:28 编辑 ]
作者: 博一笑    时间: 2009-5-22 09:34
没看明白，但是从ORA-01017: invalid username/password; logon denied看
感觉你oracle帐户有问题



欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/) Powered by Discuz! X3.2