Wednesday, November 18, 2015

ORA-20008 ORA-6512 ADOP patching issue on 12.2

Problem

When prepare phase following error occur
adop phase=prepare

ERROR at line 1:

ORA-20008: No Concurrent Manager is defined that can run concurrent program
ADZDPATCH
ORA-6512: at "APPS.AD_ZD_ADOP", line 240

Solution

Execute below command to overcome the issue
FNDLOAD apps/<apps_pw> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $AD_TOP/patch/115/import/US/adzdpatch.ldt - CUSTOM_MODE=FORCE

Tuesday, November 17, 2015

SQL Script for find Application Short Name of Oracle R12 Modules

The Following Query List all the EBS Application name with short name
SELECT fat.application_name        "Application Name",
       fa.application_short_name   "Short Name"
 FROM fnd_application     fa,
       fnd_application_tl  fat
 WHERE fa.application_id = fat.application_id
   AND fat.language      = USERENV('LANG')
 ORDER BY fa.application_short_name;

Application Name Short Name
Activity Based Management (Obsolete) ABM
Applications DBA AD
Applications Demonstration Services ADS
ADS Development ADS_DEV
Complex Maintenance Repair and Overhaul AHL
Hosting Manager(Obsolete) AHM
Common Modules-AK AK
Alert ALR
Approvals Management AME
Fulfillment Services (Obsolete) AMF
Marketing AMS
Marketing Encyclopedia System AMV
Internal Controls Manager AMW
Sales Analysis AN
Receivables AR
Sales Foundation AS
Sales Online ASF
CRM Gateway for Mobile Devices ASG
Sales Offline ASL
Sales ASN
Order Capture ASO
Oracle Sales for Handhelds ASP
TeleSales AST
Application Utilities AU
Global Accounting Engine AX
Application Implementation AZ
Banking BANKING
Advanced Benefits BEN
Customer Intelligence (obsolete) BIC
eCommerce Intelligence BIE
Sales Intelligence BIL
Marketing Intelligence BIM
Communications Intelligence BIN
Applications BIS BIS
Service Intelligence BIV
Interaction Center Intelligence BIX
Systems Intelligence BIY
Utility Billing BLC
Web Applications Desktop Integrator BNE
Bills of Material BOM
Balanced Scorecard BSC
Telephony Manager CCT
Oracle Clinical Data Repository CDR
Cash Management CE
Supplier Scheduling CHV
APAC Consulting Localizations CLA
EMEA Consulting Localizations CLE
Japan Consulting Localizations CLJ
LAD Consulting Localizations CLL
Supply Chain Trading Connector for RosettaNet CLN
Culinary Application CLR
Incentive Compensation CN
Core Banking COREBANK
CPG – CDOA CPGC
Capacity CRP
Service CS
Customer Care CSC
Depot Repair CSD
Asset Tracking CSE
Field Service CSF
Install Base CSI
Field Service/Laptop CSL
Field Service/Palm CSM
Call Center CSN
Spares Management CSP
Scheduler CSR
Support (obsolete) CSS
Cost Management CST
Clinical Transaction Base CTB
Capital Resource Logistics – Assets CUA
Revenue Accounting CUC
Billing Connect (obsolete) CUE
Capital Resource Logistics – Financials CUF
Citizen Interaction Center CUG
Network Logistics – Inventory CUI
Network Logistics – NATS (obsolete) CUN
Network Logistics – Purchasing CUP
Mass Market Receivables for Comms CUR
Network Logistics CUS
Custom Development CUSTOM
Configurator CZ
CADView-3D DDD
Demand Signal Repository DDR
Demo Order Entry (AOL Class) DEM
Development DNA
Document Managment and Collaboration DOM
Oracle Price Protection DPP
DateTrack DT
Obsolete Process Operations DUMMY_GMO
SEM Exchange (obsolete) EAA
Enterprise Asset Management EAM
e-Commerce Gateway EC
XML Gateway ECX
E-Records EDR
Advanced Product Catalog EGO
Environment Management System EMS
Engineering ENG
Product Intelligence ENI
Value Based Management EVM
Enterprise Performance Foundation FEM
FastFormula FF
Financial Intelligence FII
Flow Manufacturing FLM
Application Object Library FND
Project Portfolio Analysis FPA
Banking Center (obsolete) FPT
Report Manager FRM
Transportation Execution FTE
Transfer Pricing FTP
Financials Common Modules FUN
Federal Financials FV
Financial Consolidation Hub GCS
US Federal Human Resources GHR
Process Manufacturing Systems GMA
Process Manufacturing Product Development GMD
Process Manufacturing Process Execution GME
Process Manufacturing Financials GMF
Process Manufacturing Inventory GMI
Process Manufacturing Logistics GML
Manufacturing Execution System for Process Manufacturing GMO
Process Manufacturing Process Planning GMP
Grants Accounting GMS
Process Manufacturing Portal GMW
Genealogy Intelligence GNI
Process Manufacturing Regulatory Management GR
Healthcare HCA
iHCConnect HCC
iHCIntegrate HCN
Healthcare Intelligence HCP
Healthcare Terminology Server HCT
Human Resources Intelligence HRI
Time and Labor Engine HXC
Time and Labor HXT
iAssets IA
Digital Asset Management IAM
iMarketing (Obsolete) IBA
Content Manager IBC
iStore IBE
Bill Presentment & Payment IBP
iAuction IBT
iSupport IBU
Oracle Web Analytics IBW
Payments IBY
Oracle iProcurement ICX
Interaction Blending IEB
Advanced Outbound Telephony IEC
Email Center IEM
Interaction Center Technology IEO
Predictive IEP
Scripting IES
Call Center Connectors IET
Universal Work Queue IEU
IVR Integrator IEV
Collections IEX
Contract Commitment IGC
Financial Aid IGF
Public Sector Financials International IGI
Student System IGS
Grants Proposal IGW
Customers Online IMC
iMeeting (obsolete) IMT
Oracle Landed Cost Management INL
Institutional Banking INSTITBANK
Inventory INV
Capital Resource Logistics – Projects IPA
Product Development (obsolete) IPD
Oracle Imaging Process Management IPM
iRecruitment IRC
Supply Chain Intelligence ISC
iSettlement ISX
Information Technology Audit ITA
Internet Procurement Enterprise Connector ITG
Oracle E-Business Suite Diagnostics IZU
Asia/Pacific Localizations JA
European Localizations JE
Regional Localizations JG
Latin America Localizations JL
Supply Chain Localizations JMF
CRM Foundation JTF
Mobile Application Foundation JTM
CRM Self Service Administration JTS
Loans LNS
Controlled Availability Product(Obsolete) ME
Manufacturing MFG
Mobile Applications for Inventory Management MIA
Media Interactive MIV
Mobile Quality Applications MQA
Master Scheduling/MRP MRP
Advanced Supply Chain Planning MSC
Demand Planning MSD
Constraint Based Optimization MSO
Inventory Optimization MSR
Transportation Planning MST
Oracle Manufacturing Operations Center MTH
Mobile Applications MWA
Oracle Applications Manager OAM
Data Query ODQ
Order Entry OE
Assets OFA
Contracts for Subscriptions (Obsolete) OKB
Contracts Core OKC
Project Contracts OKE
Contracts Intelligence OKI
Lease and Finance Management OKL
Contracts for Sales (Obsolete) OKO
Contracts for Procurement (Obsolete) OKP
Contracts for Rights (Obsolete) OKR
Service Contracts OKS
Royalty Management OKT
Contracts Integration OKX
Order Management ONT
Operations Intelligence OPI
Learning Management OTA
University Curriculum OUC
Trade Management OZF
Trade Planning (Obsolete) OZP
iClaims (Obsolete) OZS
Projects PA
Payroll PAY
Budgeting and Planning PBR
Human Resources PER
Oracle Profitability Manager PFT
Project Intelligence PJI
Project Manufacturing PJM
Process Manufacturing Intelligence PMI
Property Manager PN
Purchasing PO
Purchasing Intelligence POA
Exchange POM
Sourcing PON
iSupplier Portal POS
Public Sector HR PQH
Public Sector Payroll PQP
Progress Custom PRGC
Proposals PRP
Public Sector Financials PSA
Public Sector Budgeting PSB
Labor Distribution PSP
Public Sector Receivables PSR
Patch Tracking System PTX
Partner Management PV
Quality QA
Quoting QOT
Advanced Pricing QP
Oracle Deal Management QPR
Risk Management QRM
Regulatory Capital Manager (obsolete) RCM
Application Report Generator RG
Advanced Planning Foundation(obsolete) RHX
Release Management Integration Kit (Obsolete) RLA
Release Management RLM
Risk Manager RMG
Retail Core RRC
Site Management RRS
Applications Shared Technology SHT
Payables SQLAP
General Ledger SQLGL
SSP SSP
System Administration SYSADMIN
test TEST
Automotive VEA
Automotive Integration Kit (Obsolete) VEH
Work in Process WIP
Manufacturing Mobile Applications WMA
Warehouse Management WMS
Manufacturing Scheduling WPS
Shipping Execution WSH
Shop Floor Management WSM
XML Publisher XDO
Provisioning XDP
Subledger Accounting XLA
Legal Entity Configurator XLE
Service Assurance for Communications XNA
Oracle Telecommunications Billing Integrator XNB
Sales for Communications (Obsolete) XNC
Install Base Intelligence (Obsolete) XNI
Marketing for Communications (Obsolete) XNM
Number Portability XNP
Service for Communications (obsolete) XNS
TeleBusiness for Telecom/Utilities XNT
Treasury XTR
Financial Analyzer ZFA
Enterprise Planning and Budgeting ZPB
Sales Analyzer ZSA
E-Business Tax ZX

