Administering the Sun Business Process Manager Database

Running the Downloaded Scripts

Once you download the compressed database scripts and modify them as needed, you can run the scripts from a command line. The database user that executes these scripts must have permission to create tables and users. Review Viewing and Modifying Database Scripts in Enterprise Designer before running the scripts (additional information is also available in the Readme.txt file).

ProcedureTo run a downloaded database script

  1. Open a command window and navigate to the directory where scripts are located.

  2. Do one of the following:

    • For Oracle databases, enter the following command:

      install_db user password database

    • For Sybase and SQL Server databases, enter the following command:

      install_db user password server database

    • For DB2 databases, enter the following command:

      install_db user password database server

    Where:

    • user is the database username.

    • password is the database user password.

    • server is the name of the machine on which the database resides.

    • database is the database or SID name.


      Note –

      The default user and password created from these scripts is "bpm6user". You can modify the user, password, disk space allocated for tables, and user permissions. The table and column definitions should not be modified.