With Oracle 184.108.40.206, 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 (220.127.116.11). 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.
For the about a week I have been getting an “ORA-27054: NFS file system not mounted with correct options” error when running an RMAN backup to a NFS mount point. The system administrator has not been successful in identifying the cause as it shows that the correct mount point options are being used. Metalink Doc.
The post ORA-27054: NFS file system not mounted with correct options appeared first on VitalSoftTech.
The Oracle VirtualBox software, version 4.3.8 has been released. This is a maintenance release of the software, fixing 200+ bugs across various previous versions. Here you can find the change log and the manual.
The post Oracle VirtualBox New Version Released appeared first on VitalSoftTech.
Large enterprise database environments have dedicated DBAs performing specific database roles. Some of these specific roles include database storage management, tuning, backup and recovery, etc. Inside these organizations there has been growing concern to further ensure the use of the SOD (Segregation of Duties) concept, to fulfill duties for these roles.
The post SYSBACKUP, SYSDG and SYSKM Administrative Users in Oracle 12c appeared first on VitalSoftTech.
Are you looking to install Oracle software on your VirtualBox but are running low on disk space? Learn how to add disk storage to Oracle VirtualBox with Linux Guest OS.
The post How to Add Disk Storage to Oracle VirtualBox with Linux Guest OS? appeared first on VitalSoftTech.
Almost every backup and recovery concern is focused on protecting the data stored inside database and rightly so. But during the course of a DBA career, restoring the Oracle Home or duplicating is sometimes is necessary.
The post Cloning Oracle 12c Home Binaries appeared first on VitalSoftTech.
In GoldenGate 12c, the installation and the de-installation process has been standardized to use the Oracle Universal Installer (OUI) interface. In this article we will look at how can we deinstall Oracle GoldenGate.
The post Deinstalling GoldenGate 12c appeared first on VitalSoftTech.