Database Administration | Oracle | Oracle Training | DBA Support | Oracle 12c DBA | GoldenGate | GoldenGate 12c | DBA Interview Questions | Goldengate Interview Questions | Natik Ameen
Updated: 2 hours 36 min ago
Hello everyone, I hope the holidays went well for you, best of wishes from my family to yours! It is a new year and we all have new year resolutions! After years of creating blogs for you all, I have decided to turn it up a notch! As many of you already know, I am […]
When trying to connect to a node in the Cassandra Cluster using cqlsh, I get the "Unable to connect to any servers. Tried connecting to [('127.0.0.1', 9042)" message. Learn how to modify the configuration so that the hostname is not required.
When executing a procedure I am getting "ORA-04031: unable to allocate shared memory" error. How do I avoid this error?
What is the cause of the error ORA-00054 "resource busy and acquire with NOWAIT specified or timeout expired"?
When trying to establish a sqlplus connection I get the "ORA-12537: TNS:connection closed" error messgae. How do I resolve this?
If the extract process was not un-registered from the database then Cleaning Up GoldenGate Integrated Extract Using DBMS_CAPTURE_ADM.DROP_CAPTURE will be necessary.
What is the cause of the error "ORA-01110 data file %s"? How do I resolve this?
What is the cause of the "ORA-00918 column ambiguously defined" error? How do I resolve this?
Occasionally there is a need to generate multiple AWR reports for database analysis. In my case, a storage vendor will use a tool to extract data from all time periods from the AWR reports to find IO related specific information. Here is how I generated these reports.
Users are connected to the database via TNS and abruptly get disconnected. What is the cause of the "ORA-03135 connection lost contact" error? How can this be avoided?
What is the cause of the error "ORA-02010 missing host connect string"? How do I resolve this?
Tokens are used to capture and store the environment variable values in the header of the GoldenGate trail record file. The trail file header contains a lot of information about the physical environment that produced the trail file and trail file contents. We can use this information to map token data to a target column […]
Are you moving you OCR and Voting disks from one storage to another? Read the step-by-step instructions on how to to move these files to a different diskgroup.
The growing complexity and competition among large and small businesses has increased the demand for consistent, accurate and enriched product information. Armed with the ability to identify changes and user trends, it helps improve business processes, supports decision making, and helps retailers maintain a competitive edge.
When disks are added to a diskgroup, the data on all the disks are spread out evenly. One of last steps in this process is to COMPACT the data and place it on the outer tracks of the disks. This results in data being accessed faster due to the reduced seek time on the outer […]
As technology continues to advance, one of the greatest innovations within information technology has been the Cloud. Useful in businesses and organizations throughout the world, it has revolutionized the way information technology works. As a result, many companies can now focus more on building applications rather than configuring replications, applying patches and updates, and managing […]
Support for customizing SQL Developer 4 continues to grow. Tweaking has made the platform extremely user-friendly. Of course, personalizing the platform requires a little research. But if you want to maximize SQL development, you need to explore the possibilities.
The NexGen Cloud Conference is an annual gathering of vendors, innovators and technology users that can help quickly come up to speed with the latest technologies and create value for you and your company.
What is the cause of the "ORA-27101 Shared Memory Realm does not exist"? How do I resolve this?
Oracle Executive Vice President John Fowler used the occasion of Open World 2015 to introduce Oracle's SPARC M7 processor, the fastest in the world. Learn more ...