Showing posts with label ORACLE 12c. Show all posts
Showing posts with label ORACLE 12c. Show all posts

Thursday, 30 March 2017

How to create database link in oracle 11gr2

                                 Database link Details:


Database link is a schema object in one database which enables us to access objects
 on another databases.And the other databases not need to be an Oracle Database
 system.But here, to access non-Oracle systems we should use Oracle different 
Services.

Wednesday, 1 March 2017

Oracle 12c Installation on RHEL 6.5 with VMWARE Java 132 error

AND FINALLY THE INFAMOUS JAVA:132 ERROR MESSAGE
 

$ ./runInstaller
Starting Oracle Universal Installer…
Checking installer requirements…
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed
All installer requirements met.

Saturday, 20 February 2016

Rolling Forward a Physical Standby Database Using the RECOVER Command . 12C New Features

A standby database is a transactionally-consistent copy of the production database. It enables production Oracle database to survive disasters and data corruption. If the production database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch a standby database to the production role, minimizing the downtime associated with the outage. Moreover, performance of production database can be improved by offloading resource-intensive backup and reporting operations to standby systems. As you can see, it’s always desirable to have standby database synchronized with the primary database.

Thursday, 18 February 2016

Oracle 12c Database : Upgrading to Oracle Database 12c

There are several methods available which can be used for Upgrading to Oracle Database 12c. You can choose the manual upgrade method, the export/import procedure, transportable tablespaces method or you can use the Database Upgrade Assistant (DBUA) graphical interface

12c database New features list

The below is Gathered from various sources and listed out here, thanks to all who shared those in their respective blogs, Optimizer Blog, Tim hall, Ask Tom etc.

Core Architecture Changes:-