Tuesday, November 3, 2015

Start and stop Mobile Web Application (MWA) services in R12


Start MWA Services
Login from Application binary owner
$ . <APPL_TOP>/APPS<CONTEXT_NAME>.env
$ cd $ADMIN_SCRIPT_HOME
$ ./mwactl.sh -login apps/<apps_pwd> start
OR
$ ./mwactlwrpr.sh start apps/<apps_pwd>

Stop MWA Services
Login from Application binary owner
$ . <APPL_TOP>/APPS<CONTEXT_NAME>.env
$ cd $ADMIN_SCRIPT_HOME
$ ./mwactl.sh -login apps/<apps_pwd> stop
OR
$ ./mwactlwrpr.sh stop apps/<apps_pwd>

Check Whether MWA Services are running
$ ps -ef |grep mwa

Find out port number of MWA services
Login from Application binary owner
$ . <APPL_TOP>/APPS<CONTEXT_NAME>.env
$ grep mwa $CONTEXT_FILE

Saturday, October 17, 2015

Oracle Apps R12.2 Online patching


For 12.2 patching have to use 'ADOP' utility instead of 'ADADMIN'.
'ADOP' is the new ad utility given by Oracle for patching the Oracle Apps R12.2 environments.

Application tier technology patches are applied to the patch file system and the changes are propagated to the run file system as part of an Online Patching cycle

