Day2 Architecture Certification matrix download 081223
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=SNH9f-jesb8
Day 2 Recap • Recap of Oracle Goldengate Classic Architecture 19c Session 2: • ============================================================== • • A. Oracle Goldengate Architecture - How data flows in Goldengate? • All the processes in Goldengate work independently from each other however they depend on each other for reading the data. We call capture process as extract process as well. There are two types of extract processes. • 1- Classic Extract process • 2- Integrated Extract process • Classic extract is there since beginning . Capture process is external to database and it reads the data in sequential manner and capture only committed transaction. In integrated capture log minor build happens and logminer sends changes in the form of LCR to the Extract process. Performance of integrated capture is very high and much faster than classic capture. It creates less load on the database as well. • +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • B. • 1. The Goldengate training VM Has 19c Database and 21c OGG Binaries are present in /home/oracle/softwares • 2. For Goldengate binaries download, Before download and install Install , make a note of below • Source : DB Type , Version , Platform • Target : DB Type , Version , Platform • C. • 1. Before you proceed with download and installation , always Check the certification matrix • -Follow the instructions to download the GG from OTN • Check for system requirement and supported platform for oracle goldengate version we are installing use link : • https://www.oracle.com/middleware/tec... • -After copying the Software , invoke the runInstaller • 1. Before proceeding with installation u need to define location where to install. You may install GG in: • a. Seperate mount point: • b. Existing mount point • • c. To consider how much space u need for installation, Understand the requirement. Do Research and design • Hardware requirements: • 1. CPUs- 4 or 8 cores • 2. Space requirement/mount point size- Whether u want to add new mount point (/goldengate) or use exising mount point(/u01) • Space Calculation: • 30/60 days day wise archive log generation. • 20GB • 1 GB • 100 MB • 100 GB • Average of 7 days highest archive log generation -25 GB*7=175 GB *2=350-500 GB of space • 3. Which OS user to use to install Goldengate • (oracle or any other user ggadmin/gguser) • DBAs -oracle • Goldengate and DBA responsiblities are seggreagted then - gguser/ggadmin (oinstall group) • • Post-session assignment: • 1) complete lab setup for both VMs • 2) install OGG on ggate1 and ggate2
#############################
