Enabling SSL or TLS in Oracle E-Business Suite Release 12

Enabling SSL or TLS in Oracle E-Business Suite Release 12

>> Backup context file

echo $CONTEXT_FILE
/U01/appl/PREP/inst/apps/PREP_weberp/appl/admin/PREP_weberp.xml
cd /U01/appl/PREP/inst/apps/PREP_weberp/appl/admin
cp PREP_weberp.xml PREP_weberp_15FEB15.xml




Step 1 - Set Your Environment
1. Logon to the application middle tier as the OS user who owns the middle tier files.
2. Source your middle tier environment file (APPS<sid_machine>.env) located in the APPL_TOP directory.
3. Navigate to the $INST_TOP/ora/10.1.3 and source the <sid_machine>.env file to set your 10.1.3
ORACLE_HOME variables.

[root@weberp ~]# su - appl
[appl@weberp ~]$ cd $INST_TOP/ora/10.1.3
[appl@weberp 10.1.3]$ pwd
/U01/appl/PREP/inst/apps/PREP_weberp/ora/10.1.3
[appl@weberp 10.1.3]$ ls
Apache       config    j2ee       network  PREP_weberp.env
cfgtoollogs  deconfig  javacache  opmn
 

Go to $INST_TOP
/U01/appl/PREP/inst/apps/PREP_weberp
Take backup of certs folder


Step 2 - Create a wallet
1. Navigate to the $INST_TOP/certs/Apache directory.
2. Move the existing wallet files to a backup directory in case you wish to use them again in the future.
3. Open the Wallet manager as a background process:
owm &
4. On the Oracle Wallet Manager Menu navigate to Wallet -> New.
Answer NO to: “Your default wallet directory doesn't exist. Do you wish to create it now?”
The new wallet screen will now prompt you to enter a password for your wallet.
Click YES when prompted:
“A new empty wallet has been created. Do you wish to create a certificate request at this time?”


ENTER 'NO'


CREATE WALLET PASSWORD
eg. test123

PRESS 'YES'
Step 3 - Create a Certificate Request
After clicking "Yes" in step 2 the Create Certificate Request Screen will pop up:
Fill in the appropriate values where:
Common Name: is the name of your server including the domain.
Organizational Unit: (optional) The unit within your organization.
.
Organization: is the name of your organization.
Locality/City: is your locality or city.
State/Province: is the full name of your State or Province - do not abbreviate.
Select your Country from the drop down list, and for the Key Size, select 2048 as a minimum. Click OK.
 







 
Step 4 - Submit the Certificate Request to a Certifying Authority
You will need to export the Certificate Request before you can submit it to a Certifying Authority.
1.    Click on Certificate [Requested] to Highlight it.
2.    From the menu click Operations -> Export Certificate Request
3.    Save the file as server.csr
4.    From the menu click Wallet and then click Save.
5.    On the Select Directory screen change the Directory to your fully qualified wallet directory.
6.    Click OK.
7.    From the menu click Wallet and check the Auto Login box.
Be sure to make this password something you will remember. You will need to use the password whenever you open the wallet with Oracle Wallet Manager or perform operations on the wallet using the Command Line Interface. With a uto login enabled processes submitted by the OS user who created the wallet will not need to supply the password to access the wallet.
8.    Exit the Wallet Manager.
The wallet directory will now contain the following files:
•    cwallet.sso
•    ewallet.p12
•    server.csr
You may now submit server.csr to your Certifying Authority to request a Server Certificate.
 

Change path to save file


 

From the menu click Wallet and check the Auto Login box.


b64InternetCertificate.txt file location
/U01/appl/PREP/apps/tech_st/10.1.2/sysman/config
 




















Applications Technology : R12 User Guides

Applications Technology : R12 User Guides

Lifecycle Management

E12842-04
Maintaining Oracle E-Business Suite Documentation Set
NA
E13675-03
E13676-03
E12148-04
E16342-03
E15842-01
E12899-04
E12895-03

