#Export ORACLE_SID of container DATABASE, – my Container DB is “cdb01”.
[oracle@greporalab]$ export ORACLE_SID=cdb01
[oracle@greporalab]$ sqlplus / as sysdba
#Change to CONTAINER’s ROOT session.
SQL> alter session set container=CDB$ROOT;
#Create user and ADD Roles.
SQL> create user c##ggate identified by your_passowrd container=all SQL> grant connect to c##ggate container=all; SQL> grant dba to c##ggate container=all; SQL> grant unlimited tablespace to c##ggate container=all; SQL> grant create session to c##ggate container=all; SQL> grant alter session to c##ggate container=all; SQL> grant select any dictionary to c##ggate container=all; SQL> alter system set enable_goldengate_replication=true scope=both; SQL> alter database add supplemental log data; SQL> alter database force logging;
#Change to PLUGGABLE DB Session, my Pluggable db name is plugg01.
SQL> alter session set container=plugg01; SQL> create tablespace GOLDENGATE datafile '+DGDATA/' size 100M autoextend on; SQL> alter user c##ggate default tablespace GOLDENGATE;
#Create Integrated EXTRACT.
[oracle@greporalab]$ cd $GGATE_HOME
GGSCI (greporalab) 1> add extract E_INT01 INTEGRATED TRANLOG, BEGIN NOW
EXTRACT (Integrated) added.
GGSCI (greporalab) 1> edit param E_INT01
EXTRACT E_INT01 userid C##ggate password you_password CACHEMGR CACHESIZE 5GB exttrail ./dirdat/a1, FORMAT RELEASE 12.1 SOURCECATALOG plugg01 TABLE OWNER.TABLE_NAME; TABLE OWNER.TABLE_NAME_1; TABLE OWNER.TABLE_NAME_2;
GGSCI (greporalab) 1> dblogin userid C##ggate password your_password
Successfully logged into database CDB$ROOT.
GGSCI (greporalab as C##ggate@cdb01/CDB$ROOT)) 1> REGISTER EXTRACT E_INT01 DATABASE CONTAINER (plugg01)
2017-10-20 19:35:20 INFO OGG-02003 Extract E_INT01 successfully registered with database at SCN 7338138479501.
GGSCI (greporalab as C##ggate@cdb01/CDB$ROOT)) 1> add extract P_INT01 exttrailsource ./dirdat/a1
GGSCI (greporalab as C##ggate@cdb01/CDB$ROOT)) 1> edit param P_INT01
extract P_INT01 --connection to database-- userid C##ggate password your_password CACHEMGR CACHESIZE 1GB rmthost greporalab02, mgrport 9809 rmttrail ./dirdat/b1 -- Tabelas SOURCECATALOG plugg01 TABLE *.*;
GGSCI (greporalab as C##ggate@cdb01/CDB$ROOT)) 1> add rmttrail ./dirdat/b1 extract P_INT01
If you need help to configure Replicat Process, send a smoke signal.
Man with a Van | Man and Van | UK Movers | Removal Service | London Removals | Hire Van and truck | Flat Movers | Hire Van with a Van | London Movers
Whether you are moving or shipping furniture purchaing online, you have several options. When it comes to delivery or when you are looking van or truck with driver to delivery your furniture in UK. Just visitor web deliveryd2d.com or call us at our toll free number and get the get instant quotes.
Removal drivers can help you move anything you need to be transported, from dishes to furniture. It does not matter if you are moving your belongings in next streets over or miles away. No household job is too small or too big. When you hire a local professional on DeliveryD2D, you can be sure that your job will get done at best price that suits you.
Why waste time when you can find man with a van in your area at the best price you want.
Call us on our free phone number 0800 0 119 116
http://www.deliveryd2d.com (Delivery Door 2 Door)