Friday, March 11, 2016

Oracle E-Business Suite on Oracle Cloud


Run Oracle E-Business Suite on the Oracle Cloud today!

By running Oracle E-Business Suite on Oracle Cloud, you can reduce time and cost for new projects, increase business agility, better manage growth, and increase the productivity of your global IT workforce.

LEARN HOW TO USE ORACLE E-BUSINESS SUITE ON ORACLE CLOUD

Get hands-on, step-by-step instructions in Oracle by Example (OBE) tutorials.

Tuesday, March 8, 2016

SSL Setup on EBS 12.2 Environments



1. stop the services
2. go to $INST_TOP/certs
3. If directory Apache exists, take backup of that dir
5. cp -r Apache Apache_bak
6. cd Apache
7. rm *

If Apache dir does not exist, create it under $INST_TOP/certs.

8. Create wallet under Apache dir using :

orapki wallet create -wallet . -auto_login -pwd  Welcome123
9. Update wallet by replacing  ebs.oracle.com  in the following example with  your VM host

 orapki wallet add -wallet . -dn "CN= ebs.oracle.com,OU=Unit,O=Org,L=Redwood Shores,ST=California,C=US" -keysize 1024 -self_signed -validity 3650 -pwd  Welcome123

10. Replace     with your  env context name in following command:

cp   $INST_TOP/certs/Apache/cwallet.sso $IAS_ORACLE_HOME/instances/EBS_web_/config/OHS/EBS_web_component/keystores/default            

      
cd  $INST_TOP/certs/Apache
 Please  replace   the  ebs.oracle.com  with  your  VM host .

orapki wallet export -wallet  $PWD  -dn "CN= ebs.oracle.com,OU=Unit,O=Org,L=Redwood Shores,ST=California,C=US"  -cert server.crt -pwd Welcome123

11. cd  $OA_JRE_TOP/lib/security
12. cp  cacerts cacerts_org

13. $ keytool -import -alias ApacheServer -file $INST_TOP/certs/Apache/server.crt -trustcacerts -v -keystore ./cacerts -storepass  Welcome123


Trust this certificate? [no]:  Yes
Certificate was added to keystore
14  Update the $CONTEXT_FILE with SSL values given in table below:
 Variable 
Non-SSL Value 
SSL Value 
s_url_protocol
http
https
s_local_url_protocol
http
https
s_webentryurlprotocol
http
https
s_active_webport
same as s_webport
same as s_webssl_port
s_webssl_port
not applicable
Make sure base= 4443
s_https_listen_parameter
not applicable
same as s_webssl_port
s_enable_sslterminator
#
remove the '#' to use ssl_terminator.conf
s_login_page
url constructed with http protocol and s_webport
url constructed with https protocol and s_webssl_port.
Eg. https://ebs.oracle.com:4452/OA_HTML/AppsLogin
s_external_url
url constructed with http protocol and s_webport
url constructed with https protocol and s_webssl_port
Eg. https://ebs.oracle.com:4452/OA_HTML/AppsLogin




15. Run Autoconfig on middle tier.

On DB tier :-
  1. First create  ca.crt using   server.crt file .
    cd  $ORACLE_HOME/appsutil    (   RDBMS home )
  2. mkdir  wallet
  3. cd wallet ;   and  ftp the ca.crt file  created in step 1  to this location.
  4. Run the following commands
  5. orapki wallet create -wallet $ORACLE_HOME/appsutil/wallet -auto_login -pwd Welcome123
  6. import trusted certificate using:
orapki wallet add -wallet . -trusted_cert -cert ca.crt -pwd Welcome123
Test using new URL

Create a Clean oraInventory in Release 12.2

1. Clean the current oraInventory location:

Check the oraInventory location from the /etc/oraInst.loc file
Backup and clean that directory
Customer can write down the name of all entries from the old inventory from /ContentsXML/inventory.xml to use during the creation of the new OHs

2. Add the RDBMS Oracle Home first to the new oraInventory:

Go to $ORACLE_HOME
source the environment file .env
cd $ORACLE_HOME/oui/bin
Run the following command to add the RDBMS OH to oraInventory:
./runInstaller -attachhome ORACLE_HOME= ORACLE_HOME_NAME=''
Example:
./runInstaller.sh -attachhome ORACLE_HOME=/u01/app/11.2.0 ORACLE_HOME_NAME='12_2_DB'
Check the inventory.xml under /ContextXML directory and ensure the new entry is added.


3. Add the 10.1.2 OH from RUN filesystem to the new oraInventory:

