Since WebCenter 12.1, it is no longer necessary to run the database schema scripts manually. The database schema scripts can now be run from the installer dialog, for both local and remote databases.
When the database scripts are run automatically, a system console readout window will show feedback on the progress. Individual SQL statement blocks are displayed as they are being executed.
To run the database scripts automatically, database connection parameters need to be entered in the Database Configuration dialog which is displayed during the installation of the WebCenter Application Server:
- Choose your database type from the Database program list.
- Enter the database host name in the Database Server system field.
- For SQL, enter the instance name in the Database Instance Name field.
- For Oracle, enter the SID in the Database System Identifier (SID) field.
- The checkbox Run DB update scripts during installation determines whether the database schema scripts are run automatically during installation (preferred), or not.
- If running the scripts automatically is enabled, the DB sysadmin connection password field becomes available. Enter the password of the default database administrator user for your Database Server in this field.
If you still want to run the scripts manually, do the following:
- Locate the ServerTools\update_db.bat file in your WebCenter installation folder (for example C:\Esko\Artios\WebCenter\ServerTools\update_db.bat).
- Run this file with the appropriate parameters in the console.
Run this file without parameters first to see help about which parameters you need to use.
- If you have a SQL database, you will see this:
- If you have an Oracle database, you will see this:
