> Installing the Administration Server > Appendix F: Manual Database Setup Steps

Installing the Administration Server

     Previous  Next    Open TOC in new window    View as PDF - New Window  Get Adobe Reader - New Window
Content starts here

Appendix F: Manual Database Setup Steps

 

Overview

Before running the ALES installation program, you must create a policy database and ALES user. If you choose not to accomplish this using the DBConfig tool, you may do so manually. This appendix describes the manual steps in the following sections:

 

Oracle

  1. To login to the Oracle database server as a database administrator, enter:
    2. sqlplus dba/password@ASERVER

    where:

    dba — username you use to access the database

    password — database administrator password

    ASERVER — name of the Oracle service (as defined in your tnsnames.ora file).

  2. To create the policy database, enter the following commands at the SQL> prompt:
    3. SQL>connect sys as sysdba
    SQL>create tablespace DATA datafile ‘C:/Oracle/oradata/ASI/data.dbf’
    size 10M autoextend on next 1M MAXSIZE 250M;
  3. To create a ASI role, enter:
    4. SQL> create role asi_role;
    SQL>     grant create session to asi_role;
    SQL> grant create table to     asi_role;
    SQL> grant create sequence     to asi_role; 
    SQL> grant create trigger to asi_role;

    where: asi_role is the new role.

    This automatically uses the default tablespaces generated when Oracle was installed, but you can specify and use any tablespaces.

  4. To create the ALES user, enter:
    5. SQL> create user username identified by password
    SQL> default tablespace DATA quota unlimited on DATA;

    where:

    username — name to assign to the new ALES user

    password — password to assign to the new user account

    unlimited — size of the tablespace (shown here as set to unlimited).

  5. To grant the ASI role with the necessary privileges to the ALES user, enter:
    6. conn sys as sysdba;
    grant asi_role to username;
    commit;

    In this case, you grant SELECT permission to the new ALES user. The Oracle database server does not allow you to grant the permission to the asi_role. ALES uses this dynamic view to check whether one of its tables is currently being accessed. Therefore, the SELECT permission is required.

  6. Exit SQLplus.

After performing these steps, the Administration Server may be installed as described in Installation.

 

Sybase

To install ALES with Sybase, you must first create the policy database and a ALES user account.

Note: BEA strongly recommends that you not use the dbo of the policy database as the policy owner. This requires additional database configuration that is beyond the scope of this guide.

Please refer to Creating Sybase Database Devices if you have not already created the required database devices asi_data_dev and asi_log_dev as shown in this section.

To set up a policy database and the ALES user, perform these steps:

  1. Log in as the System Administrator.
  2. At the command prompt, enter: isql -Usa -S server_name

    3. where server_name is the database server name.

  3. Enter the following commands:
    4. 1>use master
    2>go
    1>create database database_name on asi_data_dev = 250 
    log on asi_log_dev = 250
    2>go

    where

    database_name — name of the new database

    asi_data_dev — data device name

    asi_log_dev — log device name

    Note: You may use a larger minimum database size if needed.

  4. To set the database options, type the following commands at the isql command prompt:
    5. 1>use master
    2>go
    1>sp_dboption     sspolicy, "select into/bulkcopy", true
    2>go
    1>sp_dboption     sspolicy, "abort tran on log full", true
    2>go
    1>sp_dboption     sspolicy, "trunc log on chkpt", true
    2>go
    1>sp_dboption     sspolicy, "trunc. log on chkpt.", true
    2>go

    For more information on the sp_dboption system procedure, see Sybase Adaptive Server Enterprise Reference Manual: Procedures.

    Note: For development databases, set the trunc log on chkpt option to false if periodic dump transactions are not required. For production databases, set this option to true to back up and truncate the database and transaction logs.
  5. To create the ASI Database Login ID, enter the following at the isql command prompt:
    6. 1>use master
    2>go
    1>sp_addlogin asi, password, database_name, null, "asi login"
    2>go

    where:

    password — ALES user password, at least six alphanumeric characters or other characters allowed by Sybase

    database_name — name of the ALES database. If an asi login already exists, you must use the sp_modifylogin command to set its default database to database_name.

  6. To create the ALES user, enter the following at the isql command prompt:
    7. 1>use sspolicy
    2>go
    1>sp_adduser asi
    2>go
  7. To grant permissions to the ALES user, enter the following at the isql command prompt:
    8. 1>use sspolicy
    2>go
    1>grant all to asi
    2>go

