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.

Friday, May 29, 2015

EBS Workflow Service Components Status



Good piece of script to identify the status of the workflow components from sql prompt.
This is alternate option to see workflow service components status from OAM GUI.


Run the below SQL as apps user

col component_id format 999999
col startup_mode format a10
col component_status format a10
col component_name format a50
set linesize 125
set pagesize 25
select component_id, startup_mode,component_status,component_type,component_name from fnd_svc_components

order by component_id;

Search and Replace String across multiple files in Linux

  perl -pi -e 's/old_string/new_string/g' file_pattern

  perl -pi -e 's/temp/tmp/g' *.html
  /happy/
To correctly replace it, you would have to escape the forward slashes with the escape character (the backslash) so that the forward slashes aren't interpreted as commands. Your replacement string would need to be:
  \/happy\/

Monday, December 22, 2014

HowTo Restore The Weblogic User Password On EBS 12.2 if Lost Or Forgotten

The steps are mentioned on the EBS Setup Guide for 12.2 which can be downloaded from the link : https://docs.oracle.com/cd/E26401_01/doc.122/e22953/T174296T589913.htm (12.2 Setup Guide) under the topic  "If the Admin Password of an EBS WebLogic Domain is lost or forgotten"

Also refer for more details :-
Procedure To Restore The Weblogic User Password On EBS 12.2 In Case Of Lost Or Forgotten Password (Doc ID 1949675.1)

Monday, March 10, 2014

Fusion Applications P4FA Patches

 

High levels to apply P4FA:

  1. Shutdown FMW, IDM and DB (Transaction, OID and OIM database) services
  2. Backup Environment
  3. * Apply patches to FMW Oracle Homes (excluding ATGPF/Generic and ATGPF/Database patches)
  4. * Apply patches to IDM Oracle Homes
  5. * Apply RDBMS patches to Transaction, OID and OIM ** Oracle Homes
  6. Start DB (Transaction, OID and OIM database) services
  7. Apply RDBMS patches post steps (if any) on Transaction, OID and OIM databases
  8. Start IDM Middle-tier services
  9. Apply post steps on IDM Oracle Homes (if any)
  10. Bounce IDM Middle-tier services (ONLY if any post step on IDM Oracle Homes requires OID/OIM/AUTHOHS bounce)
  11. Apply ATG/Generic patches to ATGPF Oracle Home
  12. Apply ATGPF/Database patches to ATGPF Oracle Home
  13. Start FMW services (FA, BI, and other techstack components)
  14. Apply post steps on FMW Oracle Homes (if any)
  15. Bounce FA Domains (ONLY if any post steps on FMW Oracle Homes requires domain bounce)

* can be done in parallel
** If Transaction, OID, OIM databases share same Oracle Home, then apply RDBMS patches once and perform patch post steps (if any) on all databases.

 

CLASSIFICATION OF PATCHES:

FMW_HOME=${HOME}/APPTOP/fusionapps

P4FA Directory
ORACLE_HOME to be applied
Generic ORACLE_HOME Name

ecm_bucket2
FMW_HOME/ecm

biappsshiphome
FMW_HOME/bi

wc
FMW_HOME/webcenter

odi
FMW_HOME/odi

ses
FMW_HOME/ses

fusionapps/generic
FMW_HOME/applications

pfcore
FMW_HOME/applications

osn
FMW_HOME/osn

soa
FMW_HOME/soa
OIM - IDMTOP/products/app/soa
OIM - IDMTOP/products/app/soa

suwrapper
FMW_HOME/wlserver_10.3
OID - IDMTOP/products/dir/wlserver_10.3
OIM - IDMTOP/products/app/wlserver_10.3

weblogic
FMW_HOME/wlserver_10.3
OID - IDMTOP/products/dir/wlserver_10.3
OIM - IDMTOP/products/app/wlserver_10.3

webgate
FMW_HOME/../webtier_mwhome/webgate
AUTHOHS - IDMTOP/products/ohs/webgate
WEBGATE_ORACLE_HOME

webtier
ADMIN Host - FMW_HOME/../webtier_mwhome/webtier
APPOHS - FMW_HOME/../webtier_mwhome/webtier
AUTHOHS - IDMTOP/products/ohs/ohs
OHS_ORACLE_HOME

oracle_common
FMW_HOME/oracle_common
ADMIN Host - FMW_HOME/../webtier_mwhome/oracle_common
APPOHS - FMW_HOME/../webtier_mwhome/oracle_common
OID - IDMTOP/products/dir/oracle_common
OIM - IDMTOP/products/app/oracle_common
AUTHOHS - IDMTOP/products/ohs/oracle_common
OID_COMMON_HOME
OIM - IDMTOP/products/app/oracle_common
OHS_COMMON_HOME

pltsec
OID - IDMTOP/products/dir/oid
OID_ORACLE_HOME

idm
OIM - IDMTOP/products/app/iam
OIM - IDMTOP/products/app/iam

idmlcm/generic
OID - $HOME/Middleware/Oracle_IDMLCM1 (Only for Provisioned IDM and not for tarball based IDM)

oif
OIM - IDMTOP/products/app/idm
OIM - IDMTOP/products/app/idm

atgpf/generic
FMW_HOME/atgpf

atgpf/database
adpatch FMW_HOME/atgpf

rdbms_11.2.0.3.0
Transaction DB
IDM DBs