Cisco Cisco Workload Automation 6.3 User Guide
21
Configuring the Oracle Applications Adapter
Configuring SSL and HTTPS Protocol for the Oracle Applications Adapter
TNSNamesFile=C:/oracle/ora90/network/ADMIN/tnsnames.ora
Note:
If you are using Unix, then there is no drive letter at the beginning of the pathname. The directory pathname
is case-sensitive.
Solution
Open the TNS file and using the same name specified in the
TNS Name
field of the
Connection Definition
dialog for the Oracle Applications adapter, do a search to find that name.
Solution
When you find the definition of the TNS, replace the service name or if the using the SID verify that the
parameters specifying the
protocol, host and port are provided. The parameters are case-sensitive and must be in
capital letters as in the following example:
#SID for oraapps
oraapps2k =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL=TCP)(HOST=oraapps2k)(PORT=1523))
)
(CONNECT_DATA=
(SID=vis)
)
)
Configuring SSL and HTTPS Protocol for the Oracle Applications Adapter
It is recommended that Oracle Applications Web servers be configured to use SSL via the HTTPS protocol for Data
Services/Data Integrator. If your environment is configured to use HTTP, you can skip this section.
Services/Data Integrator. If your environment is configured to use HTTP, you can skip this section.
For complete instructions on configuring Oracle Applications servers to use the HTTP or HTTPS protocol, refer to the
Oracle Applications documentation that ships with the product.
Oracle Applications documentation that ships with the product.
There are three steps to configuring SSL via HTTPS:
Obtaining the Security Certificates
From a Windows desktop, you can obtain a security certificates for each target Oracle Applications server using the
Microsoft Internet Explorer Certificate Cache.
Microsoft Internet Explorer Certificate Cache.
Note:
Although other procedures are available for obtaining the required certificates, the procedure below can be
performed from your Windows desktop.
Note:
You need to carry out the following instructions only if your server certificate is generated in-house (that is,
self-signed) or if your server certificate is signed by a Certification Authority that is not trusted by the version of Java you
are using. Alternatively, if your adapter connection fails by reporting the error “unable to find valid certification path to
requested target” you need to carry out the following instructions.
are using. Alternatively, if your adapter connection fails by reporting the error “unable to find valid certification path to
requested target” you need to carry out the following instructions.
To obtain target Oracle Applications server security certificates
1.
Open the Internet Explorer browser and navigate to the following dispatch URL (replacing the server name and port
as it applies to your environment).
as it applies to your environment).
https://<adminHost:adminPort>/admin/servlet/webservices