Open topic with navigation

TIBCO BusinessEvents® Enterprise Edition 6.3.1

# Running the Initialize Database Script as the DBA or System User

This script creates the TIBCO BusinessEvents user and initializes the database.

The tutorial uses the default username (`BE_USER`) and password (`BE_USER`). You can change the username by editing the BE_HOME/bin/ initialize_database_YourDBMS.sql script.

Warning: Running the `initialize_database_YourDBMS.sql` script deletes the user before creating it again. Running the `create_tables_YourDBMS.sql` drops all database tables before creating them again. This means you can run these scripts again during test phases of your project development, without having to take extra cleanup steps.

Procedure
1. Ensure your DBMS is running. Open a command window in BE_HOME/bin (default location of the scripts) and type the following command for Oracle (if you use the default SID you can omit @SID):

       sqlplus sys_user/sys_user_password@SID/@initialize_database_oracle.sql

   Type `exit` to exit and commit.

   If you are using SQL Server, use this instead:

       osql -S Your-Server -U sys_user -P sys_user_password -n -i initialize_database_sqlserver.sql

   This script creates the TIBCO BusinessEvents database user. This user must be used to run the other scripts. You see messages like the following:

          User dropped.
          User created.
          Grant succeeded.

   Tip: Using your database product, you can configure additional users to access the database, in addition to this user.

Did you find this helpful?

YesNo
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO BusinessEvents® Enterprise Edition

Copyright © 2004-2024. Cloud Software Group, Inc. All Rights Reserved.