Friday, November 21, 2014

It always good to have team ===>

Hi All,
   I would like to introduce as our new address. Four experts in Oracle arena come under one umbrella called SSAR Tech. As the same goes it has four team members Sundeep Siddarth Aman Ritesh which forms SSAR. Need your help and support in our new venture.

Keep Troubleshooting!!!

Tuesday, March 1, 2011


This is the very common error in R12 instance "FND_NO_DATABASE_CONNECTION", but when you retry you won't get this error. To overcome this issue Oracle has come up with patch "9908921:R12.FWK.B Details".

Error Stack :
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION.
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(
at _OA._jspService(
at com.orionserver.http.OrionHttpJspPage.service(
at oracle.jsp.runtimev2.JspPageTable.service(
at oracle.jsp.runtimev2.JspServlet.internalService(
at oracle.jsp.runtimev2.JspServlet.service(
at javax.servlet.http.HttpServlet.service(
at com.evermind.server.http.ServletRequestDispatcher.invoke(
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(
at com.evermind.server.http.ServletRequestDispatcher.access$100(

Happy Troubleshooting !!!

Friday, February 11, 2011

Session Time out Setting in R12

Many occassions we have seen end users reporting session timed out even though they were working on. This is for sure its an issue from client end and JRE version which client is running on is the culprit for the same. Try to have the same version of JRE which is running on your server or latest one.
Even if this doesn't help try at client end following setting with running JRE:
1. Navigate to: Start > Control Panel > Java > Advanced > Java Plug-in
2. De-select the option "Enable the next-generation Java Plug-in "
3 Restart the browser
4-Retest the issue

Next if you want to increase timeout setting from server end. Do the following:
1. Change profile option ICX: Session Timeout to 60 min from 30, which is default.
2. change s_oc4j_sesstimeout value to 60 again in context file and run adconfig.
3. Bounce the apps services and check.

Happy Troubleshooting !!!

OPP jobs failing with time out

Hi All, I am back after long time. Never late then never. Now onwards I may focus on R12 issues which I have faced in my project. Here is first one.

Log file : The Output Post-processor is running but has not picked up this request. No further attempts will be made to post-process this request, and the request will be marked with Warning status.Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.

Increase the value of following profiles:
Concurrent:OPP Process Timeout
Concurrent:OPP Response Timeout

Happy Troubleshooting !!!

Thursday, October 7, 2010

12.1.2 to 12.1.3 upgrade on Solaris

We have recently upgrade our instances to 12.1.3. Here is what we did.

1) patch 8626084
2) From Apps tier Source $INST_TOP/ora/10.1.3/sid_hostname.env file to set $ORACLE_HOME as 10.1.3 home.
3) cd /8626084/Disk1
4) ./runInstaller -invPtrLoc $ORACLE_HOME/oraInst.loc
5) On fourth screen it will ask for oc4jadmin password. Kindly put "oafm".
6) Stop opmn processes, keeping same 10.1.3 env.
$ORACLE_HOME/opmn/bin/opmnctl stopall
7) Unzip patch in 10.1.3 and 10.1.2 OH to have latest opatch version.
8) Run Autoconfig on both Apps nodes.
9) apply patch in 10.1.3 home via opatch :
opatch apply
10) Confirm patchset version:
Run the command 'opatch lsinventory -detail'
Look for 'Oracle Application Server PatchSet' in the 'Product' column. 'Version' should show
11) Now apply apps patches, enable Maintenance Mode via adamin
12) Apply patch
Create $ORACLE_HOME/appsutil/admin on the database server.
Copy adgrants.sql (UNIX) from this patch directory to
Set the environment to point to ORACLE_HOME on the database server
Login as sysdba and run
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS
13) Apply patch 9239090 12.1.3 patch. (Take 5-6 hrs)
14) Apply online help patch
15) Apply post patches and
16) Run autoconfig on both Apps tier
17) Run the utility to create the file in the
/admin/out directory
perl $AD_TOP/bin/
18) On Database tier copy this file
19) And unzip in OH cd
unzip -o
20) Run autoconfig on DB Tier
21) Run adpreclone on both DB Tier and Apps Tier
perl dbTier
perl appsTier
22) Disable Maintenance Mode via adamin
23) Needs to deploy forms before starting services on apps tier
24) Stop all the Application Services
25) Back up the original system-jazn-data.xml file.
cp $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml.orig
26) Add the following :
vi $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml
========= file snippet original =================

OC4J Administrator
OC4J Administrator
OC4J Administrator

=========== with change ============================

OC4J Administrator
OC4J Administrator
OC4J Administrator

27) Back up the original opmn.xml file
cp $INST_TOP/ora/10.1.3/opmn/conf/opmn.xml $INST_TOP/ora/10.1.3/opmn/conf/opmn.xml.orig
28) Add the following line:
ipaddr remote="" request=""
notification-server interface="ipv4"
ipaddr remote="" request=""
port local="#local_port" remote="#remote_port" request="#request_port"
29) Run the deployment script
$FND_TOP/bin/ -script=CfgOC4JAppEnter
Application name for re-deployment ? forms
Enter Oc4j Instance password for re-deployment ? welcome
Run Autoconfig ? No
30) Restore both system-jazn-data.xml and opmn.xml from the backup taken under step 25 and 27 respectively
31) Run autoconfig
32) Start the services.
$ADMIN_SCRIPTS_HOME/ apps/appspwd

Once done, you will be able to access forms now on 12.1.3.
Happy Troubleshooting !!!