Return
-
Title
Mix job errors with 12c -
Description
Problems in both loading data and running the transaction mix job. All keep generating errors. Which stops the tests.
Messages:Agent ...Error: Statememt ...Transaction run failed by user in agent of...ORA-03135: connection lost contactORA-03113: end-of-file on communication channelORA-12592: TNS:bad packet -
Cause
-
Resolution
this is an issue while loading data against Oracle 12c, and this issue will be addressed in next release.The workaround is generate flat files by data generator and then load the data with oracle sql*loader, finally run the TPC-C mix test directly (remove "Create Objects for TPC-C" from job)Attached are generated both 32-bit and 64-bit -
Defect ID
BMF-5 -
Attachments
-
Additional Information
The issue affect all benchmarks on Oracle 12c. NOTE. you should create TPC-C objects before use sql*loader and need to create required indexes after loading data, you can create TPC-C tables and indexes without loading data see below http://www.toadworld.com/products/benchmark-factory/f/44/t/1160.aspx