Steps for Online patching

1. Download any required technology patches and unzip them into the $NE_BASE/EBSapps/patch directory.

2. Prepare for patching
$ . <EBS_ROOT>/EBSapps.env
$ adop phase=prepare
3. Apply Technology patches
$ adop phase=apply patches=<patch number>
4. Finalize patch application
$ adop phase=finalize
5. Perform cutover
$ adop phase=cutover
6. Cleanup obsolete objects
$ . <EBS_ROOT>/EBSapps.env run
$ adop phase=cleanup
7. Synchronize the technology level between patch and run file systems
$ adop phase=fs_clone

Online Patching Cycle

Reference : Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)

Tuesday, October 13, 2015

Step by Step Cloning - R12.2

DB Tier Cloning

1. Prepare source node for cloning
cd /u01/PROD/fs1/inst/apps/PROD_oracle/admin/scripts
perl adpreclone.pl appsTier
cd /u01/PROD/db/11.2.0/appsutil/scripts/PROD_oracle
perl adpreclone.pl dbTier
2. Shutdown Application and DB
cd /u01/PROD/fs1/inst/apps/PROD_oracle/admin/scripts
./adstpall.sh 
sqlplus / as sysdba
shutdown immediate; 
3. Copy db directory from source to target
scp -r /u01/PROD/db <targetIP>:/u01/DEV/
4. Set permission for db filesystem
chmod -R 775 /u01/DEV/db
chown -R oracle:dba u01/DEV/db
5. Switch user who own the db binary file system
su - oracle
6. Configure target DB Tier
cd /u01/DEV/db/11.2.0/appsutil/clone/bin
perl adcfgclone.pl dbTier

