Install Deployment Goldengate

1. Upload the installation package

2. Unpack the installation package

3, check whether to open the archive (open archive)

Sourcedb -Sqlplus/  asSysdbasql*Plus:release11.2.0.4.0Production onMon APR - xx: -:Geneva  -Copyright (c)1982, -, Oracle. Allrights reserved. Connected to: OracleDatabase11g Enterprise Edition Release11.2.0.4.0 -64bitProduction withThe partitioning, OLAP, Data Mining and RealApplication Testing Optionssql>ArchiveLoglist;Database Logmode No Archive modeautomatic archival disabledarchive destination/U01/App/Oracle/Product/11.2.0/Db_1/Dbs/archoldest OnlineLogSequenceTen Current LogSequence ASQL> 

View Code

4. Open additional logs

SQL>Select from v$database; Suppleme--------NOSQL>

View Code

The result is no, indicating that no additional logs are open. Use the following command to open the database attach log:

SQL>alterdatabaseaddlog  data; Database altered.

View Code

Toggles the log for additional logs to take effect. If the archive log is not turned on, it needs to be turned on beforehand.

Sql> AlterSystem ArchiveLog  Current;AlterSystem ArchiveLog  Current*ERROR at line1: ORA-00258: Manual ArchivinginchNoarchivelog mode must identifyLogSQL> shutdownimmediate;Databaseclosed.Databasedismounted. ORACLE instance shut down. SQL>Startup Mount;oracle instance started. Total System Global Area1486495744bytesfixed Size2253384bytesvariable Size1358958008bytesDatabaseBuffers117440512Bytesredo Buffers7843840bytesDatabasemounted. SQL> Alter DatabaseArchivelog;Databasealtered. SQL> Alter Database Open;Databasealtered. SQL> 

View Code

SQL>alterlogcurrent; System altered.

View Code

5. Create a goldengate user

SQL>useruser is "SYS" SQL>createuser  bydefault  tablespace users; User created. SQL>Grant to goldengate; Grant succeeded. SQL>

View Code

6. Create Target Library goldengate users

C:\Users\DataCenter>Sqlplus/  asSysdbasql*Plus:release11.2.0.4.0Production onSunday April A  -: -:Ten  -Copyright (c)1982, -, Oracle. Allrights reserved. Connect to: OracleDatabase11g Enterprise Edition Release11.2.0.4.0 -64bitProduction withThe partitioning, OLAP, Data Mining and RealApplication Testing Optionssql> Create UserGoldengate identified byGoldengatedefaulttablespace users, user created. SQL> GrantDba toGoldengate; authorized success. SQL>

View Code

Install Deployment Goldengate