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…