You must provide property information about
the JDBC data sources for the Global Configuration Data (GCD)
database. Content Engine uses the data source information to connect to and update the GCD
database.
Ensure that the application server is running or stopped,
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. |
WebLogic Server |
Start the application server if it is not already
running. |
To configure the JDBC settings:
- 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,
filter by CM: Configure GCD JDBC Data Sources in
the Installation or Configuration Program column.
- If your configuration profile is not open in Configuration
Manager, open the profile.
- Right-click Configure GCD JDBC Data Sources in
the profile pane and select Edit Selected Task.
- Enter the property values for your database by using the
values in your worksheet.
In a high availability environment,
enter the following additional information for the Configure
GCD JDBC Data Sources task: - Database server name
- If you are using a highly available database for the Global Configuration Data (GCD), use the virtual
server name.
- 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))))
|
- 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.
(WebLogic only)
If the test fails, complete the following substeps to reset the data
source parameters before attempting the database connection test again:
- Start the WebLogic Server administrative
console.
- Click .
- Select the check box for the data source and then click Delete.
- Click Release.
- Select to save your changes.
- Ensure that the task is enabled. When the task
is disabled, the task name includes the text (disabled). To
enable the task, select Configure GCD JDBC Data Sources
(disabled) in the profile pane, and then either right-click
and choose Enable Selected Task from the context
menu, or click the Enable the Selected Task icon
in the task toolbar.
- Apply the JDBC property settings by right-clicking Configure
GCD 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 JDBC properties.
- Close the Configure GCD JDBC Data Sources task
pane. In this step, you created the GCD data sources.
You create the initial object store data sources later in the configuration
process.