Welcome to Oracle DBA Tips and Techniques – a site by a DBA for all the DBA community. I have just migrated my site to a new host, so still experimenting with themes and appearances. Please provide your valuable feedback to gavsal@yahoo.com
|
||||||||||||||||||||
|
The GoldenGate Veridata Agents execute the database related requests to compare source and target database rows on behalf of the Veridata Server. At a minimum we need to install two agents – one to retrieve source rows and one to retrieve target rows from the database. There are two types of agents – one is the Java based agent and the other is the C-Agent. The Java Agent connects to the database using JDBC and permits data comparisons in heterogeneous environments. A Java environment JRE/JSDK is required to support this agent and a minimum java version is 1.5 We have copied the V19618-01.zip file from the Metalink E-Deilvery site and unzipped it as shown below. dba1:/u01/ofsad2> mkdir veriagent Continue reading Installing and Configuring GoldenGate Veridata Agent Oracle GoldenGate Veridata is a product that enables us to compare two sets of data and identify and report on data that is out of synchronization. This is helpful in a 24×7 replication enviornment where takimg downtime to compare sets of data is not an option and Veridata can run concurrently with the Extract and Replicat processes. Let us look at the different components of GoldenGate Veridata. Veridata Server – it coordinates the different Veridata tasks, performs data comparisons, sorting where required, reporting Repository – it makes use of an Oracle or MySQL database for storing data related to user preferences, configuration information, job runtime statistics etc. Veridata Agent – makes the required database calls on behalf of the Veridaata server to fetch and return rows required for comparions. Veridata Web – browser based interface to create comparison configurations and run jobs and view reports. B Note: Veridata also has a command line interface called vericom Continue reading Oracle GoldenGate Veridata Installation and Configuration This note illustrates how we can perform a rolling upgrade from Oracle 11g Release 1 to Oracle 11g Release 2 using a Transient Logical Standby database. This approach will miminise the downtime required for an upgrade which can potentially run into several hours down to just the time required to perform a switchover which could be a few minutes in most cases. A rolling upgrade using a Transient Logical Standby database at a very high level will involve three main stages or steps: 1) Temporarily convert a physical standby database to a logical standby database using the new KEEP IDENTITY clause The assumption here is that …. 1)We already have configured a Physical Standby Database using Data Guard best practices and both Primary Continue reading 11g Release 2 Rolling Upgrade using Transient Logical Standby database This note describes the commands used to create a Data Guard broker configuration using the command line dgmgrl interface. This can also be done via the Enterprise Manager Grid Control GUI as well and the assumption is that there is a Physical Standby database in place and redo transport and redo apply have already been configured and that both the Primary and Standby database are in sync. Primary Database: genoa1_js Standby Database: genoa1_fc On both Primary as well as Standby database start the Data Guard Broker process SQL> ALTER SYSTEM SET DG_BROKER_START=TRUE SCOPE=BOTH; System altered. Edit the listener.ora on both nodes to add a static entry for DGMGRL This is to prevent the ORA-12154 error which can be observed on startup of the standby database after performing a switchover. Ensure that the GLOBAL_DBNAME is set to db_unique_name_DGMGRL.db_domain SID_LIST_LISTENER = Continue reading 11g Data Guard Broker DGMGRL Configuration quick steps Purpose This note explains the procedure of creating a Physical Standby database using 11g RMAN DUPLICATE FROM ACTIVE DATABASE feature which is now available in 11g Release 1 onwards. This enables us to create a physical standby database without having to take a backup of the primary database as a prerequisite step. Environment Primary Database DB_UNIQUE_NAME: genoa1_js ORACLE_SID: genoa1 Primary hostname: oatu037 Oracle software version: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Enable Force Logging on the Primary database SQL> alter database force logging; Database altered. Download the note …. In Oracle 11g, we can now use external tables to not only display data stored in flat files outside the database, but also store the result of any command executed at the OS level – for example in this case we have a shell script which basically runs the ‘uptime’ command and we then run that command from the database by just querying the table – this can have a number of useful applications and something that developers need to be made aware of ….. [oracle@redhat64 oracle]$ cat get_uptime.sh #!/bin/ksh SQL> CREATE TABLE uptime Continue reading Oracle 11g External Tables to store results of OS commands To start the GoldenGate Director Server, we need to run the startWebLogic.sh script located in the “domain” sub-directory of the GoldenGate Director Server software installation directory. [oracle@redhat346 bin]$ cd /u01/oracle/gg-director [oracle@redhat346 gg-director]$ ls [oracle@redhat346 gg-director]$ cd domain [oracle@redhat346 domain]$ cd bin [oracle@redhat346 bin]$ ls [oracle@redhat346 domain]$ ./startWebLogic.sh. ………………………………… Note: we need to keep Continue reading Oracle GoldenGate – Using the Director Client GoldenGate Director is a multi tier client server application that enables the configuration and management of the GoldenGate environment from a remote client which includes a web browser based client. There are a number of different components which go to make up the GoldenGate Director product. Let us briefly describe each one of them. GoldenGate Director Server – It is installed in a Weblogic server domain and enables the management of the different instances of GoldenGate which run in our environment. GoldenGate Director Database – it is the central repository which is housed in a database (SQL Server/MySQL/Oracle) which contains information about the users, graphical diagrams which are created and other information related to user preferences. GoldenGate Director Client – it is a GUI tool for managing the GoldenGate instances and runs on any platform which supports Java providing a menu driven interface with standard drag and drop functionality. GoldenGate Director Web – web application Continue reading Oracle GoldenGate – Installing GoldenGate Director Server and Client GoldenGate Concepts and Architecture |
|
||||||||||||||||||
|
Copyright © 2012 Oracle DBA – Tips and Techniques - All Rights Reserved |
||||||||||||||||||||
Popular Posts