|
To enable WebLogic Server and your AEM
forms on JEE deployment to connect to the Oracle 11g or 12c database,
you must create a database connection for WebLogic Server by setting
up a connection pool and a data source.
Create a new data source for Oracle on WebLogic 12.1.1
-
Start the WebLogic administration console
by typing
http://[hostname]:[port]/console
in the
URL line of a web browser.
-
Type the user name and password that you created for the
WebLogic Server domain and click
Log In
.
-
Under Change Center, click
Lock & Edit
.
-
Under Domain Structure, click
Services
>
JDBC
>
Data Sources
and,
in the right pane, click
New
, and select
Generic Data Source
from
the drop-down menu.
-
On the next screen, set the following properties:
-
In the
Name
box, type
IDP_DS
.
-
In the
JNDI name
box, type
IDP_DS
.
-
In the
Database Type
list,
select
Oracle
and click
Next
.
-
In the
Database Driver
list, select
Oracle's Driver(Thin) for Instance Connections; Versions:9.0.1 and later
:
-
Click
Next
and select
Supports Global Transactions
and
Emulate Two-Phase Commit
.
-
Click
Next
and define the following properties that
apply to the Oracle database that you created during your AEM forms
on JEE installation preparations:
Database Name:
The
name of the database you have created.
Host Name:
The
name or IP address of the computer on which Oracle is running.
Port:
Database
Port. The default is 1521.
Database User Name:
The
name of the user you created on the Oracle database.
Password
and
Confirm Password:
The
password associated with the user.
-
Click
Next
and then click
Test Configuration
to
verify the configuration settings
Note:
If the
test is successful, a “Connection test succeeded” message appears. Click
Next
.
Otherwise, review the error message that appears and modify the settings
as required until the test succeeds.
-
On the next screen, select the server that the data source
will connect to (in this case, the managed server) and then click
Finish
.
Configure the connection pool settings
-
Under Domain Structure, click
Services
>
JDBC
>
Data Sources
and,
in the right pane, click
IDP_DS
.
-
On the next screen, click the
Configuration
tab and
the
Connection Pool
tab.
-
In the
Maximum Capacity
box, type
30
.
-
In the
Statement Cache Size
box, type 80.
-
Click
Save
and then click
Activate Changes
.
-
Restart WebLogic managed server.
Create a new data source for Oracle for Rights Management on WebLogic 12.1.1
Note:
This procedure applies
only if you have Rights Management installed.
-
Under
Change Center, click
Lock & Edit
.
-
Under Domain Structure, click
Services
>
Data Sources
and,
in the right pane, click
New
.
-
On the next screen, set the following properties:
-
In the
Name
box, type
RM_DS
.
-
In the
JNDI Name
box, type
EDC_DS
.
-
In the
Database Type
list, select
Oracle and
click
Next
.
-
In the
Database Driver
list, select
Oracle’s Driver (Thin) for Server Connections; Versions: 9.0.1,9.2.0,10,11
-
Click
Next
and select
Supports Global Transactions
and
One-Phase Commit
.
-
Click
Next
and define the following properties that
apply to the Oracle database you created during your AEM forms on
JEE install preparations:
Database Name:
The name of
the database you have created.
Host Name:
The name
or IP address of the computer on which Oracle is running.
Port:
Database
Port. The default is 1521.
Database User Name:
The
name of the user you created on the Oracle database.
Password
and
Confirm Password:
The
password associated with the user.
-
Click
Next
and then click
Test Configuration
to
verify the configuration settings.
Note:
If the
test is successful, a “Connection test succeeded” message appears. Click
Next
.
Otherwise, review the error message that appears and modify the settings
as required until the test succeeds.
-
On the next screen, select the server that the data source
will connect to (in this case, the managed server) and then click
Finish
.
Configure the connection pool settings
-
Under Domain Structure, click
Services
>
JDBC
>
Data Sources
and,
in the right pane, click
RM_DS
.
-
On the next screen, click the
Configuration
tab >
Connection Pool
tab,
and set the following properties:
-
In the
Initial Capacity
box,
type
1
.
-
In the
Maximum Capacity
box, type
20
.
-
In the
Statement Cache Size
box, type
80
.
-
Click
Save
and then click
Activate Changes
.
-
Restart WebLogic managed server.
|
|
|
