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.
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.
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.
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...)
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.
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 220.127.116.11 or above.
The post Oracle GoldenGate 12c: Twelve Advanced New Features appeared first on VitalSoftTech.
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.
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.
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.
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.
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.
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.
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.