My Journey to the cloud…

In pursuit of excellence….

Oracle Apps

Issues and learnings under the umbrella – Oracle Apps

  • Oracle E-Business Suite 12.0.4 Installation on 32 bit Linux

    This document demonstrates step by step procedure with screenshots to do multinode installation of oracle Applications R12.0.4 and then upgrading it to 12.0.6 This article will be helpful for the beginners who want to learn how to Install and configure oracle E-business suite 12.0.4 on multiple nodes using Linux OS platform R12.0.4 Multi Node Installation Continue reading

  • Log file location in Oracle application 11i

    Below is the ready reckoner for the location of various log files in Oracle apps 11i. This is very much helpful when troubleshooting any issue Database Tier Alert Log File – $ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log Trace file – $ORACLE_HOME/admin/SID_Hostname/udump Autoconfig Log file – $ORACLE_HOME/appsutil/log/SID_Hostname/DDMMTime/adconfig.log Application Tier Autoconfig Log file             – $APPL_TOP/admin/SID_Hostname/log/DDMMTime/adconfig.log Start/Stop Continue reading

    ,

  • File o7725967.tmp creation for FND_FILE failed

    Today support team sought a help for the issue they were encountering in the TEST instance. Error as given by the support team I tried a quick test to see if there is any issue with utl_file_dir Above test threw an error. Then I verified 2 more things 1) APPLPTMP directory should be the first one Continue reading

  • Usage of various pgp command

    Recently I got a request from a bank where the customer transmits some of the files. Bank was upgrading and changing their target server and hence we need to accommodate certain changes on our side to do the testing before the same is done in production environment. Command to list the existing Key IDs on Continue reading

  • adstpall.sh on Web tier and giving “Timeout specified in context file: 100 second(s)” error

    Today our development team complained of ‘Development’ instance of Oracle 11 Ebiz is not accessible. Even the login page is not loading. I tried to login and got the login page but later on after keying the login credential, it was taking extremely long time to open and later on threw ‘page not found’ error. I Continue reading

  • Invalid range “a-Z” in transliteration operator – vars.pm line 17

    Over the weekend, while running adconfig on one of our cloned instance, I got an error I searched over Metalink and found a hit – Invalid Range “A-Z” In Transliteration Operator [ID 279306.1] Followed the approach and that resolved the issue. Post implementing the solution, I was able to run adconfig successfully. -Anand Continue reading

  • usdsop: exec failed during spawn

    Y’day one of our PROD support team called up and asked that their ftp program is failing with the below error I first checked if the given shell script has the required permission to be executed by the application owner. and it was Ok – 755. Then I opened the shell script on the server Continue reading

  • Oracle process ID is null in FND_CONCURRENT_REQUESTS table

    Couple of days back, I had the strange issue in our PROD environment. End user called up and said that certain print job (custom job) has been running long and they were not able to see the output coming from the printer We are on 11.5.9 with database version 9.2.0.6 Issue analysis/findings and resolution What Continue reading

  • Installation of Oracle R12.1.1 on Linux 64 bit machine

    Today I completed the vision instance installation of Oracle R12.1.1 on Linux machine. I had some hiccups but finally were able to resolve all the error and got the login page successfully. I will be covering all the installation steps in this blog – all the issues faced, their resolutions etc. Oracle R12 Version – Continue reading

  • FND_CP_GSM_OPP_AQ is INVALID after applying a patch

    Today after applying a patch in Production environment, one of the queues “FND_CP_GSM_OPP_AQ” got invalid I tried to recompile this using below command but got ‘Invalid Alter command’ error. I searched over the Metalink and found one note (311851.1) related to compiling INVALID queue object. As per Metalink Note “If the OPP service is running and there are Continue reading

About Me

I’m a Hands-On Technical & Entrprise Solutions Architect based out of Houston, TX. I have been working on Oracle ERP, Oracle Database and Cloud technologies for over 20 years and still going strong for learning new things.

You can connect me on Linkedin and also reach out to me

I am certified for 8x AWS, OCP (Oracle Certified Professionals), PMP, ITTL and 6 Sigma.

Disclaimer

This is a personal blog. Any views or opinions represented in this blog are personal and belong solely to the blog owner and do not represent those of people, institutions or organizations that the owner may or may not be associated with in professional or personal capacity, unless explicitly stated.
All content provided on this blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site.

The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information. Any script available on the blog post MUST be tested before they are run against Production environment.

Recent Posts

Newsletter