- Introduction:
- Databases should be installed & running in source & target.
- Connectivity between source & target servers.
- Free Disk space (approx. 15GB) for GoldenGate binary on both servers.
- Working TNS entry in tnsnames.ora file for database in both servers.
| Server | Source | Target |
|---|---|---|
| Hostname/IP | LAPTOP-JO563L1O.oraeasy.com | ogg21.oraeasy.com |
| OS | Windows 11 | OEL 8.5 |
| Database Version | 19.28 | 19.28 |
| Database Name | windb | lindb |
| GoldenGate Version | 21.3.0.0.1 | 21.3.0.0.1 |
| GoldenGate Home | D:\OGG | /u01/ogg/ogg_home |
Here we are using the database server as source & target for GoldenGate software as well. So the Prerequisites for installing the GoldenGate binary is same as for database.
\Win_21C_GG_V1017410-01_Microservice\fbo_ggs_Windows_x64_Oracle_services_shiphome\Disk1.
Then execute setup.exe
2. Then a GUI installation window will appear, follow the instruction.
Click Next.
Provide the OGG Home location and click Next.
Review the details and click Install.
Now monitor the progress.
Installation has been completed. Click Close.
3. Now navigate to D:\OGG\bin and excute oggca.bat file with Administartor privilege.
4. Now a GUI window will appear, follow the instruction.
Provide Service Manager Home directory, Hostname and Port for the Service Manager. Click Next.
Select Add New and click Next.
Provide Deployment name and Software Home directory.
Provide Deployment Home directory and click Next.
Provide OGG_HOME,PATH and TNS_ADMIN value. Click Next.
Provide GG Administrator username and its password. Click Next.
Uncheck SSL/TLS and click Next.
Provide the Port numbers and click Next.
Provide default schema and click Next.
Review the details and click Finish.
Run this batch file in Command Prompt with Administrative option to create GoldenGate Service at OS level.
Configuration has been completed. Click Close.
Verify the service at OS level.
5. Now open the URL and check login.
Provide username & password, then click Sign In.
Click on Adminstration Service.
6. Now we need to execute few commands to prepare the database for GoldenGate. So let's proceed for that.
SQL> def
DEFINE _DATE = "23-FEB-26" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "windb" (CHAR)
DEFINE _USER = "SYS" (CHAR)
DEFINE _PRIVILEGE = "AS SYSDBA" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1927000000" (CHAR)
DEFINE _EDITOR = "Notepad" (CHAR)
DEFINE _O_VERSION = "Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.27.0.0.0" (CHAR)
DEFINE _O_RELEASE = "1927000000" (CHAR)
SQL>
SQL> SELECT name,open_mode,database_role, log_mode,supplemental_log_data_min from v$database;
NAME OPEN_MODE DATABASE_ROLE LOG_MODE SUPPLEME
--------- -------------------- ---------------- ------------ --------
WINDB READ WRITE PRIMARY ARCHIVELOG NO
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
Database altered.
SQL> SELECT name,open_mode,database_role, log_mode,supplemental_log_data_min from v$database;
NAME OPEN_MODE DATABASE_ROLE LOG_MODE SUPPLEME
--------- -------------------- ---------------- ------------ --------
WINDB READ WRITE PRIMARY ARCHIVELOG YES
SQL> show parameter ENABLE_GOLDENGATE_REPLICATION
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean FALSE
SQL> ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION=TRUE SCOPE=BOTH;
System altered.
SQL> show parameter ENABLE_GOLDENGATE_REPLICATION
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean TRUE
SQL>
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
C:\APP\ORACLE\ORADATA\WINDB\SYSTEM01.DBF
C:\APP\ORACLE\ORADATA\WINDB\SYSAUX01.DBF
C:\APP\ORACLE\ORADATA\WINDB\UNDOTBS01.DBF
C:\APP\ORACLE\ORADATA\WINDB\USERS01.DBF
SQL> create tablespace OGG datafile 'C:\APP\ORACLE\ORADATA\WINDB\OGG01.dbf' size 1g autoextend on;
Tablespace created.
SQL> create user ggadmin identified by Ogg##123 default tablespace OGG temporary tablespace TEMP;
User created.
SQL> alter user ggadmin quota unlimited on ogg;
User altered.
SQL> grant alter system to ggadmin;
Grant succeeded.
SQL> grant create session to ggadmin;
Grant succeeded.
SQL> grant connect to ggadmin;
Grant succeeded.
SQL> grant resource to ggadmin;
Grant succeeded.
SQL> grant alter any table to ggadmin;
Grant succeeded.
SQL> grant select any dictionary to ggadmin;
Grant succeeded.
SQL> GRANT INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE TO ggadmin;
Grant succeeded.
SQL> exec dbms_goldengate_auth.grant_admin_privilege('GGADMIN');
PL/SQL procedure successfully completed.
SQL>
7. Now login to GoldenGate Console and make database connection.
In Adminstratation Service, click on Configuration.
In Database --> Crdential section, click on +.
Now provide the details like: Domain, Alias, User ID and Password. Last click Submit.
Click on Database icon to check login.
Now DB connection established successfully.
8. Now add trandata information.
In Trandata section, select Schema then click on +.
Provide Schema name.
Trandata has been successfully added.
Now similarly install the GoldenGate and prepare the target (Linux) database server for GoldenGate replication.
So we have completed the GoldenGate installation and database prepartion for replication. In the next article, we will see how to configure Extract & Replicat.
Thank you for reading!
I hope this content has been helpful to you. Your feedback and suggestions are always welcome — feel free to leave a comment or reach out with any queries.
Abhishek Shrivastava
Comments
Post a Comment