My Journey to the cloud…

In pursuit of excellence….

  • How to Generate SSH key in Linux

    Some or the other times, there is a need to have a SSH key generated to allow traffic from/to different server. Today I created a SSH key on LINUX machine. You need to run the command “ssh-keygen -t dsa” on the command prompt. If you need to create 4k RSA SSH key, issue the below command ssh-keygen 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

  • Passwordless SSH login

    Many times requirement comes from development team that they need to login to remote server for some activity – be it ‘ftp’ or ‘copy’ or ‘writing’ on the remote server. In such cases, it is required that there is seamless and password less login from source server to target server. I am going to discuss the Continue reading

  • 11i/R12 Concurrent requests going into ‘Inactive’ & ‘No Manager’ status

    Couple of days back, got a mail from Development team that their concurrent requests are not being processed in DEV instance. From the front end, requests are showing ‘Inactive’ & ‘No Manager’ I started looking into it. From the historical run of the job, it was showing as processed by ‘Standard Manager’. Hence thought of Continue reading

  • How to trace in E-Business Suite

    As a DBA, the most challenging task comes when we need to work or diagnose the performance issue. Since I have worked extensively on performance tuning, I would like to share different ways to trace Oracle user session. Tracing is a very handy tool for any DBA to be the first thing to look for Continue reading

  • How to bounce Material Transaction Interface manager

    It is necessary to know the concurrent program corresponding to ‘Material Transaction’ Interface manager. This is so because before you launch this interface manager, corresponding concurrent program schedule needs to be cancelled. Concurrent program corresponding to ‘Material Transaction’ interface manager – “Process transaction interface” Step 1: Cancel the existing schedule Login using ‘System Administrator’ responsibility 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