Siebel Administration >  Oracle XE - Siebel Local Database setup is Taking Unusually Long Time

Oracle XE - Siebel Local Database setup is Taking Unusually Long Time

APPLIES TO:
Siebel Financial Services CRM - Version 15.5 [IP2015] and later
Siebel CRM - Version 16.7 [IP2016] to 16.7 [IP2016] [Release V16]

ACTUAL BEHAVIOR
---------------

Siebel Local Database setup script is taking unusually long time

EXPECTED BEHAVIOR
-----------------------
Acceptable time to setup Siebel Local Database

STEPS
-----------------------

While running below command to setup Siebel Local DB, it took more than 4 days and it is still running.

C:\Siebel\15.0.0.0.0\Tools\bin\LocalDbSetup.exe -s C:\Siebel\15.0.0.0.0\Tools\ -o "SSD default instance" -t SIEBEL -u username-p pwd-r "Siebel Repository" -d LOCAL_XE -x "C:\Siebel\15.0.0.0.0\Tools\oraclexe" -l siebelxelog.txt -w Y -y "Y"

CAUSE
Developer Database size

Currently the utility does extract all the data and there is no switch to do it only for repository only.

This is a known issue as described in:

BUG 22219728 - ORACLE XE LOCAL DB EXTRACTS ALL DATA AND ERRORS WHEN DB EXCEEDS 11GB

SOLUTION

The way the local database setup script was designed to work is if the Siebel Server development database is pretty much a skeleton database with only the repository objects and very little customer data.

Make sure to have server DB size less than 11 GB before setting up Siebel Local Db for oracle XE using LocalDbSetup.exe utility