Veridata compare fails "I/O error writing "/tmp/nsort.pFFcd1": No space left on device" (Doc ID 1283955.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate Veridata - Version: 1.0.0.0 to 3.0.0.10 - Release: 1.0 to 3.0
Information in this document applies to any platform.

Goal

Veridata compare using server sorting fails.  Looking at the compare report, Veridata server sorting ran out of sort space on /tmp:

Error from source RHS. (BIGSORTRETRIEVE(NSort error -10 - (<libnsort>) IO_ERROR: I/O error occurred writing "/tmp/nsort.pFFcd1" offset 5490864128: No space left on device
))
Error from target RHS. (BIGSORTSUBMIT(NSort error -10 - (<libnsort>) IO_ERROR: I/O error occurred writing (partial - filesystem full?) "/tmp/nsort.q4hGFL" offset 1932402688: No space left on device
))

How can we configure Veridata server to write to a difference sort location?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms