WebSphere brand IBM WebSphere Telecom Web Services Server, Version 7.1

Creating and configuring the Oracle database server instance

If you are using an Oracle database, you must create and configure the database server instance. After you perform this task, you will run the First Steps script to create the necessary database tables and complete your configuration.

Before you begin
Before you begin, you must have completed the following tasks:
  • Installed and started a supported version of Oracle Database on the database server
  • Performed the database configuration steps in the topic Preparing to set up the database on Oracle
  • Installed Telecom Web Services Server on the database server
About this task

Complete the following steps on the database server. If you are using a distributed database configuration, complete the steps on each server that will host a database.

  1. Log in to the database server as root.
  2. Copy the contents of the following applicable directories from the server where you installed the TWSS base components to the corresponding location on the database server.
    • was_root/installableApps/TWSS-Base/database, where was_root represents the WebSphere® Application Server installation location (for a shared database)
    • esb_root/installableApps/TWSS-Base/database, where esb_root represents the installation location of the WebSphere ESB (for a distributed database, Access Gateway migration)
    • was_root/installableApps/TWSS-Services/database (for a distributed database, MMS/MM7, SMS/SMP and WAPPUSH/SMPP migration)
    Note: This step is not necessary if the database server is located on the same physical server as the TWSS base components.
  3. Run the following command to change the permissions on the script.
    chmod 755 crtsrvOra.sh
  4. Open a command prompt and switch to the Oracle database administrator ID.
    su - oracle
    Note: This ID is oracle by default. If you use a different ID, modify the command accordingly.
  5. If you are not already in the directory to which you copied the database setup files, change to it. Example:
    cd was_root/installableApps/TWSS-Base/database
  6. Launch the crtsrvOra script by issuing the following command:
    ./crtsrvOra.sh options
    where: options corresponds to the following values.
    Table 1. crtsrvOra configuration values
    Parameter Description Recommended Value
    dbName Database name. If you are using a consolidated or shared database configuration, the recommended name is TWSS71. If you are using a distributed database configuration, use a name that describes the function of this database–for example, AGDBD for the Access Gateway. TWSS71
    dbAdmin Administrator user ID for the database instance, for example system. not applicable
    dbAdminPW Password for the administrator user ID. not applicable
    dbUser User ID for accessing the database. twssuser
    dbUserPW Password for the database user ID. not applicable
    INIT Use INIT to initialize the database instance. INIT
    infoflag TRUE to display informational messages while the database is being initialized.

    FALSE to suppress informational messages.

    TRUE
    Example (options are split across lines for ease in reading):
    ./crtsrvOra.sh TWSS71 system admin_password twssuser    
    user_password INIT TRUE           
                   
Results
When the crtsrvOra command completes, the database server instance has been configured. The result of the command is that the TWSS 7.1 database is created.
What to do next
Next, you will run the First Steps script to complete the configuration for Telecom Web Services Server. The First Steps script will create the necessary database tables.



Terms of use
(C) Copyright IBM Corporation 2009. All Rights Reserved.