Posts Tagged ‘Oracle EBS’

oc4j_socket_recvfull Timed Out

December 20th, 2017, posted in Oracle, Solaris
Share
[Wed Nov 1 11:37:28 2016][warn] [client 10.10.1.61] oc4j_socket_recvfull timed out
[Wed Nov 1 11:37:28 2016] [error] [client 10.10.1.61] [ecid: 1509525146:10.10.7.85:1275:0:45,0] mod_oc4j:
request to OC4J bi.erp.com:21500 failed: recv failed (errno=4)

 

Troubleshooting MOD_OC4J_0080 MOD_OC4J_0058 MOD_OC4J_0035 MOD_OC4J_0121 MOD_OC4J_0013 Errors In the HTTP Server error_log file [ID 329456.1]

The MOD_OC4J* errors basically convey that the HTTP Server (through mod_oc4j) is unable to communicate with the OC4J instance in question. Some of the possible causes are :

  • 1. Internet Explorer (KeepAlive) Bug
  • 2. Firewalls
  • 3. Connection timeouts between HTTP Server/mod_oc4j & OC4J
  • 4. OC4J instance running short on memory
  • 5. OC4J JVMs loaded
  • 6. Application(s) blocking up OC4J

Connection timeouts between HTTP Server/mod_oc4j & OC4J

In $ORACLE_HOME/Apache/Apache/conf/httpd.conf, increase the Timeout directive value to, say, 600 seconds. (This should be smaller than the Firewall timeout setting, if any)

In $ORACLE_HOME/Apache/Apache/conf/mod_oc4j.conf below the tag add the following:

Oc4jCacheSize 0

Oc4jConnTimeout 600 (This is again in seconds &, again, should be smaller than the Firewall timeout setting, if any)

Update the configuration as follows:

$ORACLE_HOME/dcm/bin/dcmctl updateconfig -ct ohs
$ORACLE_HOME/opmn/bin/opmnctl restartproc process-type=HTTP_Server

Share

Find The Inventory Organizations Assigned To Ones Operating Unit

November 6th, 2017, posted in Oracle Queries
Share
SELECT hou.NAME operating_unit_name,Oracle : Size Of Database,Oracle,Size Of Database,Database,data files, redo log files, control files, temporary files,Oracle data files,Oracle redo log files,Oracle control files,Oracle temporary files,Enabling And Checking the Status of Flashback On Database,Oracle Database,Oracle DBA,Enabling Flashback On Database,Checking the Status of Flashback On Database, Status of Flashback On Database, Enable Flashback On Database, Enabling Flashback On Database,Enable Flashback On Oracle Database, Enabling Flashback On Oracle Database,
hou.short_code,
hou.organization_id operating_unit_id,
hou.set_of_books_id,
hou.business_group_id,
ood.organization_name inventory_organization_name,
ood.organization_code Inv_organization_code,
ood.organization_id Inv_organization_id,
ood.chart_of_accounts_id
FROM hr_operating_units hou,
org_organization_definitions ood
WHERE 1 = 1
AND hou.organization_id = ood.operating_unit
ORDER BY hou.organization_id ASC;
Share

Query To Find Users Who Have A Responsibility

October 22nd, 2017, posted in Oracle Queries
Share

Enabling And Checking the Status of Flashback On Database,Oracle Database,Oracle DBA,Enabling Flashback On Database,Checking the Status of Flashback On Database, Status of Flashback On Database, Enable Flashback On Database, Enabling Flashback On Database,Enable Flashback On Oracle Database, Enabling Flashback On Oracle Database,ORA-01153: an incompatible media recovery is active,ORA-01153,Oracle Error,Ora Error,Oracle DBA,Oracle Database Error,Oracle Database Solution,an incompatible media recovery is active,Ora : an incompatible media recovery is active,Oracle an incompatible media recovery is active,Oracle Error Solution,Database DBA,oracle data guard,oracle data guard issues,oracle data guard error

select usr.user_id, usr.user_name, res.RESPONSIBILITY_ID, res.RESPONSIBILITY_NAME
from apps.FND_USER usr, apps.FND_RESPONSIBILITY_TL res, apps.FND_USER_RESP_GROUPS grp
where upper(res.RESPONSIBILITY_NAME) like upper('%' || NVL('&EnterRespName', 'INV')|| '%')
and upper(res.RESPONSIBILITY_NAME) NOT like '%AX%'
and upper(res.RESPONSIBILITY_NAME) NOT like '%OPM%'
and grp.responsibility_id = res.responsibility_id
and grp.user_id = usr.user_id;
Share

Oracle EBS Upgrade 12.1.1 to 12.1.3

September 18th, 2017, posted in Oracle Queries
Share

oracle dba,oracle apps dba,apps dba,dba,oracle application,oracle database,oracle,Oracle EBS Upgrade 12.1.1 to 12.1.3,Oracle EBS Upgrade,12.1.1 to 12.1.3,Oracle EBS Upgrade DBA,DBA EBS Upgrade 12.1.1 to 12.1.3,EBS Upgrade,oracle ebs,oracle upgrade,

Some Links To Oracle EBS Upgrade 12.1.1 to 12.1.3 :

http://sankaramaddi.blogspot.com/2015/11/ebs-upgrade-1211-to-1213.html

http://ermanarslan.blogspot.com/2013/09/ebs-1211-to-1213-upgrade-steps.html

https://oracleminds.wordpress.com/2011/12/22/how-did-i-upgrade-our-oracle-ebs-from-r12-1-1-to-12-1-3/

http://otn-world.blogspot.com/2013/12/upgrade-oracle-ebs-r1211-to-1213.html

http://oracledbawings.blogspot.com/2011/07/upgrade-ebs-1211-to-1213.html

http://chandrasekarsivasamy.blogspot.com/2012/08/oracle-applications-upgrade-from-1211.html

Share

AC-00005: No write permissions for creating the Context file – /tmp/temp.xml

September 12th, 2015, posted in Oracle, Solaris
Share

Problem : 

While making Oracle Application Clone : 

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] :

Do you want to preserve the Display [hooraps1:0.0] (y/n) ? : n

Target System Display [erp2:0.0] :
RC-50004: Error occurred in CloneContext:
AC-00005: No write permissions for creating the Context file – /tmp/temp.xml
Raised by oracle.apps.ad.context.AppsContext
Check Clone Context logfile /u07/appprod/apps/apps_st/comn/clone/bin/CloneContext_0908103640.log for details.

ERROR: Context creation not completed successfully.
For additional details review the file /tmp/adcfgclone_17325.err if present.

When you check log file you will get this : 

StackTrace:
java.lang.Exception: AC-00005: No write permissions for creating the Context file – /tmp/temp.xml
Raised by oracle.apps.ad.context.AppsContext
at oracle.apps.ad.context.AppsContext.getOaEnabledValues(AppsContext.java:733)
at oracle.apps.ad.context.CloneContext.setConfigHome(CloneContext.java:2306)
at oracle.apps.ad.context.CloneContext.doClone(CloneContext.java:606)
at oracle.apps.ad.context.CloneContext.main(CloneContext.java:5023)

RC-50004: Error occurred in CloneContext:
AC-00005: No write permissions for creating the Context file – /tmp/temp.xml
Raised by oracle.apps.ad.context.AppsContext
Context file creation not succesful

 

Solution :

Simply go to this path by root user /tmp/temp.xml . Give 777 rights to temp.xl .
And now login with application user and run perl adcfgclone.pl appsTier  !!

GoodLuck !! 🙂

Share