Mix job errors with 12c (4339673)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

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 contact
ORA-03113: end-of-file on communication channel
ORA-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

64bit
32bit
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

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title