You must create the JDBC data sources for each
object store that Content Engine uses. Content Engine uses the data source information
to connect to and update the object store database. By default, each
profile includes a task for creating the data sources for a single
object store.
Be sure that you have available
the Installation and Upgrade Worksheet that was completed during your
planning activities.
Tip: For more information on the properties and
values you set in Configuration Manager, roll your mouse over the
property name to view the hover help for the property.
- Open your completed Installation and Upgrade
Worksheet file.
Tip: In the worksheet file,
verify that the command is enabled.
To view only Configuration Manager values
for this task, filter by CM: Configure Object Store JDBC
Data Sources (object store 1) in the Installation
or Configuration Program column.
- Start or stop the application server, depending on its
type.
Table 1. Required application server stateOption |
Description |
WebSphere® Application
Server |
Start the application server if it is not already
running. |
JBoss Application Server |
Stop the application server. |
Oracle WebLogic Server |
Start the application server if it is not already
running. |
- If your configuration profile is not open in Configuration Manager, open it by selecting and
navigating to your profilename.cfgp file.
- Right-click Configure Object Store JDBC Data
Sources in the profile pane, and select Edit
Selected Task.
- Enter the property values for your data sources by using
the values in your installation worksheet.
In highly available environments, provide
the following additional information for the object store data sources: - Database server name
- If you are using a highly available database cluster, use the
virtual name of the cluster.
- Database server name RAC node n
- If you are using Oracle RAC, then you must enter the database
information for two nodes in the RAC cluster.
- Configuration Manager uses the values that you provided to create
the JDBC URL in the format shown in the following table:
Table 2. JDBC URL format for Oracle RACServer |
Description |
Example |
WebSphere |
jdbc:oracle:@
(DESCRIPTION = (load_balance=yes)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)
(HOST = rac node 1)
(PORT = 1521))(ADDRESS =
(PROTOCOL = TCP)(HOST = rac node 2)
(PORT = 1521)))
(CONNECT_DATA =(SERVICE_NAME =
DB service name)
(failover_mode = (type=select)
(method=basic)
(retries=retry number)(delay=
delay value))))
|
jdbc:oracle:
@(DESCRIPTION =(load_balance=yes)
(ADDRESS_LIST=(ADDRESS =
(PROTOCOL = TCP)(HOST = testrac1)
(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)
(HOST = testrac2)(PORT = 1521)))
(CONNECT_DATA =(SERVICE_NAME =
testracdb)(failover_mode =
(type=select)(method=basic)
(retries=32)(delay=4))))
|
Oracle WebLogic Server |
See the Oracle Technology Network Web
site, http://www.oracle.com/technology/documentation/index.html
Search for Configuring JDBC Multi
Data sources.
|
|
JBoss Application Server |
jdbc:oracle:@
(DESCRIPTION =(load_balance=yes)
(ADDRESS_LIST= (ADDRESS =
(PROTOCOL = TCP)
(HOST = rac node 1)
(PORT = 1521))(ADDRESS =
(PROTOCOL = TCP)
(HOST = rac node 2)
(PORT = 1521)))
(CONNECT_DATA =(SERVICE_NAME =
DB service name)
(failover_mode = (type=select)
(method=basic)
(retries=retry number)
(delay=delay value))))
|
jdbc:oracle:@
(DESCRIPTION =(load_balance=yes)
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)
(HOST = testrac1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)
(HOST = testrac2)(PORT = 1521)))
(CONNECT_DATA =(SERVICE_NAME =
testracdb)(failover_mode =
(type=select)(method=basic)
(retries=32)(delay=4))))
|
- Select to save your changes.
- Optional: WebSphere and WebLogic only. Click Test
Database Connection to test the connection to the database
by using the database user name, database server name, database name,
port number, and password that you provided. The test
does not create the data sources.
- Ensure that the task is enabled. When the task
is disabled, the task name includes the text (disabled).
To enable the task, right-click Configure Object Store
JDBC Data Sources (disabled) in the profile pane, and
choose Enable Selected Task from the context
menu.
- Apply the JDBC property settings by right-clicking Configure
Object Store JDBC Data Sources in the profile pane, and
selecting Run Task. Running the
configuration task can take several minutes. The task execution status
messages are displayed in the Console pane below the bootstrap properties.
- (JBoss only) Start the application
server.