Oracle Database
-
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
-
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
-
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
-
Common Database Wait Events
Below is the document containing the most common database waits seen during the day to day activity of an Oracle DBA. It contains the possible causes and different ways to alleviate the wait. Common Database waits Happy reading! -Anand Continue reading
-
PASSWORD column NULL in DBA_USERS from 11g onwards
I got a request from support team to reset the DBA user password as they were getting some error due to password expiration. However support person was not aware of the password. Oracle 11g brought several security enhancements, as it is well known by the 11g users. On previous Oracle versions it was possible to Continue reading
-
ORA-01017 error while accessing DB link from 9i to 11g
Today I faced a strange issue. Support team needed to extract some data from PeopleSoft database (11.2.0.1) via oracle ERP database (9.2.0.6). A database links already exists between the 2 databases but when SELECT query is fired, we were getting below error. and I was pretty sure that the login credential for the remote database is Continue reading
-
Understanding Database locks using v$lock
Many times I have seen either user or development team complaining of their DML statements running long or hung. And it is most of the time perceived as caused by slow database. But every time, I don’t see any contention from database side. It is the database lock that has been causing the ‘hung’ behaviour. 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... 