WebSphere brand IBM WebSphere IP Multimedia Subsystem Connector, Version 6.2

Preparing Oracle

Create an Oracle database user and tables before installing Diameter Enabler.

Before you begin
Before you begin:
  • Oracle should be installed and running.
  • Oracle database should be created, and is referred to in the following procedure as diameter.
About this task
Some initial tuning values are provided; however, additional database tuning may be needed for optimal performance. Complete the following steps to create the appropriate user ID and database table:
  1. Log in to the Oracle server with a user ID that has database administrator authority, such as oracle.
  2. Start SQLPlus and connect to the diameter database with SYSTEM authority.
  3. Create an ID for the Diameter Enabler to access the database. The following commands create the user and gives the user the appropriate privileges:
    • create user diameter_user identified by password;
    • grant create session, create table, create sequence, exp_full_database, imp_full_database, unlimited tablespace to diameter_user;
    Where:
    • diameter_user is the new Oracle user ID Diameter Enabler will use to access the database.
    • password is the password for the diameter_user.
  4. Verify the correct users are created and have the correct privileges by typing the following command in SQLPlus:
    • select username from DBA_USERS;
    This command will list the existing users that have database privileges.
  5. Connect to the database with diameter_user using the following command:
    • connect diameter_user/password@diameter
    Where:
    • diameter_user is the new Oracle user ID Diameter Enabler will use to access the database.
    • password is the password for the diameter_user.
    • diameter is the database name
  6. Create the DIAMETERSHSUBSCRIPTION database table and the primary key using the following commands:
    • create table DIAMETERSHSUBSCRIPTION ( SERVERNAME VARCHAR2(250) NOT NULL, PUBLICIDENTITY VARCHAR2(250) NOT NULL, DATAREFERENCE INT NOT NULL, SERVICEINDICATION VARCHAR2(250) NOT NULL, CALLBACKURL VARCHAR2(250) NOT NULL, DATESUBSCRIBED DATE, USERID VARCHAR2(250), PASSWORD VARCHAR2(250), SUBSCRIBEUSERDATA SMALLINT NOT NULL ) PCTFREE 0 PCTUSED 0 LOGGING;
    • ALTER TABLE DIAMETERSHSUBSCRIPTION ADD CONSTRAINT PK_DIAMETERSHSUBSCRIPTION PRIMARY KEY (PUBLICIDENTITY, DATAREFERENCE, CALLBACKURL, SUBSCRIBEUSERDATA, SERVICEINDICATION, SERVERNAME);
  7. Create the DIAMETERROSUBSCRIPTION database table and the primary key using the following commands:
    • create table DIAMETERROSUBSCRIPTION ( SESSIONID VARCHAR2(250) NOT NULL, DESTINATIONREALM VARCHAR2(250) NOT NULL, CALLBACKURI VARCHAR2(250), DATESUBSCRIBED DATE, DATEEXPIRESSECONDS NUMBER(19 , 0) NOT NULL, USERID VARCHAR2(250), PASSWORD VARCHAR2(250) ) LOGGING;
    • ALTER TABLE DIAMETERROSUBSCRIPTION ADD CONSTRAINT PK_DIAMETERROSUBSCRIPTION PRIMARY KEY (SESSIONID, DESTINATIONREALM);
What to do next
To improve performance, you may need to create a separate table space for the DIAMETERSHSUBSCRIPTION and DIAMETERROSUBSCRIPTION tables and complete additional database tuning.



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