Subscribe to VitalSoftTech feed
Database Administration | Oracle | Oracle Training | DBA Support | Oracle 12c DBA | GoldenGate | GoldenGate 12c | DBA Interview Questions | Goldengate Interview Questions | Natik Ameen
Updated: 2 days 18 hours ago

Help Me Help You!

Mon, 2017-01-16 09:45
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 […]
Categories: DBA Blogs

CQLSH – Unable to connect to any servers Tried connecting to [(‘’, 9042)

Thu, 2016-12-01 09:30
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 [('', 9042)" message. Learn how to modify the configuration so that the hostname is not required.
Categories: DBA Blogs

ORA-04031 Unable to Allocate Shared Memory

Sat, 2016-11-05 02:38
When executing a procedure I am getting "ORA-04031: unable to allocate shared memory" error. How do I avoid this error?
Categories: DBA Blogs

ORA-00054 resource busy and acquire with NOWAIT specified or timeout expired

Sun, 2016-09-04 19:32
What is the cause of the error ORA-00054 "resource busy and acquire with NOWAIT specified or timeout expired"?
Categories: DBA Blogs

ORA-12537: TNS:connection closed

Wed, 2016-08-03 01:18
When trying to establish a sqlplus connection I get the "ORA-12537: TNS:connection closed" error messgae. How do I resolve this?
Categories: DBA Blogs

How to Clean Up GoldenGate Integrated Extract if the Delete Extract fails?

Thu, 2016-06-16 15:13
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.
Categories: DBA Blogs

ORA-01110 data file %s

Tue, 2016-06-07 19:42
What is the cause of the error "ORA-01110 data file %s"? How do I resolve this?
Categories: DBA Blogs

ORA-00918 column ambiguously defined

Wed, 2016-06-01 17:49
What is the cause of the "ORA-00918 column ambiguously defined" error? How do I resolve this?
Categories: DBA Blogs

Generate Multiple AWR Reports Quickly

Tue, 2016-05-10 20:40
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.
Categories: DBA Blogs

How to solve “ORA-03135 connection lost contact” error?

Thu, 2016-04-14 20:54
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?
Categories: DBA Blogs

ORA-02010 missing host connect string

Tue, 2016-04-05 20:29
What is the cause of the error "ORA-02010 missing host connect string"? How do I resolve this?
Categories: DBA Blogs

How to Use GoldenGate Token with COLMAP?

Tue, 2016-03-29 07:00
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 […]
Categories: DBA Blogs

Relocating OCR File and Voting Disk to new Diskgroup

Tue, 2016-02-23 00:11
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.
Categories: DBA Blogs

Graph Database Everywhere by 2020

Sun, 2016-01-31 01:45
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.
Categories: DBA Blogs

Tuning ASM Rebalance Operation when using FLASH drives

Tue, 2016-01-12 06:25
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 […]
Categories: DBA Blogs

Fast, Flexible and Near-Zero Admin – Next Gen MySQL offerings with Google Cloud SQL

Wed, 2015-12-16 00:22
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 […]
Categories: DBA Blogs

Top 13 Preferences to Tweak when using SQL Developer 4

Mon, 2015-12-07 10:02
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.
Categories: DBA Blogs

What to expect at the NextGen Cloud Conference and Why you should attend it?

Wed, 2015-12-02 23:32
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.
Categories: DBA Blogs

ORA-27101 Shared Memory Realm does not exist

Thu, 2015-11-19 23:28
What is the cause of the "ORA-27101 Shared Memory Realm does not exist"? How do I resolve this?
Categories: DBA Blogs

Oracle SPARC M7 Processor Breaks the “Sacrifice Performance for Security” Rule and Much More

Mon, 2015-11-16 04:20
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 ...
Categories: DBA Blogs