Check Point Integrity, Руководство по установке, Страница: 15 / 53

Integrity Advanced Server Installation Guide 10
To configure IBM DB2:
1. Create your database.
Be sure to specify the UTF-8 character set.
2. Record the database server host name.
3. Record your database port for connections with the Integrity Advanced Server.
4. Create the Integrity Advanced Server database name.
The preconfigured database name in Integrity Advanced Server is iss_main.
5. Record the database username and password for the Integrity Advanced Server.
To configure Oracle 9i:
1. Create your database.
Be sure to specify the UTF-8 character set.
2. Record the database server host name.
3. Record your database port for connections with the Integrity Advanced Server.
4. Create a user with the name ‘iss_main’ with a matching schema name.
5. Assign the user the ‘CONNECT’ and ‘RESOURCE’ roles and grant the following
system privileges:
ƒ QUERY REWRITE
ƒ
ALTER ANY PROCEDURE
ƒ
CREATE ANY PROCEDURE
ƒ
DROP ANY PROCEDURE
ƒ EXECUTE ANY PROCEDURE
ƒ
UNLIMITED TABLESPACE
6. In the Enterprise Manager Console, in Network | Databases | <database name> |
Instance | Configuration set the following parameters:
ƒ QUERY_REWRITE_INTEGRITY = TRUSTED
ƒ
QUERY_REWRITE_ENABLED = TRUE
ƒ
NLS_SORT= <blank>
Use a host name rather than an IP address to specify your database. This allows you
to later change your database.
Use a host name rather than an IP address to specify your database. This allows you
to later change your database.