Temple of Oracle

Thursday, January 14, 2016

False Alerts For Concurrent Processing In OEM 12c

False Alerts For Concurrent Processing In OEM 12c

There are false alerts from the Enterprise Manager (EM) console alerting about services down, but they are showing UP in the EM console and E-Business Suite (EBS).
Timeout parameters are too low not allowing the correct acknowledge of the target status from EM.

1. Change the following parameters in the /sysman/config/emd.properties file:

  dynamicPropsComputeTimeout_oracle_database=800
  dynamicPropsComputeTimeout_host=480
  agentJavaDefines=-Xmx2048M -XX:MaxPermSize=1024M
  dynamicPropsComputeTimeout_oracle_ebs=800

Ignore step #2 if the service shows as UP in the console.

2. Login to EBS Console
a. Go to Targets-->Oracle E Business Suite, Select the EBS Target on which 'Inventory Manager' is shown.
b. Open "EBS Target Menu" -->Monitoring-->Metric and Metric Collection Settings.
c. Change View "All Metrics", all metrics are displayed, go to "Native Services" , click on 'Every 15 Minutes' in 6th column next to "Native Services".
d. Change the value from 15 mins to 30 or 45 mins.
e. Save and re-test.

Concurrent Processing - Creating a Conflict Domain for a Concurrent Program

As SYSADMIN in Systems Administrator Responsibility

1) In CONCURRENT > CONFLICT DOMAIN Form

DOMAIN SHORTNAME DESCRIPTION
458 458
204 204

SAVE

NB: 458 = Vision Services org id
204 = Vision Project Mfg org id

2) CONCURRENT > PROGRAM > DEFINE

Query PRC: Interface Revenue to General Ledger
Select Incompatiblities

Set the "Type" field value to Domain for PATTGL and save.

3) PROFILE > SYSTEM OPTION > Concurrent:Conflicts Domain

PROFILE > SYSTEM Query " CONCURRENT: CONFLICTS DOMAIN"
at the responsibility level:

Projects, Vision Services (USA) -- set the profile to 458
Projects, Vision Project Mfg (MRC) -- set the profile to 204

SAVE

4) CONCURRENT >PROGRAM > DEFINE

Query PRC: Interface Revenue to General Ledger

INCOMPATIBILITIES TAB > Remove Program "PRC: Interface Revenue to General

SAVE

As the conflict domain has been setup the incompatibility that PRC: Interface Revenue to General Ledger has with itself is then removed.

For more Use the Concurrent Processing - Creating a Conflict Domain for a Concurrent Program (267167.1)

There are many dead processes for WFMGSMS Concurrent Manager

The Internal Concurrent Manager log file reports many dead processes referencing WFMGSMS (Workflow Summary Mailer Concurrent Manager) Concurrent Manager.

For example:

Found dead process: spid=(14546), cpid=(506393), Service Instance=(1064)
Starting WFMGSMS Concurrent Manager : 12-MAR-2009 05:32:23
Process monitor session ended : 12-MAR-2009 05:32:25

Solution:

To implement the solution, please execute the following steps:

1. Login as System Administrator.
2. Navigate to Concurrent / Manager / Define.
3. Query the "Workflow Mailer" and disable it.
4. In the same screen, query the "Workflow Summary Mailer", and disable it.
5. Bounce the Concurrent Managers.

Problem: Concurrent Manager Request Status Remains Terminating Indefinitely

Concurrent Manager Request Status Remains Terminating Indefinitely

Symptom: Concurrent request status Remains Terminating Indefinitely

Cause: It is be because concurrent manager table need a cleanup

Solution:

Run the below commands from apps user.

update fnd_concurrent_queues Set running_processes=0, max_processes=0;

delete from fnd_concurrent_processes;

Update fnd_concurrent_requests set status_code = 'X', phase_code = 'C' where status_code = 'T';

commit;

Wednesday, January 14, 2015

How to check OCR details.

How to check OCR details.

Need to use the below tools for checking the OCR details

oracle@testserver1i /u01/app/11.2.0.4/grid/bin +ASM1 > ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3860
Available space (kbytes) : 258260
ID : 710588188
Device/File Name : +OCRVOTEDG
Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check bypassed due to non-privileged user

oracle@testserver1i /u01/app/11.2.0.4/grid/bin +ASM1 >

Go inside the asm location to check the phisical file

oracle@testserver1i /u01/app/11.2.0.4/grid/bin +ASM1 > asmcmd
ASMCMD> cd OCRVOTEDG
ASMCMD> ls
testingdbiscan/
ASMCMD> cd testingdbiscan/
ASMCMD> ls
ASMPARAMETERFILE/
OCRFILE/
ASMCMD> cd ASMPARAMETERFILE/
ASMCMD> ls
REGISTRY.253.807918545
ASMCMD>

To fine the OLR or the local registry for the Cluster node go to the root user and run the below command.

[root@testserver1i app]# . oraenv
ORACLE_SID = [root] ? +ASM1
The Oracle base has been set to /u01/app/oracle
[root@testserver1i app]# echo $ORACLE_HOME
/u01/app/11.2.0.4/grid
[root@testserver1i app]# ocrcheck -local
Status of Oracle Local Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2696
Available space (kbytes) : 259424
ID : 1047978051
Device/File Name : /u01/app/11.2.0.4/grid/cdata/testserver1i.olr
Device/File integrity check succeeded