Source the Run FS environment file
cd $ORACLE_HOME/oui/bin
Run the following command to add the 10.1.2 OH to the oraInventory:
./runInstaller -attachhome ORACLE_HOME= ORACLE_HOME_NAME=''
Example:
./runInstaller.sh -attachhome ORACLE_HOME=/u01/app/fs1/EBSapps/10.1.2 ORACLE_HOME_NAME='10_1_2_fs1_OH'
Check the inventory.xml under /ContextXML directory and ensure the new entry is added.

4. Add the FMW OHs from RUN filesystem to the new oraInventory:

4.1. /oracle_common
cd /oracle_common
export ORACLE_HOME=PWD
cd $ORACLE_HOME/oui/bin
Run the following command to add the OH to the oraInventory:
./runInstaller -attachhome ORACLE_HOME= ORACLE_HOME_NAME=''
Example:
./runInstaller.sh -attachhome ORACLE_HOME=/u01/app/fs1/FMW_Home/oracle_common ORACLE_HOME_NAME='FMW_oracle_common_fs1_OH'
Check the inventory.xml under /ContextXML directory and ensure the new entry is added.

4.2. /webtier
cd /webtier
export ORACLE_HOME=PWD
cd $ORACLE_HOME/oui/bin
Run the following command to add the OH to the oraInventory:
./runInstaller -attachhome ORACLE_HOME= ORACLE_HOME_NAME=''
Example:
./runInstaller.sh -attachhome ORACLE_HOME=/u01/app/fs1/FMW_Home/webtier ORACLE_HOME_NAME='FMW_webtier_fs1_OH'
Check the inventory.xml under /ContextXML directory and ensure the new entry is added.


4.3. /Oracle_EBS-app1
cd /Oracle_EBS-app1
export ORACLE_HOME=PWD
cd $ORACLE_HOME/oui/bin
Run the following command to add the OH to the oraInventory:
./runInstaller -attachhome ORACLE_HOME= ORACLE_HOME_NAME=''
Example:
./runInstaller.sh -attachhome ORACLE_HOME=/u01/app/fs1/FMW_Home/Oracle_EBS-app1 ORACLE_HOME_NAME='FMW_Oracle_EBS_app1_fs1_OH'
Check the inventory.xml under /ContextXML directory and ensure the new entry is added.


5. Add the 10.1.2 OH from PATCH filesystem to the new oraInventory

Source the PATCH FS environment file
cd $ORACLE_HOME/oui/bin
Run the following command to add the 10.1.2 OH to the oraInventory:
./runInstaller -attachhome ORACLE_HOME= ORACLE_HOME_NAME=''
Example:
./runInstaller.sh -attachhome ORACLE_HOME=/u01/app/fs1/EBSapps/10.1.2 ORACLE_HOME_NAME='10_1_2_fs1_OH'
Check the inventory.xml under /ContextXML directory and ensure the new entry is added.



6. Add the FMW OHs from PATCH filesystem to the new oraInventory:

6.1. /oracle_common
cd /oracle_common
export ORACLE_HOME=PWD
cd $ORACLE_HOME/oui/bin
Run the following command to add the OH to the oraInventory:
./runInstaller -attachhome ORACLE_HOME= ORACLE_HOME_NAME=''
Example:
./runInstaller.sh -attachhome ORACLE_HOME=/u01/app/fs2/FMW_Home/oracle_common ORACLE_HOME_NAME='FMW_oracle_common_fs2_OH'
Check the inventory.xml under /ContextXML directory and ensure the new entry is added.

6.2. /webtier
cd /webtier
export ORACLE_HOME=PWD
cd $ORACLE_HOME/oui/bin
Run the following command to add the OH to the oraInventory:
./runInstaller -attachhome ORACLE_HOME= ORACLE_HOME_NAME=''
Example:
./runInstaller.sh -attachhome ORACLE_HOME=/u01/app/fs2/FMW_Home/webtier ORACLE_HOME_NAME='FMW_webtier_fs2_OH'
Check the inventory.xml under /ContextXML directory and ensure the new entry is added.


6.3. /Oracle_EBS-app1

cd /Oracle_EBS-app1
export ORACLE_HOME=PWD
cd $ORACLE_HOME/oui/bin
Run the following command to add the OH to the oraInventory:
./runInstaller -attachhome ORACLE_HOME= ORACLE_HOME_NAME=''
Example:
./runInstaller.sh -attachhome ORACLE_HOME=/u01/app/fs2/FMW_Home/Oracle_EBS-app1 ORACLE_HOME_NAME='FMW_Oracle_EBS_app1_fs2_OH'
Check the inventory.xml under /ContextXML directory and ensure the new entry is added.

5. The new oraInventory is complete.