使用LoadRunner7.8测试Oracle

眼眼rhine · 发表于 2006-7-19 22:02:14

附件是我用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]

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