Local registry integrity check succeeded

Logical corruption check succeeded

[root@testserver1i app]#

How to check CRS (Cluster ready services ) status in Oracle

How to check CRS (Cluster ready services ) status in Oracle

Go to the Grid home and bin direcotry.

oracle@testingserver1i /u01/app/11.2.0.4/grid/bin +ASM1 > crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

oracle@testingserver1i /u01/app/11.2.0.4/grid/bin +ASM1 > srvctl status nodeapps
VIP testingserver1i-vip is enabled
VIP testingserver1i-vip is running on node: testingserver1i
VIP testingserver2i-vip is enabled
VIP testingserver2i-vip is running on node: testingserver2i
Network is enabled
Network is running on node: testingserver1i
Network is running on node: testingserver2i
GSD is disabled
GSD is not running on node: testingserver1i
GSD is not running on node: testingserver2i
ONS is enabled
ONS daemon is running on node: testingserver1i
ONS daemon is running on node: testingserver2i

oracle@testingserver1i /u01/app/11.2.0.4/grid/bin +ASM1 > crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.testDB.dg
ONLINE ONLINE testingserver1i
ONLINE ONLINE testingserver2i
ora.DBA_BANK.dg
ONLINE ONLINE testingserver1i
ONLINE ONLINE testingserver2i
ora.LISTENER.lsnr
ONLINE ONLINE testingserver1i
ONLINE ONLINE testingserver2i
ora.OCRVOTEDG.dg
ONLINE ONLINE testingserver1i
ONLINE ONLINE testingserver2i
ora.asm
ONLINE ONLINE testingserver1i Started
ONLINE ONLINE testingserver2i Started
ora.gsd
OFFLINE OFFLINE testingserver1i
OFFLINE OFFLINE testingserver2i
ora.net1.network
ONLINE ONLINE testingserver1i
ONLINE ONLINE testingserver2i
ora.ons
ONLINE ONLINE testingserver1i
ONLINE ONLINE testingserver2i
ora.registry.acfs
ONLINE ONLINE testingserver1i
ONLINE ONLINE testingserver2i
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE testingserver1i
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE testingserver2i
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE testingserver2i

ora.testingserver1i.vip
1 ONLINE ONLINE testingserver1i
ora.testingserver2i.vip
1 ONLINE ONLINE testingserver2i
ora.cvu
1 ONLINE ONLINE testingserver2i
ora.oc4j
1 ONLINE ONLINE testingserver2i
ora.scan1.vip
1 ONLINE ONLINE testingserver1i
ora.scan2.vip
1 ONLINE ONLINE testingserver2i
ora.scan3.vip
1 ONLINE ONLINE testingserver2i
oracle@testingserver1i /u01/app/11.2.0.4/grid/bin +ASM1 >

Tuesday, October 7, 2014

NLS PT R12 Patch application error oracle.apps.xdo.XDOException: Template ARXAGFMX not found

NLS PT R12 Patch application error oracle.apps.xdo.XDOException: Template ARXAGFMX not found

Error:

Parameters passed to XLIFFLoader...
[FILE_NAME] [ apps/apps_st/appl/ar/12.0.0/patch/115/publisher/templates/PT/ARXAGF.xlf]
[APPS_SHORT_NAME] [AR]
[UPLOAD] [UPLOAD]
[DB_USERNAME] [APPS]
[JDBC_CONNECTION] [(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname.domain.com)(PORT=1551))(CONNECT_DATA=(SID=VISR12)))]
[DB_PASSWORD] [******]
[TEMPLATE_CODE] [ARXAGFMX]

Target file: ARXAGF.xlf
Start uploading...
oracle.apps.xdo.XDOException: Template ARXAGFMX not found
at oracle.apps.xdo.oa.util.TemplateTranslator.getBaseTemplateInfo(TemplateTranslator.java:338)
at oracle.apps.xdo.oa.util.TemplateTranslator.createMLSTemplates(TemplateTranslator.java:210)
at oracle.apps.xdo.oa.util.XLIFFLoader.processUpload(XLIFFLoader.java:709)
at oracle.apps.xdo.oa.util.XLIFFLoader.process(XLIFFLoader.java:565)
at oracle.apps.xdo.oa.util.XLIFFLoader.main(XLIFFLoader.java:1073)

Solution:

1. Run this.
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD \
-JDBC_CONNECTION \
-LOB_TYPE TEMPLATE_SOURCE \
-APPS_SHORT_NAME AR \
-LOB_CODE ARXAGFMX \
-LANGUAGE en \
-TERRITORY US \
-XDO_FILE_TYPE RTF \
-FILE_NAME $AR_TOP/patch/115/publisher/templates/US/ARXAGF.rtf \
-CUSTOM_MODE FORCE

2. Once 1 is successful run this.

UPDATE xdo_templates_b
SET mls_language = 'en', mls_teritorry = 'US'
WHERE application_short_name = 'AR'
and template_code = 'ARXAGFMX';

3. Then restart the failed worker which was working ARXAGF.xlf.

For more info rollow the below document

Patch 12702898:R12.AR.A Fails With oracle.apps.xdo.XDOException: Template ARXAGFMX not found (Doc ID 1495265.1)