www.d12tech.com >>> New home for simplified and customized training in Oracle World

Hi All,
If you are looking for any training in Oracle world customized to your specific needs, kindly contact sales@d12tech.com or visit www.d12tech.com


Oracle Install, patch and Maintain
R12 Sysadmin
Customized Training for R12
ODI – Admin
Weblogic
RAC/ASM/DG
OEM 12c
Database 12c
OATS (Oracle Application testing suite)
Database 12c New Features (CDB/PDB)
Oracle Linux
Oracle E-Biz for Implementers
R12 12.2 Online Patching Demo

www.d12tech.com ====> Our new address

Hi All,
   I have started my company with the name D12 TecH, Dedicated to Corporate Training in Oracle Space along with Consulting and Support. You can reach me at sales@d12tech.com for any further queries.

Thanks
Sundeep

Looking for Opportunities

Hi All,
   I am looking for opportunity now, let me know if anyone has any offer for me. Mail me at sudubey@gmail.com

Thanks
Sundeep

FND_NO_DATABASE_CONNECTION

Uncategorized
| Mar 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(OAPageErrorHandler.java:1251)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2195)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
at _OA._jspService(_OA.java:212)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)

Happy Troubleshooting !!!

Session Time out Setting in R12

Uncategorized
| Feb 11, 2011
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
(more...)

OPP jobs failing with time out

Uncategorized
| Feb 11, 2011
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.

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

Happy Troubleshooting !!!

12.1.2 to 12.1.3 upgrade on Solaris

Uncategorized
| Oct 7, 2010
We have recently upgrade our instances to 12.1.3. Here is what we did.

1) 10.1.3.5.0 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 p6880880_101000_SOLARIS64.zip in 10.1.3 and 10.1.2 OH to have latest opatch version.
8) Run Autoconfig on both Apps nodes.
(more...)

Finding XML Publisher Version in R12

Uncategorized
| Oct 7, 2010
Its being long I have posted something. Got Stuck in major milestone in our project and 12.1.3 upgrade.

1) The following SQL statement will show which patches and thus with version of Oracle XML Publisher is installed on an Oracle E-Business Suite Release 12.0 and 12.1 environment:

SELECT DECODE (bug_number, '4440000', '5.6.3') PATCH, bug_number
FROM ad_bugs WHERE bug_number IN('4440000');
PATCH BUG_NUMBER
----- ------------------------------
5.6.3 4440000

2) The version of a specific Java Class has a one to one relationship with the currently installed version of Oracle XML Publisher. This method is suitable (more...)

Unable to start OACORE OC4J in R12

Uncategorized
| Jun 18, 2010
We were doing JRE upgrade today and had issue in one of the instance not coming up. Basically OACORE OC4J service was unable to get start. Script adstrtal.sh was failing to start this service and erroing out:
==================================================
Executing service control script:/Path/admin/scripts/adoacorectl.sh start
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
ERROR : Timed out( 100000 ): Interrupted Exception
You are running adoacorectl.sh version 120.13
Starting OPMN managed OACORE OC4J instance ...
****************************************************
===================================================

After looking at log file :
===================================================
06/18/10-01:32:04 :: adoacorectl.sh: Starting OPMN managed OACORE OC4J instance
opmnctl: starting opmn managed (more...)

11gR2 upgrade with 12.1.2

Uncategorized
| Mar 31, 2010
Steps for 11gR2 Upgrade
Pre-Upgrade Task
Remove DB from archive log mode
Complete Backup of the Database & Application Binaries
Apps Patches:
9062910 -- 11g Release 2 interoperability patch for Release 12.1
7651166 -- 12.1 TXK Delta 2 patch
Adconfig Patches
8966480 -- FWDPORT 8942827 - 11.2DB:APPS11I:NEED CHANGES TO TEMPLATE FILES TO SUPPORT 11GR2
9366993 -- ADBLDXML AND AUTOCONFIG COMPLETES WITH NJNI11:JAVA.LANG.UNSATISFIEDLINKERROR

Set the path of oraInventory in /var/opt/oracle/oraInst.loc file.
Make entry for the oracle home that needs to be upgrade in /var/opt/oracle/oratab file.
Take a backup of the existing RDBMS oraInventory folder.

Software (more...)

12.1.2 CU patchset

Uncategorized
| Feb 17, 2010
We have recently upgraded our 12.1.1 env to 12.1.2, it has only one AD patch prereq nothing else. It went smoothly with no errors.

We are planning to move our 11gR1 database to 11gR2 soon once minimum patch requirement for OS level met. Will keep you posted.

Happy Troubleshooting !!!

Ten Great Tips For 2010

Uncategorized
| Dec 31, 2009
Ten Great Tips For 2010

1. Stay out of Trouble.

2. Aim for Greater Heights.

3. Stay Focused on your Job.

4. Exercise to Maintain Good Health.

5. Practice Team Work.

6. Rely on your Trusted Partner to Watch your Back. Take your Time Trusting Others.

