Siebel Administration >  DBCHCK Utility and database logical integrity in Siebel

DBCHCK is Siebel supplied utility to compare the Logical Schema in the Siebel Repository against the Objects in the Physical Oracle Database.

DBCHCK should be run regularly to check the status of the Siebel Enterprise, particularly following a release.

DBCHCK can be useful to to identify custom indexes added by the development team but not added to the Repository using Siebel Tools.
Example - http://docs.oracle.com/cd/B31104_02/books/ImpAppsDB2390/ImpAppsDB2390_InstallDBServeDB2390_38.html
You can run it from any one server in the environment. One run per database connection.

this should be run from the siebsrvr folder

e.g.

dbchck /s DSN_NAME /u sadmin /p password /t siebel /r "Siebel Repository" /l /tmp/dbchck-UAT.log /dict /all

result example

dbchck /s DSN_NAME /u sadmin /p ***** /t siebel /r "Siebel Repository" /l /tmp/dbchck-UAT.log /dict /all

dbchck: Logging into source "DSN_NAME" as user "sadmin"...
dbchck: Connected to Oracle (table owner: siebel, schema version: 45.19.0.29).
dbchck: Loading application dictionary (repository: Siebel Repository) ...
dbchck: Identified 4468 tables (0 columns) to check.
dbchck: Checking completed: no checks failed.
You have new mail in /var/mail//siebel

It is a good idea to run it every time there is a new deployment/upgrade in Siebel. It checks if the repository import is ok