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.
- Log in to the database server as root.
- 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.
- Run the following command to change
the permissions on the script.
chmod 755 crtsrvOra.sh
- 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.
- 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
- Launch
the crtsrvOra script by issuing the following
command:
./crtsrvOra.sh options
where: options corresponds
to the following values.Table 1. crtsrvOra configuration
valuesParameter |
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.