51Testing软件测试论坛

标题: 使用LoadRunner7.8测试Oracle [打印本页]

作者: 眼眼rhine 时间: 2006-7-19 22:02
标题: 使用LoadRunner7.8测试Oracle
附件是我用LR对ORACLE进行测试所写的一个简单文档，里面可能有错误或不恰当的地方，恳请大家指点。
在测试过程中，也出现了一些错误，希望大家能帮忙分析一下原因。常见的错误为：
第一种错误：
***********************************************************************
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Program Files\Mercury Interactive\LoadRunner\bin\mdrv.exe)(HOST=4-ZD-T1)(USER=?0_?))))

  VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
  Time: 19-7月 -2006 19:26:13
  Tracing not turned on.
  Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS: 协议适配器错误
ns secondary err code: 0
nt main err code: 530
TNS-00530: 协议适配器错误
nt secondary err code: 126
nt OS err code: 0

第二种错误：
Start auto log messages stack - Iteration 353. [MsgId: MMSG-10545]
Action.c(11): server_attach: ServerHandle=OraSrv1, ServerID="orcl" [MsgId: MMSG-61883]
Action.c(12): attr_set: TargetHandle=OraSvc1, SERVER=OraSrv1 [MsgId: MMSG-61879]
Action.c(13): attr_set: TargetHandle=OraSes1, USERNAME="system" [MsgId: MMSG-61879]
Action.c(15): attr_set: TargetHandle=OraSvc1, SESSION=OraSes1 [MsgId: MMSG-61879]
Action.c(16): session_begin: SvcCtxHandle=OraSvc1, SessionHandle=OraSes1 [MsgId: MMSG-61866]
Action.c(17): lrd_open_connection: Warning, return-code=LRDW1021 [MsgId: MMSG-61939]
Action.c(19): lrd_stmt: SELECT USER FROM DUAL [MsgId: MMSG-61930]
Action.c(22): lrd_fetch: 1 row(s) fetched [MsgId: MMSG-61979]
Action.c(29): lrd_ora8_stmt: StmtHandle=OraStm5, Text="select * from tab" [MsgId: MMSG-61884]
Action.c(37): lrd_ora8_fetch: StmtHandle=OraStm5, 69 row(s) fetched (no more data) [MsgId: MMSG-61979]
Action.c(42): lrd_ora8_stmt: StmtHandle=OraStm6, Text="select * from V$SYSSTAT" [MsgId: MMSG-61884]
Action.c(45): lr_think_time: 13.00 seconds. [MsgId: MMSG-15948]
Action.c(52): Error: lrdo_ora8_fetch: "OCIStmtFetch" return-code=OCI_ERROR, error-code=03113: [MsgId: MERR-61888]
Action.c(52): Error:    ORA-03113: 通信通道的文件结束 [MsgId: MERR-61888]
Action.c(52): lrd_ora8_fetch: ERROR, return-code=LRDE2009.  StmtHandle=OraStm6, 1 row(s) fetched [MsgId: MERR-61979]
End auto log messages stack. [MsgId: MMSG-10544]
第三种错误：
Start auto log messages stack - Iteration 1. [MsgId: MMSG-10545]
Starting action Action. [MsgId: MMSG-15919]
Action.c(11): server_attach: ServerHandle=OraSrv1, ServerID="orcl" [MsgId: MMSG-61883]
Action.c(12): attr_set: TargetHandle=OraSvc1, SERVER=OraSrv1 [MsgId: MMSG-61879]
Action.c(13): attr_set: TargetHandle=OraSes1, USERNAME="system" [MsgId: MMSG-61879]
Action.c(15): attr_set: TargetHandle=OraSvc1, SESSION=OraSes1 [MsgId: MMSG-61879]
Action.c(16): session_begin: SvcCtxHandle=OraSvc1, SessionHandle=OraSes1 [MsgId: MMSG-61866]
Action.c(17): Error: lrdo_open_connection: "olog" LDA/CDA return-code=00020: [MsgId: MERR-61889]
Action.c(17): Error:    ORA-00020: 超出最大进程数 (%s) [MsgId: MERR-61889]
Action.c(17): lrd_open_connection: ERROR, return-code=LRDE2009.  User="system", Server="orcl" [MsgId: MERR-61939]
End auto log messages stack. [MsgId: MMSG-10544]

急等回复！
因为文件太大，所以从附件中把图都删去了。

作者: ElaineCheng1211 时间: 2006-7-20 11:09
想问以下楼主,具体用LR测试oracle数据库的性能,能不能说说

作者: 眼眼rhine 时间: 2006-7-20 15:14
我对此也不是很清楚，我们是做了一个ORACLE应用，所以需要测一下，都急死了。
具体过程都在附件里，大部分都是我看LR的帮助文档和论坛里大家写的资料总结的。
你如果有问题咱们可以探讨一下。

作者: ElaineCheng1211 时间: 2006-7-20 16:05
谢谢LZ

作者: hhjmark2000 时间: 2007-4-11 15:01
我也出现Action.c(469): lrd_result_set: ERROR, return-code=LRDE2009 [MsgId: MERR-61209]这样的错误,该怎么解决啊?高手们

作者: Hopewell_Go 时间: 2008-8-14 15:22
学习中。。。

作者: kimixin 时间: 2009-8-4 15:55
THKS BUDDY

作者: flashtree 时间: 2009-11-16 11:24
标题: 回复 1# 的帖子
这个太有意思了，大家多发表意见啊

欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/)