System Administration

Oracle E-Business Suite System Administrator's Guide Documentation Set
NA
E12893-04
E12894-04
E12843-05
E12892-04
E12951-04
E12898-03

Architecture and Common Applications

E12841-04
E13423-04
E13568-04
E13569-04
E13662-04
E13570-04
E13405-04
E13407-04

UserInterface, Development, and Personalization

E12896-04
E12897-04
E12900-03
E12646-04

Integration

E12065-06
E12169-06
E12064-06
E12953-03
E12952-03
E12903-04
E12904-04
E12779-03
E12905-04
E12906-04
E12954-04

Reporting and Desktop Integration
E15877-02
E12901-04
E12902-04


OID: unable to locate message file: ldap.msb

OID: unable to locate message file: ldap.msb

Issue:

[oidtest@oidtest1 bin]$ ldapadd -h oidtest1 -p 3060 -D "cn=orcladmin" -w "Welcome123"

unable to locate message file: ldap<language>.msb

Cause:

Basic cause of this error is, ORACLE_HOME is not set properly.

Solution:

To use most Oracle Internet Directory command-line utilities and Database client utilities like sqlplus,  you must set the following environmental variables:

1. ORACLE_HOME: The location of non-writable files in your Oracle Identity Management installation.
ORACLE_HOME=<Path of Middleware>/Oracle_IDM1

2. ORACLE_INSTANCE: The location of writable files in your Oracle Identity Management installation.
ORACLE_HOME=<Path of Middleware>/Oracle_IDM1/asinst_1

3. TNS_ADMIN: The directory where the database connect string is defined in the tnsnames.ora file. By default it is the $ORACLE_INSTANCE/config directory. The database connect alias as defined in tnsnames.ora is OIDDB by default.

4. PATH: It should contain the following path as below
$ORACLE_HOME/bin
$ORACLE_HOME/ldap/bin
$ORACLE_INSTANCE/bin

adformsctl.sh: exiting with status 150

adformsctl.sh: exiting with status 150

If adoacorectl.sh,adformsctl.sh,adoafmctl.sh not coming up after start the application services
adoacorectl.sh: exiting with status 150
adformsctl.sh: exiting with status 150
adoafmctl.sh: exiting with status 150


Check the log file for these three processes:
$LOG_HOME/appl/admin/log/adoacorectl.txt
$LOG_HOME/appl/admin/log/adoafmctl.txt
$LOG_HOME/appl/admin/log/adoaformsctl.txt
If you see error like below

"opmn id=app01.rajeev01.com:6200
    no processes or applications matched this request
adoafmctl.sh: exiting with status 150"

Stop all three services.

Clean the directory, under  persistence from below directory and restart all three services
$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/persistence
$ORA_CONFIG_HOME/10.1.3/j2ee/oafm/persistence
$ORA_CONFIG_HOME/10.1.3/j2ee/forms/persistence

File Versions

File Versions

How to find Apps Version (11i/R12/12i)
>> Connect to database as user apps
SQL> select release_name from apps.fnd_product_groups;
Output like 12.0.4 or 11.5.10.2

Web Server/Apache or Application Server in Apps 11i/R12

>> Log in as Application user, set environment variable and run below query $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version
Output for 11i should be like

 
Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built: Jan 26 2005 11:06:44 (iAS 1.0.2.2.2 rollup 5)

Output for R12 should be like
Server version: Oracle-Application-Server-10g/10.1.3.0.0Oracle-HTTP-Server
Server built: Dec 4 2006 14:44:38

Forms & Report version (aka developer 6i) in 11i >> Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/f60run | grep Version | grep Forms

output like
Forms 6.0 (Forms Runtime) Version 6.0.8.25.2 (Production)
Check fourth character in version 25 which means Forms 6i patchset 16 (25-9)

Forms & Report version in R12/12i >> Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/rwrun | grep Release

