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: 4 days 7 hours ago

OGG-02060: ENABLE_GOLDENGATE_REPLICATION is not set to true for Integrated Extract

Mon, 2015-08-17 20:59
When creating the GoldenGate Integrated Extract why do I get the message "ENABLE_GOLDENGATE_REPLICATION is not set to true"?
Categories: DBA Blogs

Database Rankings July 2015

Tue, 2015-07-28 10:55
Here is an interesting Database rankings survey on the db-engines site, which measures the general interest in the different databases.
Categories: DBA Blogs

BIWA Summit 2016 – Call for Speakers Open

Wed, 2015-07-22 15:21
BIWA Summit - The Big Data + Analytics User Conference. The call for Presentation Abstracts is now open. Submit yours today.
Categories: DBA Blogs

Latest Release of Oracle Exadata Exachk and HealthCheck

Mon, 2015-07-13 15:13
Announcing the release of Exachk Version 12.1.0.2.4_20150702. Exachk is a tool that is used to quickly determine the health of the entire Exadata infrastructure. Some of the key components that are checked include the database, cell servers and the network. This tool further reviews the configuration of the system and compares with the best practices. […]
Categories: DBA Blogs

ORA-04030 Out of Process Memory When Trying To Allocate s Bytes

Mon, 2015-07-13 14:47
What is the cause of the "ORA-04030 out of process memory when trying to allocate s bytes" error? How do I resolve this?
Categories: DBA Blogs

ORA-29760 INSTANCE_NUMBER Parameter not specified RAC

Wed, 2015-07-08 20:00
Question: When converting a non-RAC instance to a RAC instance I get the “ORA-29760 instance_number parameter not specified RAC” error. SQL> startup; ORA-29760: instance_number parameter not specified USER (ospid: 29871): terminating the instance due to error 29760 Instance terminated by USER, pid = 29871 How do I fix the ORA-29760 Error? Answer: The oerr utility […]
Categories: DBA Blogs

OGG-02060 The Oracle Mining Database is not Configured Properly to Support Integrated Capture.

Mon, 2015-06-22 20:33
When creating the GoldenGate Integrated Extract I get the OGG-02060 error. How do I resolve it?
Categories: DBA Blogs

Creating Database Using DBCA Silent Mode

Mon, 2015-06-08 16:11
Creating database using DBCA silent mode? Learn how to provision a database in a non-interactive mode.
Categories: DBA Blogs

ORA-01403 No Data Found Error

Tue, 2015-05-19 20:29
What is the cause of the "ORA-01403 no data found" error? What can be done to solve this?
Categories: DBA Blogs

What is the purpose of the NOFILENAMECHECK parameter?

Mon, 2015-05-18 17:50
I am duplicating my database onto a remote host. In the command, the NOFILENAMECHECK parameter is used. What is its purpose?
Categories: DBA Blogs

RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP

Tue, 2015-05-05 09:54
I am trying to restore the controlfile but and getting the RMAN-06563 error. I know I have a backup on the controlfile but RMAN is not able to see it.
Categories: DBA Blogs

Need a Database Sandbox on Solaris or Linux on your Desktop? Set it up using Oracle Virtualbox in 10 mins

Sat, 2015-05-02 09:38
Oracle VM Virutal box runs as a virtual machine on your Windows, Mac, Linux or Solaris desktop. A number of Guest operating systems are supported. It takes only a few minutes to download the software and import pre-created templates and you are up and running in less that 10 mins. If necessary you can download […]
Categories: DBA Blogs

Solving RMAN-06059: Errror identifying file

Mon, 2015-04-27 10:43
When using RMAN to backup archivelog files, an error “RMAN-06059: Errror identifying file ” is returned. Previously the backups have been running successfully prior to this.
Categories: DBA Blogs

GoldenGate ggsci returns “ld.so.1: ggsci: fatal: relocation error” after GoldenGate 12c upgrade

Sun, 2015-04-12 00:20
When invoking ggsci after GoldenGate 12c upgrade why is the "ld.so.1: ggsci: fatal: relocation error" returned?
Categories: DBA Blogs

Upgrading your Grid Infrastructure to 12c? Some things to watch out for!

Thu, 2015-04-09 00:19
Ready to upgrade your Grid Infrastructure and RAC database to 12c? Make sure to go through the following items so that your upgrade does not fail.
Categories: DBA Blogs

Adding Log Groups on Oracle DataGuard Database

Mon, 2015-04-06 15:12
When adding Redo logs to a database which has a DataGuard associated with it, the log files have to manually be added to the destination. Below are the steps on how to add them to both the source and the DataGuard databases. Adding Log Groups on Oracle DataGuard Database On the source first determine the […]
Categories: DBA Blogs

Want to SPEED Up Your Database Tasks? DBMS_PARALLEL_EXECUTE to the rescue!

Thu, 2015-03-26 05:56
Use DBMS_PARALLEL_EXECUTE to divide one huge task into multiple small tasks that can be executed at the same time. See how many ways are there to divide.
Categories: DBA Blogs

Oracle 12c Deprecated Database Parameters

Mon, 2015-03-02 15:24
When upgrading to Oracle 12c it's good to be familiar with the deprecated parameters. These are not really desupported, just that they will be de-supported in future versions of the Database. Read more ..
Categories: DBA Blogs

Oracle MAA 12c – A Data Plan for Meeting Every Organization’s Needs

Mon, 2015-02-02 22:36
Data is one of the most valuable and crucial asset for any company, hence businesses spend huge amounts of money on their enterprise software to ensure its safety and availability. RAC and clustering are some examples of the ways companies practice for high availability and performance of their enterprise and databases. However there are still […]
Categories: DBA Blogs

Oracle ZFS Network Attached Storage ZS4-4 System for Oracle Database 12c

Sun, 2015-01-11 19:02
Oracle has recently announced its latest generation of Network-attached Storage or NAS system namely the Oracle ZFS Storage ZS4-4. With the new Oracle Database 12c in place, ZS4-4 is capable of providing some brand new exciting features, which in the words of Oracle VP, Mr. John Fowler expand Oracle’s leadership in NAS performance. New Capabilities […]
Categories: DBA Blogs

Pages