IBM Support

OpenPages OPBackup is Failing with an "EXP-00003: no storage definition found for segment" message

Troubleshooting


Problem

When launching the OpenPages OPBackup utility, it is failing with an "EXP-00003: no storage definition found for segment" message

Symptom

The OPBackup utility is failing. It is not exporting the openpages.dmp and opworkflow.dmp files. The OPBackup log has several "EXP-00003: no storage definition found for segment" error messages.

export-db:
[echo] Exporting application portion of the OpenPages Database ...
[echo] Database Username:openpages Database Alias:SOX9I

[exec] Export: Release 9.2.0.4.0 - Production on Thu Oct 9 09:28:30 2008

[exec] Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


[exec] Connected to: Oracle9i Release 9.2.0.6.0 - Production
[exec] JServer Release 9.2.0.6.0 - Production
[exec] Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
[exec] . exporting pre-schema procedural objects and actions
[exec] . exporting foreign function library names for user OPENPAGES
[exec] . exporting PUBLIC type synonyms
[exec] . exporting private type synonyms
[exec] . exporting object type definitions for user OPENPAGES
[exec] About to export OPENPAGES's objects ...
[exec] . exporting database links
[exec] . exporting sequence numbers
[exec] . exporting cluster definitions
[exec] . about to export OPENPAGES's tables via Conventional Path ...
[exec] . . exporting table ACCESSTOKENS
[exec] EXP-00003: no storage definition found for segment(6, 9)
[exec] . . exporting table ACLS
[exec] EXP-00003: no storage definition found for segment(6, 265)
[exec] . . exporting table ACTIVEJOBS
[exec] EXP-00003: no storage definition found for segment(6, 393)
[exec] . . exporting table ACTORAPPPERMISSIONS
[exec] EXP-00003: no storage definition found for segment(6, 369)

Resolving The Problem

Make sure the database and the oracle client are at the same version. In the above example, the oracle client is at 9.2.0.4 while the oracle database is at 9.2.0.6.

[{"Product":{"code":"SSFUEU","label":"IBM OpenPages with Watson"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"}],"Version":"4.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1538

Document Information

Modified date:
15 June 2018

UID

swg21514033