Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "installing oracle database and decompressing and installing glodengate software". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Install oracle database and configure remote desktop (abbreviated)

Both the source and destination environments are as follows:

(1) Database

(2) Monitoring

(3) TNSNAME file configuration

The contents of the tnsname.ora file, based on which many of the later configurations are based:

# # CDBYUNGG = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.56.180) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = yun)) # # PDBYUNGGXC = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.56.180) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xiaochong)) II. Decompress and install glodengate software

The following steps are performed by the oracle user

(1) create an installation directory:

(create source-side installation directory)

Mkdir-p / u01/app/oracle/product/ogg_src

(create the target installation directory)

Mkdir-p / u01/app/oracle/product/ogg_trg

(2) modify oracle user environment variables

Vim ~ / .bash_profile# adds the following (the paths of the source and destination are different, here we take the source as an example): export OGG_HOME=/u01/app/oracle/product/ogg_srcexport PATH=$OGG_HOME:$PATHexport LD_LIBRARY_PATH=$OGG_HOME:$LD_LIBRARY_PATH

To bring it into effect:

Source / .bash_profile

(3) decompress the installation package (root)

(4) graphical interface installation (source installation, the target can directly copy the installed file directory)

Copy the installation file directory to the target side so that the target side can avoid installation

[oracle@yun@oggp:ogg_src] scp-r * oracle@192.168.56.180:/u01/app/oracle/product/ogg_trg/

(5) testing

Log in to GGSCI

3. Prepare 1. Flow chart:

two。 Create a database user

This user is a glodengate administrative user and needs to be created under the CDB library in the 12C container database environment.

Create tablespace goldengate datafile size 8M autoextend on;create user c##goldengate identified by goldengate default tablespace goldengate;grant dba to cantilever goldengateX exec dbms_goldengate_auth.grant_admin_privilege ('clockwise goldengate.'

Test the connection:

Here's where it's easy to go wrong:

(1) to create a public user in a CDB environment, you need to start with clocked # or clocked #, and you cannot use the same user name in PDB after removing Category #.

(2) Empowerment needs to be performed in both CDB and PDB.

(3) if you need to specify a tablespace, you must create the same tablespace in CDB and all PDB. Otherwise, the following error will be reported.

ORA-65096,ORA-65048,ORA-00959

Warning: PDB altered with errors.

One thing I don't understand: delete the duplicate users in pdb, restart to create public users, and after rebooting the system, the public users in pdb become invalid.

As follows: C##OGG users, and the redefined user C##OGGP is not a problem

SQL > show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED- 2 PDB$SEED READ ONLY NO 3 XIAOCHONG READ WRITE NOSQL > select username,common,con_id from cdb_users where username like'% OGG%' USERNAME COMMON CON_IDC##OGG YES 1C##OGGP YES 1C##OGGP YES 3SQL > alter session set container=xiaochong;Session altered.SQL > select username,common,con_id from cdb_users where username like'% OGG%';USERNAME COMMON CON_IDC##OGGP YES 33. Modify the source database log mode and turn on additional logs

(1) modify:

Modify Archive (abbreviated)

SQL > alter database force logging

Database altered.

SQL > alter system set enable_goldengate_replication=true

System altered.

-enable additional logs

SQL > alter database add supplemental log data

Database altered.

(2) Enquiry

-- confirm to enable database-level additional logs

SQL > select supplemental_log_data_min from vicious database: SUPPLEMENTALLATION logo data acquisition MIQUAYEI

-- confirm that archiving has been started.

SQL > archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 52Next log sequence to archive 54Current log sequence 54 IV, configuration 1. Configure global parameters (both source side and destination side) GGSCI (oggp) 1 > edit param. / GLOBALS## add the following: GGSCHEMA C##GOLDENGATE2. Configure the Manager (1) source side:

(2) destination side (because it points to the copied file, it does not run by default and needs to be enabled)

two。 Configure local extract (1) configuration parameters

Connect to CDB, notice that test is the user, T1 is the table name, and ends with a good score.

(2) enable table-level additional logs

(3) add process

Container database must be in integrated mode (integrated)

(3) Register PDB

(4) add tail file

(5) start the process

(6) testing

After inserting the T table into a record

GGSCI (oggp as C##goldengate@yun/CDB$ROOT) 18 > stats ext exttestSending STATS request to EXTRACT EXTTEST... Start of Statistics at 2019-06-13 15:42:07.Output to. / dirdat/ex:Extracting from XIAOCHONG.TEST.T to XIAOCHONG.TEST.T:*** Total statistics since 2019-06-13 15:41:21 * * Total inserts 1.00Total updates 0.00Total deletes 0.00Total discards 0.00Total operations 1.00 Total inserts 1.00Total updates 0.00Total deletes * Daily statistics since 2019-06-13 15:41:21 0.00Total discards 0.00Total operations 1.00 Total inserts 1.00Total updates 0.00Total deletes 0.00Total discards * Hourly statistics since 2019-06-13 15:41:21 0.00Total operations 1.00 Latest statistics since 2019-06-13 15:41:21 * Total inserts 1.00Total updates 0.00Total deletes 0.00Total discards 0. 00Total operations 1.00End of Statistics.3. Configure data Pump (1) configuration parameters

(2) add process

(3) add trail file

(4) start the process

(5) Test GGSCI (oggp) 6 > stats ext dptestSending STATS request to EXTRACT DPTEST. Start of Statistics at 2019-06-13 16:01:46.Output to. / dirdat/dp:Extracting from XIAOCHONG.TEST.T to XIAOCHONG.TEST.T:*** Total statistics since 2019-06-13 15:57:31 * * Total inserts 1.00Total updates 0.00Total deletes 0.00Total discards 0.00Total operations 1.00 Daily statistics since 2019-06-13 15:57:31 * Total inserts 1.00Total updates 0.00Total deletes 0 .00 Total discards 0.00Total operations 1.00 Total inserts 1.00Total updates 0.00Total deletes 0.00Total discards * Hourly statistics since 2019-06-13 15:57:31 0.00Total operations 1.00 Total inserts 1.00Total updates 0.00Total deletes 0.00Total discards 0.00Total operations * Latest statistics since 2019-06-13 15:57:31 1.00End of Statistics.4. The destination side is configured with checkpoint table

5. Configure replicat (1) configuration parameters

(2) add process

(3) start the process

(4) Test GGSCI (oggs as c##goldengate@yun/XIAOCHONG) 51 > stats rep reptestSending STATS request to REPLICAT REPTEST... Start of Statistics at 2019-06-13 17:03:39.Replicating from XIAOCHONG.TEST.T to XIAOCHONG.TEST.T:*** Total statistics since 2019-06-13 17:03:35 * * Total inserts 2.00Total updates 0.00Total deletes 0.00Total discards 0.00Total operations 2.00 Total inserts 2.00Total updates 0.00Total deletes * Daily statistics since 2019-06-13 17:03:35 * * .00 Total discards 0.00Total operations 2.00 Total inserts 2.00Total updates 0.00Total deletes 0.00Total discards * Hourly statistics since 2019-06-13 17:03:35 0.00Total operations 2.00 Total inserts 2.00Total updates 0.00Total deletes 0.00Total discards 0.00Total operations * Latest statistics since 2019-06-13 17:03:35 2.00End of Statistics.

Final test: just test yourself.

This is the end of the "steps for installing oracle database and decompressing and installing glodengate software". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.