OracleApps/DB/OS Administration Solutions: February 2015

Thursday 26 February 2015

EBS : Status Diagram not opening

The issue can be reproduced at will with the following steps:
1. Log in to Sysadmin
2. Select Workflow Adminstrator Responsbility
3. Select status monitor
4. Provide the details of the item type
5. Click on status diagram. Now it shows error page.

Solution
1. Set the profile option Server Timezone at Site level (should be set to the value of database timezone)

select dbtimezone from dual;

2. Bounce the Apache Server

Thursday 19 February 2015

EBS : Create Accounting - Cost Management Errs with Out of Memory Exception retry with scalable option or modify the Data template

Concurrent log error:

Calling XDO Data Engine...
****Warning!!! Due to high volume of data, got out of memory exception...***
****Please retry with scalable option or modify the Data template to run in scalable mode...***

Solution:
1. SYSADMIN --> Concurrent --> Program --> Define

2. Query for concurrent program with the short name = CSTCRACC

In the 'Options' field change the value to -Xmx1024M. (or higher). You can change the value to -Xmx2048M, and possibly even -Xmx4096M. Ultimately, you may exceed the heap size.

3. Restart the OPP concurrent manager so that changes take effect

Note: Enabling the scalability feature and changing the heap size to -Xmx1024M' is not recommended to be on the global level, only on the concurrent program level.

Reference : (Doc ID 873774.1)

Wednesday 18 February 2015

Linux : context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023

Error:

[oracle@oracledb ~]$ id
uid=501(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@oracledb ~]$ cat /etc/selinux/config

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
SELINUX=enforcing
# SELINUXTYPE= can take one of these two values:
# targeted - Targeted processes are protected,
# mls - Multi Level Security protection.
SELINUXTYPE=targeted

Solution:

[root@oracledb ~]$ vi /etc/selinux/config

disable selinux and restart the server

[root@oracledb ~]$ cat /etc/selinux/config

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of these two values:
# targeted - Targeted processes are protected,
# mls - Multi Level Security protection.
SELINUXTYPE=targeted
[root@oracledb ~]$

[oracle@oracledb ~]$ id
uid=501(oracle) gid=500(dba) groups=500(dba)

DB : installation failed with oracle.install.commons.util.exception.DefaultErrorAdvisor

Error:

SEVERE: [FATAL] oracledb.local.com: oracledb.local.com.
Refer associated stacktrace #oracle.install.commons.util.exception.DefaultErrorAdvisor:37
INFO: Advice is ABORT
SEVERE: Unconditional Exit
INFO: Adding ExitStatus FAILURE to the exit status set

Solution:

Check for output the values of the below

hostname
uname -a
/etc/sysconfig/network

it should contain same values of hostname in all the above three

[oracle@oracledb ~]$ hostname
oracledb.local.com
[oracle@oracledb ~]$ uname -a
Linux oracledb.local.com 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux
[oracle@oracledb ~]$ cat /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=oracledb.local.com
[oracle@oracledb ~]$

EBS : Unable To View Status Diagram in Status monitor workflow

Error:

oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)

at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:616)