Archive for

Oracle Streams – Section2

Oracle Streams – Section2 The basic capture process If the data is modified in the ORACLE database, it will be record into the redolog, so that when an error occurs, to have a way of correction. The Capture process as a background process oracle redolog has the ability to read, so it also has the … Continue reading

use ‘sed’ to list all content of a file after a specified word in Linux

In many cases, DBAs need to check the database log file. But if the database log contain million of rows how do we check the log by Date. Use ‘cat’ command will be very time consuming. Here is an example:

Oracle streams – Section1

Oracle Stream – Section1 Oracle Streams Overview Oracle Streams provides a way of sharing information, different from other data sharing mode, Streams even allows data transfer between different types of databases. Oracle Streams to achieve this by its replication process – capturing, transmission and applying. These three steps to transfer the specified information to the … Continue reading

Oracle Database Appliance (X5-2) Study (Virtualized Platform deployment) section 6

**This article is only for the purpose of demonstrating of my study of the Oracle Database appliance, not for any other purposes.** Create a guest vm in Oracle ODA Download the Oracle Linux vm template from Oracle Website, transfer the vm template to the Dom0 Import a vm template (From ODA_BASE) Create a shared repository … Continue reading

Configure Oracle Streams BI-Directional (11gR2)

Configure Oracle Streams BI-Directional (11gR2) Configure the Oracle database listeners and tnsnames.ora for both main database(source database) and target database Some database instance parameters need to be checked on main database(source database) Some database instance parameters need to be checked on target database In main database server(source database server) – testdb01.newzonetech.com, modify the $ORACLE_HOME/network/admin/listener.ora In … Continue reading