Output should be like
Report Builder: Release 10.1.2.2.0 
You can safely ignore warnings

Oracle Jinitiator in 11i/R12/12i >>

Log in as Application user, set environment variable and run below query 
grep jinit_ver_comma $CONTEXT_FILE 

(Default is Java Plug-In for R12/12i )

Oracle Java Plug-in in 11i/R12/12i >>

Log in as Application user, set environment variable and run below query 
grep plugin $CONTEXT_FILE


File Version on file system >>
adident Header <filename>
or
strings <file_name> | grep Header

Here adident is AD Utility (Oracle Apps) and strings is Unix utility

Version of pld file >>
*.pld are source code of *.pll which are inturn source of *.plx. *.pll is in $AU_TOP/resource and to find its version check

adident Header $AU_TOP/resource/<filename>.pll
IGSAU012.pll:
$Header IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $

or
strings $AU_TOP/resource/<filename>.pll | grep -i header

FDRCSID(’$Header: IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $’);

OA Framework Version >> http:// hostname.domainName:port/OA_HTML/OAInfo.jsp (Only for 11i); Log in as Application user, set environment variable and run below query

adident Header $FND_TOP/html/OA.jsp
adident Header $OA_HTML/OA.jsp

output for both should look like
$Header OA.jsp 115.60 2006/03/31 00:47:28 atgops1 noship $

120.21 means OA Framework Version (coming soon..)
115.60 means OA Framework Version (coming soon..)
115.56 means OA Framework Version (coming soon..)
115.36 means OA Framework Version 5.7
115.27 means OA Framework Version 5.6E
115.26 means OA Framework Version 5.5.2E 

Discoverer Version for 11i (3i or 4i)

>> Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/disc4ws | grep -i Version

Discoverer Version for 11i or R12 (10g AS)

>> Check under Application Server Section as 10g AS Discoverer is on standalone

Workflow Version with Apps >> Connect to Database as apps user
SQL> select TEXT Version from WF_RESOURCES where NAME = ‘WF_VERSION’;
Output like 2.6.0 means workflow version 2.6.0

Oracle Single Sign On >>
Connect to database which holds SSO repository
SQL>select version from orasso.wwc_version$;

Oracle Internet Directory >>

There are two component in OID (Software/binaries & Schema/database)

To find software/binary version
$ORACLE_HOME/bin/oidldapd -version
output should look like

oidldapd: Release 10.1.4.0.1 - Production on thu sep 11 11:08:12 2008
Copyright (c) 1982, 2006 Oracle. All rights reserved.

To find Schema Version/ database use
ldapsearch -h <hostname> -p <port> -D “cn=orcladmin” -w “<password>” -b “” \

-s base “objectclass=*” orcldirectoryversion

and output should be like

version: 1
dn:
orcldirectoryversion: OID 10.1.4.0.1

or run following query in database
SQL> select attrval from ods.ds_attrstore where entryid = 1 and attrname = ‘orcldirectoryversion’;

Output should be like OID 10.1.4.0.1

Application Server >> Oracle Application Server (Prior to Oracle WebLogic Server)
If application server is registered in database (Portal, Discoverer) check from database
SQL> select * from ias_versions;
or
SQL>select * from INTERNET_APPSERVER_REGISTRY.SCHEMA_VERSIONS;

AOC4J (Oracle Container for J2EE)
Set ORACLE_HOME
cd $ORACLE_HOME/j2ee/home
java -jar oc4j.jar -version

Oracle Portal >>
SQL> select version from portal.wwc_version$;

Database Component

I) Oracle Database

To find database version
SQL> select * from v$version;
or
All component version in database

$ORACLE_HOME/OPatch/opatch lsinventory -detail

Oracle Enterprise Manager >> 
Metalink Note 605398.1 How to to find the version of the main EM components

Unix Operating System

Solaris -> cat /etc/release
Red Hat Linux -> cat /etc/redhat-release