Wednesday, October 8, 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)

Tuesday, October 7, 2014

RPM Packages and Kernel Parameter Required for EBS upgrade to R12.2 :

RPM Packages Required for EBS upgrade to R12.2 :

xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386
binutils-2.17.50.0.6-9.0.1.x86_64
sysstat-7.0.0-3.el5.x86_64
unixODBC-2.2.11-7.1.i386
unixODBC-devel-2.2.11-7.1.i386
unixODBC-2.2.11-7.1.x86_64
unixODBC-devel-2.2.11-7.1.x86_64
libaio-devel-0.3.106-3.2.x86_64


Kernel Parameter

Parameter Value
kernel.semmsl 2561
kernel.semmns 320001
kernel.semopm 1001
kernel.semmni 1421
kernel.shmall 20971524
kernel.shmmax Half the size of the physical memory (in bytes), and at least 21474836482
kernel.shmmni 4096
kernel.msgmax 8192
kernel.msgmnb 65535
kernel.msgmni 2878
fs.file-max 131072
net.ipv4.ip_local_port_range 10000 650003
net.core.rmem_default 262144
net.core.rmem_max 4194304
net.core.wmem_default 262144
net.core.wmem_max 262144


set using the following entry in the /etc/sysctl.conf file: kernel.sem = 256 32000 100 142

oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.fnd.sso.login.server.MainLoginPageAM'

Error :

Exception Details.
oracle.apps.fnd.framework.OAException: Could not load application module
'oracle.apps.fnd.sso.login.server.MainLoginPageAM'
...
## Detail 0 ##
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_TRANSACTION_ID.
at oracle.apps.fnd.framework.webui.OAJSPHelper.getTransactionId(OAJSPHelper.java:350)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:133)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1279)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:532)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:420)
at _OA._jspService(_OA.java:216)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
...

Relative Env:

Oracle Apps 11i and R12

Reason :

1. Increase or high no of Invalid Objects
2. Tablespace got filled


Solutions:

1. Check no of invalid objects.

select owner, object_type, count(*)
from dba_objects
where status='INVALID'
group by owner, object_type;

2. Compile the objects with  @?/rdbms/admin/utlrp.sql from sys user.
3. if required you can use adadmin to compile invalids
4. Check tablespace free space and add space if required.


For high traffic instance it is better to purge the inactive session periodically.

Schedule "Purge Inactive Sessions" program from sysadmin, it purges icx_trunsuctions

Follow the below note for more details.


When you are starting the DB-Tier Configuration script during an E-Business Suite Clone, you see following failure : RC-00118: Error occurred during creation of database

Error:

When you are starting the DB-Tier Configuration script during an E-Business Suite Clone, you see following failure :
...

getConnectionUsingAppsJDBCConnector() -->
  APPS_JDBC_URL='null'
  Trying to get connection using SID based connect descriptor
getConnection() -->
  sDbHost    :
  sDbDomain  :
  sDbPort    :
  sDbSid     :
  sDbUser    : APPS
  Trying to connect using SID...
getConnectionUsingSID() -->
  JDBC URL: jdbc:oracle:thin:@:
  Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
  JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=)))
  Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
  JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=.)))
  Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  Connection could not be obtained; returning null

RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase
...


Relevent env:

Oracle Applications Manager - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Applications Technology Stack - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Applications DBA - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.


Cause:

DNS is not set properly.

Solutions:

Check that DNS is working properly as given below.

nslookup .

You can use the /etc/hosts also if you are using it for resolving the names.



Follow this document for more details.

' adcfgclone dbTier' fails with error 'RC-00118' Error occurred during creation of database - 'Raised by oracle.apps.ad.clone.ApplyDatabase' (Doc ID 1299429.1)

Monday, October 6, 2014

ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_3"

Error message

*** 2014-10-05 09:00:07.681
*** SESSION ID:(5646.61909) 2014-10-05 09:00:07.681
*** CLIENT ID:() 2014-10-05 09:00:07.681
*** SERVICE NAME:(SYS$USERS) 2014-10-05 09:00:07.681
*** MODULE NAME:(DBMS_SCHEDULER) 2014-10-05 09:00:07.681
*** ACTION NAME:(MGMT_CONFIG_JOB_2_3) 2014-10-05 09:00:07.681

ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_3"
ORA-29280: invalid directory path
ORA-06512: at "ORACLE_OCM.MGMT_DB_LL_METRICS", line 2436
ORA-06512: at line 1



To supress this error message, we have to disable it as per the (https://blogs.oracle.com/UPGRADE/entry/upgrade_to_11_2_0)

SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB');
SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_STATS_CONFIG_JOB');

It has been tried in stage First.

SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB');

PL/SQL procedure successfully completed.

SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_STATS_CONFIG_JOB');

PL/SQL procedure successfully completed.



Another way is to reconfigure this OCM if you want to use this feature.

Cause:

SQL>select * from dba_directories where DIRECTORY_NAME like '%OCM_CONFIG%';

MGMT_DB_LL_METRICS wants to write to ORACLE_OCM_CONFIG_DIR2, which is not created by the built-in instrumentation scripts.

Sotutions:

1. You have to run the below command to check whether OCM is configured.

$ORACLE_HOME/ccr/bin/deployPackages -l

( some time there is a permission issue on $ORACLE_HOME/ccr/bin/deployPackages )
-- Then you can check it and give execute permission to $ORACLE_HOME/ccr/bin/deployPackages
-- Then try again

Installation Steps:

If OCM is not installed, please install it using steps given in the below document. It will create the directory during the installation. NO need to follow step 2.

Oracle Configuration Manager Installation and Administration Guide


2.
Connect as sysdba

SQL> @ORACLE_HOME/ccr/admin/scripts/ocmjb10.sql

SQL> @ORACLE_HOME/ccr/admin/scripts/execute execocm.sql

3.

Output should be like, if everything is fine :

SQL> select * from dba_directories where DIRECTORY_NAME like '%OCM_CONFIG%';

OWNER    DIRECTORY_NAME         DIRECTORY_PATH
-------- ---------------------- ------------------------------------------------------------------
SYS      ORACLE_OCM_CONFIG_DIR2 /u01/app/oracle/product/11.2.0.3/dbhome_1/ccr/state
SYS      ORACLE_OCM_CONFIG_DIR  /u01/app/oracle/product/11.2.0.3/dbhome_1/ccr/hosts/dc2oda-1/state

**Directory ORACLE_OCM_CONFIG_DIR2 should be returned in output.



Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...