VitalSoftTech

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: 7 hours 9 min ago

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

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

Top 5 Announcements at Oracle Open World 2015 you should know about

Tue, 2015-11-03 09:45
When it comes to information technology, perhaps no other company in the world has led the way in innovation more so than Oracle. Because of this, there were many announcements and surprises at Oracle Open World 2015.
Categories: DBA Blogs

How to resolve the ORA-04063 “%s has errors” message?

Mon, 2015-11-02 20:04
What is the cause of the error ORA-04063? How do I resolve this? There appears to have been an attempt to access an invalid view or a procedure. Learn more here ..
Categories: DBA Blogs

Top 8 Strategies to Thrive at Oracle OpenWorld

Tue, 2015-10-06 14:08
Yes! It’s that time of the year again when we start planning for the premier Oracle OpenWorld. So let’s get right into it! Read more here – Top 8 Strategies to Thrive at Oracle OpenWorld o o o o o o Realted article – Advanced Sessions at Oracle OpenWorld 2015 I I I
Categories: DBA Blogs

Troubleshoot Oracle GoldenGate Using Exception Handler

Mon, 2015-09-21 21:08
By default, a Replicat process ABENDS when the data being modified doesn’t exist in the target database. Learn how to troubleshoot Oracle GoldenGate Using Exception Handler mechanism. When this happens you need to troubleshoot the issue and correct it before the Replicat process can proceed. But this wouldn’t be easy, as sometimes it can take […]
Categories: DBA Blogs

Pages