Oracle Apps
Issues and learnings under the umbrella – Oracle Apps
-
EBS- SSO Integration with Oracle Identity Cloud Service (IDCS)
Recently got an opportunity to do a POC for implementing SSO with Oracle EBS (12.2.5) using Oracle IDCS approach. It’s fairly simple and much less intrusive work as far as work within eBS is concerned. One primary component for this solution is EBS Asserter which needs to be deployed and configured in DMZ (Security policy Continue reading
-
“Could Not lock the record” while trying to cancel the running concurrent request
Recently came across a typical scenario where I needed to cancel a long running concurrent request and while doing the same from the front end, I kept getting error “Could not lock the record“. Later on I thought to mark it as terminated by running below “update” statement from the database. But again this “update” Continue reading
-
Troubleshooting EBS Workflow Notification mailer Issues
Oracle E-Business Suite’s Workflow Notification Mailer sends an email notification in a multi-step process. After a workflow notification is sent, it immediately appears in the recipient’s EBS Worklist UI. For each workflow notification,business event oracle.apps.wf.notification.send is raised to send the same notification as email. For a workflow notification to be e-mailed, following statements should be Continue reading
-
ORA-955 name is already used by an existing object
Recently while working on some upgrade activity, I faced an interesting scenario. I am supposed to create a sequence in Oracle database (11.2.0.4). I queried DBA_OBJECTS but didn’t find the object there. “adop -cleanup” phase was all completed. Database recyclebin if OFF but still went ahead and purged “recyclebin”. Still it did not let me Continue reading
-
TNSPing & SQLPlus just hang without errors
Usually, when you connect to Oracle, you get errors that give you some feedback on what is happening. Today, I got an issue where when trying to connect to SQLplus or even running a tnsping command was hanging. Not getting any error to start the troubleshooting. The issue was definitely some sort of connectivity but Continue reading
-
Decrypt weblogic admin password
Pls follow below steps to decrypt Weblogic admin password Step 1:- Create a file called – decryptPass.py and udpate the file with below cotents Step 2:- Set Domain environment variable cd $FMW_HOME/user_projects/domains/<domain_name> Once it is properly set, do echo $DOMAIN_HOME and you will find it getting properly displayed Step 3:- Get encrypted password value from boot.properties Continue reading
-
Collection of useful script for Oracle Apps DBA
Below are some of the most useful script for any Oracle APPS DBA. These are handy for day to day monitoring and troubleshooting activity. Hope this helps. Script to monitor Tablespace Growth This probes the dba_hist_tbspc_space_usage table and gets the data as old as the retention time of AWR snap Starting Oracle 10G, Oracle records Continue reading
-
Oracle Apps R12.2.2 Log file location and Environment Variables
I have compiled the name and location of all the log files in Oracle EBS 12.2.2. As a DBA, I find it quite handy when you need to do some troubleshooting with a definite timeline. Oracle Apps R12.2.2 Log file location Also below is the frequently used and very useful environment variables that comes handy Continue reading
-
Space reclaim using complete database export import
We had a non-prod database which was having more than 50% of space as free. Objective was to reclaim the space at OS level and release the space back to storage. This is an Oracle E-Biz environment. Ebiz Version – 12.2.2 Oracle DB version – 11.2.0.3 OS – 64 bit Oracle Linux Tried to resize Continue reading
-
“Output Post Processor” Concurrent Manager not able to start
Development team informed me of an issue where the concurrent job (that needs post processing) errored. On reveiwing the request log file, i notice an isue with ‘Output post Processor’. I checked the OPP in the ‘Administer Concurrent Manager’ screen and found Actual=4 and Target=0 processes I tried to restart but still getting the same 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
- Encrypting Your Unencrypted RDS Instance with Python
- Encrypt EBS Volume for an already launched EC2 Instance
- Python/boto3 script to dump AWS Subnet information into a CSV File
- Python/Boto3 Script to list all the AWS resources in Default VPC across all the listed AWS Regions
- Python/boto3 script to generate a CSV report for all the AWS Security groups NOT attached to any resource
My Journey to the cloud... 