Oracle Applications APPSLab
- Sharing Knowledge on Oracle E-Business Suite Applications, Database, Fusion Middleware !!!
Friday, March 11, 2016
Oracle E-Business Suite on Oracle Cloud
Tuesday, March 8, 2016
SSL Setup on EBS 12.2 Environments
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
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
cp $INST_TOP/certs/Apache/cwallet.sso $IAS_ORACLE_HOME/instances/EBS_web_
cd $INST_TOP/certs/Apache
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
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 |
|
On DB tier :-
- First create ca.crt using server.crt
file .
cd $ORACLE_HOME/appsutil ( RDBMS home ) - mkdir wallet
- cd wallet ; and ftp the ca.crt file created in step 1 to this location.
- Run the following commands
- orapki wallet create -wallet $ORACLE_HOME/appsutil/wallet -auto_login -pwd Welcome123
- import trusted certificate using:
Create a Clean oraInventory in Release 12.2
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
2. Add the RDBMS Oracle Home first to the new oraInventory:
Go to $ORACLE_HOME
source the environment file
cd $ORACLE_HOME/oui/bin
Run the following command to add the RDBMS OH to oraInventory:
./runInstaller -attachhome ORACLE_HOME=
Example:
./runInstaller.sh -attachhome ORACLE_HOME=/u01/app/11.2.0 ORACLE_HOME_NAME='12_2_DB'
Check the inventory.xml under
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=
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
4. Add the FMW OHs from RUN filesystem to the new oraInventory:
4.1.
cd
export ORACLE_HOME=PWD
cd $ORACLE_HOME/oui/bin
Run the following command to add the OH to the oraInventory:
./runInstaller -attachhome ORACLE_HOME=
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
4.2.
cd
export ORACLE_HOME=PWD
cd $ORACLE_HOME/oui/bin
Run the following command to add the OH to the oraInventory:
./runInstaller -attachhome ORACLE_HOME=
Example:
./runInstaller.sh -attachhome ORACLE_HOME=/u01/app/fs1/FMW_Home/webtier ORACLE_HOME_NAME='FMW_webtier_fs1_OH'
Check the inventory.xml under
4.3.
cd
export ORACLE_HOME=PWD
cd $ORACLE_HOME/oui/bin
Run the following command to add the OH to the oraInventory:
./runInstaller -attachhome ORACLE_HOME=
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
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=
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
6. Add the FMW OHs from PATCH filesystem to the new oraInventory:
6.1.
cd
export ORACLE_HOME=PWD
cd $ORACLE_HOME/oui/bin
Run the following command to add the OH to the oraInventory:
./runInstaller -attachhome ORACLE_HOME=
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
6.2.
cd
export ORACLE_HOME=PWD
cd $ORACLE_HOME/oui/bin
Run the following command to add the OH to the oraInventory:
./runInstaller -attachhome ORACLE_HOME=
Example:
./runInstaller.sh -attachhome ORACLE_HOME=/u01/app/fs2/FMW_Home/webtier ORACLE_HOME_NAME='FMW_webtier_fs2_OH'
Check the inventory.xml under
6.3.
cd
export ORACLE_HOME=PWD
cd $ORACLE_HOME/oui/bin
Run the following command to add the OH to the oraInventory:
./runInstaller -attachhome ORACLE_HOME=
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
5. The new oraInventory is complete.
Friday, May 29, 2015
EBS Workflow Service Components Status
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/
\/happy\/
Monday, December 22, 2014
HowTo Restore The Weblogic User Password On EBS 12.2 if 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:
- Shutdown FMW, IDM and DB (Transaction, OID and OIM database) services
- Backup Environment
- * Apply patches to FMW Oracle Homes (excluding ATGPF/Generic and ATGPF/Database patches)
- * Apply patches to IDM Oracle Homes
- * Apply RDBMS patches to Transaction, OID and OIM ** Oracle Homes
- Start DB (Transaction, OID and OIM database) services
- Apply RDBMS patches post steps (if any) on Transaction, OID and OIM databases
- Start IDM Middle-tier services
- Apply post steps on IDM Oracle Homes (if any)
- Bounce IDM Middle-tier services (ONLY if any post step on IDM Oracle Homes requires OID/OIM/AUTHOHS bounce)
- Apply ATG/Generic patches to ATGPF Oracle Home
- Apply ATGPF/Database patches to ATGPF Oracle Home
- Start FMW services (FA, BI, and other techstack components)
- Apply post steps on FMW Oracle Homes (if any)
- 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/fusionappsP4FA Directory
ORACLE_HOME to be applied
Generic ORACLE_HOME Nameecm_bucket2
FMW_HOME/ecmbiappsshiphome
FMW_HOME/biwc
FMW_HOME/webcenterodi
FMW_HOME/odises
FMW_HOME/sesfusionapps/generic
FMW_HOME/applicationspfcore
FMW_HOME/applicationsosn
FMW_HOME/osnsoa
FMW_HOME/soa
OIM - IDMTOP/products/app/soa
OIM - IDMTOP/products/app/soasuwrapper
FMW_HOME/wlserver_10.3
OID - IDMTOP/products/dir/wlserver_10.3
OIM - IDMTOP/products/app/wlserver_10.3weblogic
FMW_HOME/wlserver_10.3
OID - IDMTOP/products/dir/wlserver_10.3
OIM - IDMTOP/products/app/wlserver_10.3webgate
FMW_HOME/../webtier_mwhome/webgate
AUTHOHS - IDMTOP/products/ohs/webgate
WEBGATE_ORACLE_HOMEwebtier
ADMIN Host - FMW_HOME/../webtier_mwhome/webtier
APPOHS - FMW_HOME/../webtier_mwhome/webtier
AUTHOHS - IDMTOP/products/ohs/ohs
OHS_ORACLE_HOMEoracle_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_HOMEpltsec
OID - IDMTOP/products/dir/oid
OID_ORACLE_HOMEidm
OIM - IDMTOP/products/app/iam
OIM - IDMTOP/products/app/iamidmlcm/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/idmatgpf/generic
FMW_HOME/atgpfatgpf/database
adpatch FMW_HOME/atgpfrdbms_11.2.0.3.0
Transaction DB
IDM DBs