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.
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 […]
Oracle VM VirtualBox Tutorial: Connecting Applications from your Desktop to a database on VirtualBox
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.
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 (22.214.171.124). 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 […]
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 […]
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.
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.
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.
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.
Database dynamic performance views provide various statistics like session events, system events, waits, etc.. These statistics are mostly cumulative values, aggregated from the time the instance was started.
The post Profiling your Database 12c – Part 1 – Using Dynamic Performance Views appeared first on VitalSoftTech.