Siebel Database Upgrade Guide > Upgrading the Siebel Database >

Regenerating SQL Files for a Siebel Upgrade

Environments: Development and production test.

If you enter incorrect information in the Database Server Configuration Utilities, then the SQL files they generate will be incorrect and must not be used. You must run the Utilities 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 generate SQL files, they create 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, then create a service request (SR) on My Oracle Support, or contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle's Application Expert Services.

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.

Related Topics

About the Siebel Database Configuration Utilities