My Oracle Support Banner

SAM Schema Failing With Error ORA-03101 using Oracle 12.2 DB (Doc ID 2537234.1)

Last updated on FEBRUARY 05, 2020

Applies to:

Siebel CRM - Version 19.1 and later
Information in this document applies to any platform.

Symptoms

While installing SAM (Siebel Approval Manager )using a Oracle 12.2 db and Siebel server version 19.1, ddlimp command to create SAM schema is failing
with these errors:

ERROR
-----------------------
Reading existing schema...
DDLIMP-ERR-0004: pfNativeError: 3101; szSQLState: S1000; szErrorMsg:
[tp][ODBC Oracle driver][Oracle]ORA-03101: invalid input data for
DDLIMP-ERR-0005: SQLTables: SQLTables


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run Siebel Approval Manager.exe

2. From \siebsrvr\bin  run command from the SAMschemaddlimp.log

ddlimp /c SAM_DSN /u SADMIN /p SIEBEL /a SIEBEL /l
C:\SAM\SAMSchema\SAMSchemaddlimp.log /f C:\SAM\SAMSchema.ctl /t y /i y /g
SSE_ROLE /n n

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.