WebSphere brand IBM WebSphere Telecom Web Services Server, Version 7.1

Preparing to set up the database on Oracle

As you prepare to set up the Telecom Web Services Server database (TWSSDB), ensure that certain Oracle settings are configured correctly. You must also create a database user

Before you begin
You must have completed the following steps:
  • Installed and started a supported version of Oracle Database on the database server
About this task

For WebSphere® Telecom Web Services Server, you must create a database user. In this information center, the name twssuser is used; however, this is only an example and you can use another name. The user IDs must be created before creating the database tables. If you are using multiple database servers, you must create the user on each server.

A separate database for the Parlay Connector database is not required. If you plan to deploy any of the Parlay-based Web service implementations, the Parlay Connector can use database tables in TWSSDB.

Complete the following steps on the database server where you want to create the database. The provided script does not create the database. The script only adds new tables to an existing database. During the procedure you will need the Oracle SYSTEM user ID.

  1. Use the Oracle Database Configuration Assistant utility to create the database that WebSphere Telecom Web Services Server will use. You must create the following databases depending on your database topology:
    • If you are using a consolidated database topology, create one database: TWSSDB.
    • If you are using a distributed database topology, create the following databases (these names are recommended) :
      • TWSSDB
      • AGDB
      • ATTACHDB
      • SPMDB
      • ADMINDB
      • USAGEDB
      • PARLAYDB
      • SLADB
      • MESSAGEDB
  2. Optionally, adjust the logging level in the SystemOut.log to Severe or higher. This is necessary to suppress warning messages (J2CA0294W), that would otherwise display because direct JNDI lookup was deprecated in WebSphere Application Server version 6.0.
    For example:
    *=info:com.ibm.ejs.j2c.ConnectionFactoryBuilderImpl=severe
What to do next
After you have installed the TWSS base components and the Web service implementations, you will configure the Oracle database using the crtsrvOra.sh script. Refer to the topic Creating and configuring the Oracle database server instance.



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