Apps Tier Cloning



1. Create following directories on target host
mkdir /u01/DEV/fs1 -p
mkdir /u01/DEV/fs2 -p
mkdir /u01/DEV/fs_ne -p
2. Copy EBSapps directory from source to target (no need to copy FMW_Home and inst Directories)
scp -r /u01/PROD/fs1/EBSapps <targetIP>:/u01/DEV/fs1
3. Set permission for Apps file system
chmod -R 775 /u01/DEV/fs1
chown -R oracle:dba u01/DEV/fs1
4. Switch user who own the db binary file system
su - oracle
5. Configure target run file system
cd /u01/DEV/fs1/EBSapps/comn/clone/bin
perl adcfgclone.pl appsTier
6. After startup target application server, prepare system for patch file system
cd /u01/DEV/fs1/inst/apps/PROD_oracle/admin/scripts
perl adpreclone.pl appsTier
7. Shutdown application Server
cd /u01/DEV/fs1/inst/apps/PROD_oracle/admin/scripts
./adstpall.sh
8. Copy EBSapps directory from run file system to patch file system on target host
cp -r /u01/DEV/fs1/EBSapps /u01/DEV/fs2
9. Configure target patch file system
cd /u01/DEV/fs2/EBSapps/comn/clone/bin
perl adcfgclone.pl appsTier
10. If all goes well, then start application Server
cd /u01/DEV/fs1/inst/apps/PROD_oracle/admin/scripts
./adstrtal.sh

Wednesday, October 7, 2015

'Host key verification failed' Error when scp from one host to another in linux


Problem

When Try to copy file from one host to another below error occur
[root@backup u01]# scp -r RPM_oel6/ 192.168.22.4:/u01
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@    WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!     @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY!
Someone could be eavesdropping on you right now (man-in-the-middle attack)!
It is also possible that the RSA host key has just been changed.
The fingerprint for the RSA key sent by the remote host is
ea:d6:b9:ac:45:e5:4a:46:ff:71:0b:84:a6:24:de:b2.
Please contact your system administrator.
Add correct host key in /root/.ssh/known_hosts to get rid of this message.
Offending key in /root/.ssh/known_hosts:2
RSA host key for 192.168.22.4 has changed and you have requested strict checking.
Host key verification failed.
lost connection

Solution

Please execute below command and copy again to overcome the issue
sed -i '2d' /root/.ssh/known_hosts 
Where '2d' is line number. If the line number is different then use the same

Thursday, July 16, 2015

Mount NTFS file system on Linux

Below are the steps to mount ntfs file system on linux OS

1. Download fuse RPM from below link and Install
http://www.atrpms.net/dist/el5/fuse/
$ rpm -Uvh --nodeps --force fuse-2.7.4-8_12.el5.x86_64.rpm
$ rpm -Uvh --nodeps --force fuse-kmdl-2.6.18-371.el5xen-2.7.4-8_12.el5.x86_64.rpm
$ rpm -Uvh --nodeps --force fuse-libs-2.7.4-8_12.el5.x86_64.rpm

2. Download fuse-ntfs RPM from below link and Install
http://dag.wieers.com/rpm/packages/fuse-ntfs-3g/
$ rpm -Uvh --nodeps --force fuse-ntfs-3g-1.417-1.el4.rf.x86_64.rpm

3. Mount the HD
$ mount.ntfs-3g /dev/sdb1 /media/disk1 -o force