Upgrade Guide > Upgrading the Siebel Database >

Regenerating SQL Files for a Siebel Upgrade

Upgrades: All Siebel upgrades.

Environments: Development and production test.

If you enter incorrect information in the Database Server Configuration Utilities, the SQL files it generates will be incorrect and must not be used. You must run the utility again, enter the correct information, and regenerate the SQL files.

For example, you are upgrading a non-unicode database. You run the Database Server Configuration Utilities and enter that you are upgrading a unicode database. The SQL that the utility generates will be incorrect and cannot be used. You must regenerate the SQL files.

When the Database Server Configuration Utilities generates SQL files, it creates a lock file that prevents regenerating the SQL files. To regenerate the SQL files, you must delete the lock file.

Regenerating SQL files with the Database Server Configuration Utilities

1. Verify that the SQL files must be regenerated.

   Typically this is caused by entering incorrect information in the Database Server Configuration Utilities. If you are unsure if the files must be regenerated, contact Oracle's Siebel Technical Support for assistance.

2. Navigate to DBSRVR_ROOT\common (UNIX: DBSRVR_ROOT/common) and locate the file sqlgen.usg.

   This is the lock file that prevents the utility from regenerating the SQL files.

3. Delete the sqlgen.usg file.
4. Rerun the Database Server Configuration Utilities.