Siebel Remote: Database Extract (DbXtract) Task Failing with Error 'ORA-25153: Temporary Tablespace is Empty'

(Doc ID 2308850.1)

Last updated on SEPTEMBER 26, 2017

Applies to:

Siebel CRM - Version 8.2.2.4.1 [IP2013] and later
Information in this document applies to any platform.

Symptoms

Siebel Remote / Replication / Anywhere - on version: 8.2.2.4.1 [IP2013]

Siebel DB Extract Fails on SrvrMgr

After a successful Generate New DB on SrvrMgr, running DB Extract fails after +10 minutes of processing

ERROR
-----------------------
SBL-SMI-00077: Component error, see the trace file for more information

and

[DataDirect][ODBC Oracle driver][Oracle]ORA-25153: Temporary Tablespace is Empty


STEPS
-----------------------
The issue can be reproduced at will in customer's environment with the following steps:
1. Setup the Siebel Remote environment;
2. Run GenNewDB task and see that completing fine;
3. Start similarly a DbXtract task - and see that completing with error after some time.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Remote / Developer users cannot have their Local DBFs extracted and initialized.

Cause

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