After performing these steps, the Administration Server may be installed as described in Installation.

 

Microsoft SQL Server

To install ALES with Microsoft SQL Server, you must first create the policy database and a ALES user account. This section describes how to do this.

Note: Microsoft SQL Server JDBC drivers are not shipped with ALES. ALES uses the MSSQL 2005 JDBC driver for connectivity to both MSSQL 2000 and MSSQL 2005. You can find this driver on the Microsoft download site.

Perform the following steps:

  1. From the Window’s Start menu, select Programs->Microsoft SQL Server-> Enterprise Manager.
  2. From the File menu, select Action->New Database. Then enter the new database name and a collation name that creates the database in case-sensitive mode.

    3. Figure 5-1 shows that a database named asiadmin has been created.

    Figure 5-1 Adding a Microsoft SQL Database


    Adding a Microsoft SQL Database

  3. In the Enterprise Manager left pane, right-click Logins and select New Login. This opens the the Login Properties dialog box.
  4. In the Name field, enter a name for the new ALES user. Then select the SQL Server Authentication radio button and enter the desired password. Finally, select the new database from the Database dropdown field.
    5. Figure 5-2 Login Properties Dialog Box


    Login Properties Dialog Box

  5. On the Database Access tab, select the Permit checkbox for the new database/user. Then select the db_owner checkbox in the lower box and click OK.
    6. Figure 5-3 Database Access Dialog Box

Database Access Dialog Box

  1. Under the Database folder in the Enterprise Security Manager’s left pane, right-click the new database and select Properties from the context menu.
  2. On the Permissions tab, make sure the user has the proper permissions on (Create Table, Create View, and Create Default).

After performing these steps, the Administration Server may be installed as described in Installation.

 

PointBase 5.1

To install ALES with PointBase 5.1, you must first create the policy database and a ALES user account. This section describes how to do this.

To create the database and ALES user, perform the following steps:

  1. Start the PointBase database using the startPointbase.cmd/sh script located in Weblogic_Home/common/eval/pointbase/tools.
  2. Start the PointBase Console using the startPoinyBaseConsole.cmd/sh script located in Weblogic_Home/common/eval/pointbase/tools.
  3. In the Connect to Database dialog box, do the following:
    1. Modify the JDBC URL as follows:

      2. jdbc:pointbase:server://<server>/<database_name>

    2. Enter the desired ALES username and password.
    3. Select the Create new database radio button and click OK.
      4. Figure 5-4 Confirming the PointBase Configuration Settings

Confirming the PointBase Configuration Settings

Make sure the database is up when running the ALES installer, because the installer connects to the database and installs ALES-related tables.

After performing these steps, the Administration Server may be installed as described in Installation.

 

DB2 Universal DB Enterprise Server 9.1

To install ALES with DB 2, you must first create the policy database and a ALES user account. This section describes how to do this.

To create the database and ALES user, perform the following steps:

  1. Use the DB2 Control Centre to create a database for ALES or run the following SQL command:
    2. CREATE DATABASE ALES AUTOMATIC STORAGE YES ON 'D:\' DBPATH ON 'D:\' USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM PAGESIZE 16384;

    Notes:

    • Specify the path information appropriate to your environment.
    • the PAGESIZE must be 16384 or greater.
  2. Increase the database configuration parameter (applheapsz) to allow a larger application heap (from 256 to 512). The step also can be done by DB2 Control Centre.
  3. Create a new user for the database. This user must be based on a system account. On Windows, for example, the Windows user is selected when creating the new database user.
    4. Note: The password of the system account must satisfy DB2 requirements (such as a combination of numbers and letters) or creation of the DB user will fail.

After performing these steps, the Administration Server may be installed as described in Installation.


  Back to Top       Previous  Next