March 2014 Blog Posts (11)

Data Guard Broker installation,configuration,monitoring and deactiving


Oracle Data Guard broker software install with oracle database software and program bin file could find at $ORACLE_HOME/bin/dgmgrl location. Benefit of dgmgrl is most of the actions on primary/standby database can be done easyly through this tool, especilly switchover and managing primary/standby database.


When you are using the Broker to maintain your Data Guard configuration you must use…


Added by Bugra Canbakal on March 28, 2014 at 2:08am — No Comments

How to make automated Oracle 11gR2/12c installer for Linux CentOS and RHEL 6.5

 The text below is a step-by-step instruction - how to build full automated silent offline setup of Oracle11gR2 (or Oracle12c) on Linux (RHEL6.5 or CentOS6.5).

feel free to send comments and questions

 Oracle Data Base version: 11g Release 2 ( I used the Oracle Database patch set, release  (is a full installation of the Oracle Database software). …


Added by Eisen Stark on March 27, 2014 at 2:30am — No Comments

Sync the data between primary and archive database using dbms_comparison

Oracle 11g introduced a new function dbms_comparison, and you can use it to compare the data and structure between your primary database and archive database.

Currently I have a table called dbcopy_tables which simply has 2 columns, recovery_types and table_name and a dblink needs to be created on primary database pointing to archive database.

The following script can be use to sync the data between primary and archive database, currently I only handle table recovery type ALL…


Added by Gang Zhang on March 26, 2014 at 2:30pm — No Comments

Performance testing of Hive, Impala and esProc Part 2

In the previous article, we've tested the grouping computing. In this article, we will test their performances and compare their results in associating computing.
Associating computing test on narrow tables
Data sample:
Associated table …

Added by Jim King on March 25, 2014 at 2:42am — No Comments

Performance Comparison Testing three scripts: Hive, esProc, and Impala Part 1

Performance comparison within Hive, Impala and esProc in grouping

summarizing, and join computing.

Hardware environment

PC count: 4

CPU: Intel Core i5 2500 (4 cores)

RAM: 16G

HDD: 2T/7200 rpm

Ethernet adapter: 1000 M

Software environment

OS: CentOS6. 4

JDK: 1. 6

Hadoop/hdfs 2. 2. 0

Test Result

Hive 0. 11. 0

esProc 3. 1

Impala 1. 2. 0

Data sampling



Added by Jim King on March 18, 2014 at 12:33am — No Comments

Oracle GoldenGate 12c

Oracle GoldenGate 12c Silent Install

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


Added by Natik Ameen on March 3, 2014 at 9:30pm — 1 Comment




Added by Anar Godjaev on March 3, 2014 at 9:27am — No Comments

Monthly Archives











Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins



Blog Posts

Streamline Your Business Process with Real Estate Data Entry Services

People in the real estate business have to deal with huge volumes of data on a regular basis. It includes the data that is generated from legal documents, property valuation statements, latest commercial and non-commercial property information, etc. This database should be regularly updated and processed properly to help you in your business procedures. With access to relevant real-time data, your business organization can thrive in the commercial real estate market. In…


Posted by Alvaro Dee on March 27, 2017 at 2:48am

Augment the Speed and Efficiency of Website Development with Joomla

Over the past few years, Joomla has emerged out as one of the greatest platforms for designing, developing, and deploying websites and web applications worldwide. Joomla scales up extremely well, uses less memory and gives a brilliant performance. Hire skilled and experienced Joomla developers to use Joomla CMS for developing simple and complex corporate websites. You can even enhance the functioning of your existing website by using this open source platform.

By outsourcing Joomla…


Posted by Alvaro Dee on March 20, 2017 at 4:00am

Top 10 Interview Questions & Answers for Java Developers

An organization hiring a Java developer is looking for someone who can code the applications flawlessly. For the period after Java training, the following is a very important list of ten Java interview questions. Make sure you tap the benefits of this comprehensive list of questions shared by our Java counterparts to crack your next interview.

1. What is immutable…


Posted by Michael Warne on March 17, 2017 at 3:00am

Get the Best Website for Your Business in a Set Time Frame

If you sell products online, you must be knowing how time-consuming and mundane it is to upload products. There are chances of you looking for someone to handle your product data entry tasks. A company that has a wealth of experience and is known for providing its customers with data entry services for a variety of eCommerce solutions can deal efficiently with high volumes of work without any hassle.…


Posted by Alvaro Dee on March 17, 2017 at 2:47am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service