Oracle VirtualBox New Version Released

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.

SYSBACKUP, SYSDG and SYSKM Administrative Users in Oracle 12c

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.

How to Add Disk Storage to Oracle VirtualBox with Linux Guest OS?

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.

Cloning Oracle 12c Home Binaries

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.

Deinstalling GoldenGate 12c

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.

Profiling your Database 12c – Part 1 – Using Dynamic Performance Views

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. Below are some views which provide these statistics. In Oracle 12c, to support multitenant environments, most of the views like V$SYSSTAT and V$EVENT_HISTOGRAM now have an additional CON_ID column.

The post Profiling your Database 12c – Part 1 – Using Dynamic Performance Views appeared first on VitalSoftTech.

Oracle GoldenGate 12c: Silent Install

Starting with GoldenGate 12c, Oracle has moved the installation mechanism into the familiar Oracle Universal Installer, GUI framework. It's a good move not only in terms of ease of use but also for the uniformity of the install process across all Oracle products.

The post Oracle GoldenGate 12c: Silent Install appeared first on VitalSoftTech.

GoldenGate: OGG Commands III

Cataloged here are some very important, common commands that are used via the GGSCI interface during the GoldenGate configuration and for troubleshooting. Related Links • GGSCI Commands I • GGSCI Commands II

The post GoldenGate: OGG Commands III appeared first on VitalSoftTech.

Oracle 12c Silent Mode Binary Install and De-install

Installation of the Oracle Binaries is a pretty simple task for the DBA's. However the process may become exhaustive if you are repeatedly performing these installs on a number of servers.

The post Oracle 12c Silent Mode Binary Install and De-install appeared first on VitalSoftTech.

Oracle GoldenGate 12c: Installation with Universal Installer

A number of new features have been introduced with the release of Oracle GoldenGate 12c. Using the Oracle Universal Installer(OUI) to install the binaries, is one of them. Previously this was performed using the untar/unzip utility to extract the files into the home directory. This feature appears in line with the effort by Oracle to standardized the look and feel of their products and to make installation easier in the different database environments.

The post (more...)

Difference between In-Database Archiving and Temporal Validity in 12c

In Oracle Database 12c there are two new features which can be used to control the validity and visibility of the data. They are called Temporal Validity and In Database Archiving. The concepts behind these two new features are a bit interlinked, so it is important to understand and distinguish between these two. In this […]

The post Difference between In-Database Archiving and Temporal Validity in 12c appeared first on VitalSoftTech.

Oracle GoldenGate 12c: Twelve Advanced New Features

With the release of Oracle GoldenGate 12c, management of the Replication environment has been eased further. In addition to this, it provides support for Oracle 12c multitenant database, a more secure authentication mechanism and much better performance. Most of these features require the database to be 11.2.0.4 or above.

The post Oracle GoldenGate 12c: Twelve Advanced New Features appeared first on VitalSoftTech.

Protected: VST – Dashboard

There is no excerpt because this is a protected post.

The post Protected: VST – Dashboard appeared first on VitalSoftTech.

In-Database Archiving in Oracle 12c Database

The In-Database Archiving in Oracle 12c Database, llows you to mark certain rows inside the table as inactive or archived. The rows marked as archived will stay in table but they will be unavailable to users and applications.

The post In-Database Archiving in Oracle 12c Database appeared first on VitalSoftTech.

Recovery of CDB, Root and PDBs in 12c. Is it different from a Non-CDB Database Recovery?

Recovery of CDB, ROOT and PDB Database in 12c can be performed at the CDB container level (with ALL PDBs), ROOT or as at the individual PDB level. For the recovery at the CDB level, obviously the backups for ALL the PDBs must be present.

The post Recovery of CDB, Root and PDBs in 12c. Is it different from a Non-CDB Database Recovery? appeared first on VitalSoftTech.

Oracle 12c Database: Managing Common and Local Users, Roles and Privileges

Managing users, roles and privileges is a very important aspect of the database administration. With Oracle 12c there is a second dimension to controlling this user access and privileges.

The post Oracle 12c Database: Managing Common and Local Users, Roles and Privileges appeared first on VitalSoftTech.

Oracle VM Virtualbox 4.2.18 is now available

According to Oracle Virtualization blog the latest maintenance release of Oracle VM Virtualbox 4.2.18 is now available. Virtualbox is Oracle's standard tool for desktop virtualization. The latest release is a maintenance release and mostly contains bug fixes.

The post Oracle VM Virtualbox 4.2.18 is now available appeared first on VitalSoftTech.

Oracle 12c – Manage Multitenant CDB and PDBs with EM Express

Manage Multitenant CDB and PDBs with EM Express. Quick and easy steps to create, setup and deploy EM Express.

The post Oracle 12c – Manage Multitenant CDB and PDBs with EM Express appeared first on VitalSoftTech.

Oracle 12c Database: Create 12c CDB, PDB Databases Using OUI

When installing Oracle Software, you can create 12c CDB, PDB Databases using OUI, just like you used to do in the previous versions of the Oracle database.

The post Oracle 12c Database: Create 12c CDB, PDB Databases Using OUI appeared first on VitalSoftTech.

Oracle 12c Database: Managing PDBs using Database Configuration Assistant

In 12c, the database configuration assistant can also be used to manage the PDB's alongside the CDB and non-CDB databases. In this article we will look at managing the PDBs, using the database configuration assistant.

The post Oracle 12c Database: Managing PDBs using Database Configuration Assistant appeared first on VitalSoftTech.