7. Save for Rainy Days.

8. Rest and Relax.

9. Always Take Time to Smile.

AND

10. Realize That Nothing is Impossible.

Wishing You and Your Family A Very Happy, Prosperous and Healthy New Year 2010!

Export issue in 11g (11.1.0.7) with R12 (12.1.1)

Uncategorized
| Dec 15, 2009
I got one request to export entire R12 (12.1.1) database. I thought it going to be easiest task for me, but it turn to be most challenging for me. This is how proceed:
1. Create Directory in database:
create directory SUNEXP as '/sundeep/exp';
2. Grant read, write on SUNEXP to DBA role, as I want to start expdp as system.
grant read,write on directory EXPDIR to "DBA";
3. Ran expdp full export:
expdp system/password DIRECTORY=SUNEXP FULL=Y COMPRESSION=ALL DUMPFILE=exp_sundeep.dmp LOGFILE=exp_sundeep.log

I thought I am done and it will gona take its own sweet time. But it failed (more...)

OPP on Virtual Host

Uncategorized
| Dec 9, 2009
In one of my earlier post I have mentioned how to use Virtual host for Concurrent manager. In this post I am specifically talking about issue you might encounter while using report output as xml and it doesn't show the actual output rather it shows html tags. So just understand the concept how OPP is being used in xml reports and then look for solution.

An Application user submits an XML Publisher based report.
The Standard Concurrent Manager process the request.
The XML data file is generated by the standard concurrent manager.
This can be done by various methods:
Oracle (more...)

Installing VMware with Oracle Enterprise linux 64 bit

Uncategorized
| Nov 29, 2009
Last few days I was busy with installating R 12 (12.1.1) on VMware. It was very hectic but learning experience for me. In my previous post I have put screens for installing VMware on Windows 7 and Oracle Enterprise linux over and above VM. Here are the explaination of all figures.
Fig 1 : This is the first screen which will see after you click on installation file for VMware 2.0.1, which I downloaded from http://www.vmware.com/download/server.
Fig 2 : It ask for location. I installed it on my USB external drive so I have (more...)

Installing VMware with Oracle Enterprise Linux 64 bit

Uncategorized
| Nov 29, 2009






















Couldn’t open ICX Application Message file

Uncategorized
| Oct 18, 2009
One off my team mate reported an issue while opening forms in Purchasing Super user he encountered error message:
"Message Dictionary couldn't open the ICX application message file. Cannot open file /u02/apps/apps_st/appl/icx/12.0.0/mesg/US.msb for reading."

When I checked the location it was not there. Then I though running generate message file from adadmin but it didn't help. Here is the solution :

We have run Concurrent request "Generate Messages" for "Oracle iProcurement" and it will generate US.msb file under required location.

Happy Troubleshooting !!!

R12 New features

Uncategorized
| Oct 18, 2009
While using R12 I come across few things which might help you guys too:

1. It doesn't require to change apps password in any config files. So no need to run autoconfig if you used to do it.
2. All startup files are in $INST_TOP/admin/scripts
3. While creating Share Appl Top we can keep all other tops as read only except INST_TOP.
4. While running $INST_TOP/admin/scripts/adautocfg.sh it require apps password only. No need to provide Context file location any more.
5. CONTEXT File location is $INST_TOP/appl/admin
6. If you want to install R12 on virtual host start rapidwiz as (more...)

How to change Oracle user ORACLE_HOME

Uncategorized
| Oct 18, 2009
We have to change our ora user $ORACLE_HOME from /u02/oracle to /u02/oracle/11.1.0. Here are steps which I have followed and done this.

1. Run adpreclone.pl on dbtier as oracle user
perl adpreclone.pl dbTier
2. Shutdown down database and listener.
3. mv all files from /u02/oracle to /u02/oracle/11.1.0
4. run adcfgclone.pl for binaries only to avoid db creation
perl adcfgclone.pl dbTechStack
It will ask you certain info, please provide it accordingly.
5. update profiles from $OH/appsutil/install/
sqlplus "/ as sysdba" @adupdlib.sql so
6. change directory to $OH/appsutil/clone/bin
perl adcfgclone.pl dbconfig $OH/appsutil/context_file.xml
7. run autoconfig on appstiers too.
8. Start all services and check.

Happy Troubleshooting !!!

MWA server in R12

Uncategorized
| Oct 18, 2009
If you are suppose to run MWA server in R12 you might feel like something is missing here from 11i. So just read it and you will be able to handle it.
Prior to R12:
1. The MWA server startup files were located under "$MWA_TOP/bin" directory.
2. The MWA Server configuration files were located under "$MWA_TOP/secure" directory.
In R12
1. Scripts are under $INST_TOP/admin/scripts
2. Config files are under $INST_TOP/admin/install

Here are few commands and which we used to use in 11i, this is how we are going to use them in R12:
1. Startup the MWA server
mwactl.sh (more...)