WSRR V7 ON AIX WITH ORACLE群集安装记录8

Before you can run scripts to create an Oracle database manually, you must customize them for WSRR. WSRR can be configured using any of the following databases:

    WSRR

    Activity Logging

    Service Integration Bus

You can create these databases separately or alternatively, you can create the Activity Logging and Service Integration Bus tables in the WSRR database.

Use the following values:

Table 1. Oracle values for WSRR

Value name

Value description

$ORACLEPATH

The Oracle installation directory.

$ACT_DB_NAME

Activity Logging database name.

$DB_NAME

Database name.

$DB_USER

User in the Oracle database (default is SYSTEM).

$ORAUSER

The operating system ID owning the oracle installation (someone with permission to run sqlplus).

$SIB_DB_NAME

Service Integration Bus database name.

$SIBSCHEMA

The SIBus database schema, typically WSRRSIB.

$SQLPATH

Path to the SQL files, usually for example, install_root/WSRR/dbscripts/oracle.

Note: You must use the ojdbc6.jar file, which is the Java version 1.6 JDBC driver. If you are using Oracle10g this is a separate download from the oracle.com website.

Procedure

1. Create the database If you want to use an existing database skip this step.

Note: The WSRR Oracle database must be in UTF-8.

Set the following parameters to these values:

    CHARACTERSET = “AL32UTF8

    NATIONALCHARACTERSET= “UTF8”

a. Edit install/database/sql/oracle/dbca.rsp.

Replace all instances of __VARFILEPATH__ with the directory where variables.txt can be found ($SQLPATH).

Replace all instances of __DBNAME__ with $DB_NAME

b. As $ORAUSER run:

$ORACLEPATH/bin/dbca -silent -responseFile $SQLPATH/dbca.rsp

c. Set the password for the SYSTEM and SYS database users to be $DB_PASSWORD, or some other appropriate value, if you are going to be creating a new database user.

You can, optionally, use the following script to do this. Edit install/database/sql/oracle/dbaccess.sql

a. Replace all instances of __DBNAME__ with $DB_NAME.

b. Replace all instances of __DBPASSWORD__ with $DB_PASSWORD.

c. Export the ORACLE_SID environment variable.

d. As $ORAUSER run:

$ORACLEPATH/bin/sqlplus /nolog @$SQLPATH/dbaccess.sql

Repeat this step for the Activity Logging database (using $ACT_DB_NAME in place of $DB_NAME) and the Service Integration Bus database (using $SIB_DB_NAME in place of $DB_NAME) if you would like those tables to be in separate databases.

2. Create a database user If you want a user ID other than SYSTEM for $DB_USER, create that user ID now following the usual Oracle process. The user ID will have privileges similar to those detailed in the following (this might not be an exhaustive list):

SELECT ANY DICTIONARY, “CONNECT”, “EJBCLIENT”, “EXECUTE_CATALOG_ROLE”, “MGMT_USER”, CREATE TABLE, CREATE SESSION, CREATE SEQUENCE, CREATE TABLESPACE, ALTER TABLESPACE, MANAGE TABLESPACE, SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE, CREATE VIEW

These privileges are needed only during installation. After installation, you need only create, update, select, and delete permissions for most WSRR database tables.

The WebSphere Service Integration Bus needs TRUNCATE permission on the Service Integration Bus database tables (contained in createsib.sql), which means that either the database user has to own the Service Integration Bus tables or it must have DROP ANY TABLE permission.

Repeat this step for the Activity Logging and Service Integration Bus databases if they are separate.

3. Create the database tables .

a. Edit all .sql files in $SQLPATH and replace __DBUSER__ with the value of $DBUSER.

b. Edit $SQLPATH/createSibTables.sql and replace all instances of __SIBSCHEMA__ with the value of $SIBSCHEMA.

c. Export the ORACLE_SID environment variable if you have not already done so.

d. As $ORAUSER run:

$ORACLEPATH/bin/sqlplus $DB_USER/$DB_PASSWORD@$DB_NAME @$SQLPATH/createWsrrTables1.sql
$ORACLEPATH/bin/sqlplus $DB_USER/$DB_PASSWORD@$DB_NAME @$SQLPATH/createWsrrTables2.sql
$ORACLEPATH/bin/sqlplus $DB_USER/$DB_PASSWORD@$DB_NAME @$SQLPATH/createWsrrProcs.sql
$ORACLEPATH/bin/sqlplus $DB_USER/$DB_PASSWORD@$ACT_DB_NAME @$SQLPATH/createActTables.sql
$ORACLEPATH/bin/sqlplus $DB_USER/$DB_PASSWORD@$SIB_DB_NAME @$SQLPATH/createSibTables.sql

4. If there are any errors, or failure is indicated in your database client output, fix the reported errors and try again.

 

注:以上信息是来自于wsrr7 Infocenter的信息,从中可以看出具体的创建数据库与数据表的步骤,由于这次安装WSRR7的数据库实例已由ORACLE的数据库管理员创建好,那么,

以下文章点击率最高

Loading…

     

如果这文章对你有帮助,请扫左上角微信支付-支付宝,给于打赏,以助博客运营

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注