In most of the environments, one set of OGG processes (1 Extract & 1 Replicat process) is sufficient for change data synchronization. But if your source database generates a huge volume of data then a single process may not be sufficient to handle the data volume. In such a scenario there may be need to […]
The post GoldenGate not keeping up? Use GoldenGate Range function to split up the process appeared first on VitalSoftTech.
In addition to improving read I/Os, Oracle Exadata Write back flash cache also provides the ability to cache write I/Os directly to PCI flash. Exadata storage software version 22.214.171.124.1 is the minimum version required to use write back flash cache. Grid infrastructure and database homes must run 126.96.36.199.9 or later to use with Write-back Smart […]
The post Configure Oracle Exadata Write Back Flash Cache appeared first on VitalSoftTech.
As database gurus and fanatics of the world, as well as hotels and cabbies of San Francisco know, one of the largest enterprise software events, Oracle OpenWorld 2014 was held in San Francisco from September 28th, 2014 to October 2nd, 2014. The reason the later group know a tad bit about the event is because […]
The post Overview of Oracle OpenWorld 2014 appeared first on VitalSoftTech.
Oracle Database is one of the leading relational database management system and is used all over the world. It has various training’s, exams and certifications for its Database and other products. However due to regular update in Database, they have to redesign their trainings, certification and exams to add new features and to remove old […]
The post Oracle Database 10g Certifications to Expire in March 01, 2015 appeared first on VitalSoftTech.
WordPress 4.0 has been released. Upgraded my site without any issues. Key enhancements include: Intuitive editing Toolbar stays in place as you add content. Allows you to focus on your content. Seamless Media Embeds Just placing the link allows you to see the content. New Plugin Browser Browse Plugins and Reviews directly in the dashboard. […]
The post Welcome to WordPress 4.0 “Benny” appeared first on VitalSoftTech.
Oracle OpenWorld is an annual conference organized by Oracle, which provides Oracle users and technologists a unique opportunity to learn and socialize. Oracle OpenWorld 2014 is scheduled to take place from September 28 – October 2, 2014 in San Francisco. The conference is designed to provide Oracle users a platform to find best suited Oracle […]
The post A Preview of Oracle OpenWorld 2014 appeared first on VitalSoftTech.
With Oracle 188.8.131.52, the largest performance enhancing features, the Oracle 12c In-memory database option, has been released. Learn more about how to enable it, the licensing costs, etc. Also read other about Oracle 12c In-Memory Database FAQ's here ...
The post Increase DSS Performance by 100x and OLTP by 2x. Learn more about Oracle 12c In-Memory Database. appeared first on VitalSoftTech.
Oracle GoldenGate supports data mapping and manipulation. It is done by using options of Table (Extract) and Map (Replicat) parameters. By default OGG assumes that SOURCE and TARGET table definitions are same that part of replication.
The post Oracle GoldenGate Data Transformation appeared first on VitalSoftTech.
Oracle 12c introduced a new, very useful security feature to store and display the last login information for non-sys users, logging in via SQL*PLUS. The last login time is displayed in the banner by default when we log into the database using SQL*PLUS in 12c. Related Articles • Oracle 12c: Data Redaction Unified Auditing Extended SHA-2 […]
The post Oracle 12c Last login time for Non-Sys Users appeared first on VitalSoftTech.
If you have your Oracle VM VirtualBox setup and running there is a possibility that you may need to setup the network for the Virtual Machine to make it accessible from the host machine (Desktop or Laptop). This may be needed when you want to connect your local applications to the database running on the VM VirtualBox.
The post Oracle VM VirtualBox Tutorial: Connecting Applications from your Desktop to a database on VirtualBox appeared first (more...)
Bi-Directional Replication also known as Active-Active Replication, is a configuration where both databases are used as an active site and applications perform DML/DDL activities on both Databases. The OGG processes is configured to replicate the transaction data of both the source databases back and forth to each other. 1. Advantages Bi-directional GoldenGate Replication can be […]
The post GoldenGate Active-Active Database Replication with Conflict Detection and Resolution appeared first on VitalSoftTech.
In Oracle 12c, a new interesting much needed feature, has been introduced which controls the maximum amount of the PGA memory consumed by the user processes. The PGA_AGGREGATE_LIMIT parameter limits the amount of memory used by processes in the PGA.
The post Limiting PGA with PGA_AGGREGATE_LIMIT in Oracle 12c appeared first on VitalSoftTech.
DBA’s, Developer’s and SYS Admin’s require test environments to perform testing such as OS/Database patching, upgrades, new features, etc. before performing these tasks on the Production environments. They are not always successful in finding a place to test these changes and at other times it takes too long to get the environment provisioned. Many of […]
The post Provision Oracle VM VirtualBox using Pre-Built Developer VMs appeared first on VitalSoftTech.
Learn about GoldenGate Extract, Pump, Replicat, GGSCI, Logdump, Troubleshooting and Upgrade.
The post GoldenGate Extract, Pump, Replicat, GGSCI, Logdump, Troubleshooting and Upgrade Notes appeared first on VitalSoftTech.
This article demonstrates the steps to perform an in-place Oracle GoldenGate 11gr2 Upgrade (184.108.40.206). Expectations and Requirements There should be NO DATA LOSS. There should be NO database downtime. Oracle GoldenGate processes names will remain unchanged. Oracle GoldenGate replication will be DOWN for the period of OGG upgrade activity. Upgrade Oracle GoldenGate binaries Source and […]
The post Oracle GoldenGate 11gr2 Upgrade appeared first on VitalSoftTech.
We have been migrating our databases from the non-Exadata servers to the Exadata Database Machine using the “RMAN 11g Duplicate standby from Active database” command, to create the standby databases on the Exadata machine. Below are the steps which were performed for these successful migrations. Assumptions Here we assume that the following tasks has been […]
The post Migrating a Database to an Exadata Machine appeared first on VitalSoftTech.
COLLABORATE 14 - IOUG starts in a week. Very excited to be presenting "Learn What It Takes to Manage the Oracle 12c Database in the Cloud" on Thursday April 10, 2014.
The post Speaking at COLLABORATE 14 – IOUG on Managing Oracle 12c appeared first on VitalSoftTech.
A new version of the Oracle VirtualBox Software (4.3.10) has been released and can be downloaded here. This release fixes about 23 bugs. VirtualBox Resources • Pre-Built Developer VMs (for Oracle VM VirtualBox) • Oracle Linux VM Download • VirtualBox HOWTOs and tutorials documentation. Other Related Articles • How to Add Disk Storage to Oracle.
The post Oracle VirtualBox New Released appeared first on VitalSoftTech.
Getting ready for the DBA or the GoldenGate Admin interview? Quickly brush up for the Goldengate section using the 50 Oracle GoldenGate interview questions and answers article. The questions are designed to perform a quick review of major topics such as basic configuration, performance, troubleshooting, supported features, etc.. Click here Other Related Articles • Oracle.
The post 50 Oracle GoldenGate Interview Questions and Answers appeared first on VitalSoftTech.
In the Multitenant world, the PDB Database is considered an independent database but the operational tasks performed at the CDB level effect all the PDB databases plugged into it. The task of setting up of a Data Guard, switching or failing over are all performed at the CDB level. When the Data Guard is initially.
The post Setting up Oracle 12c Active Data Guard Database appeared first on VitalSoftTech.