-bash-4.2$ mkdir stage

※stage配下にクライアント資格証明(ウォレット).zipを配置する
-bash-4.2$ cd stage
-bash-4.2$ ls -ltr
total 20
-rw-r--r--. 1 opc opc 20471 Mar 21 03:26 Wallet_TARGET1ADW.zip
-bash-4.2$ unzip ./Wallet_TARGET1ADW.zip -d ./client_credentials
Archive:  ./Wallet_TARGET1ADW.zip
  inflating: ./client_credentials/cwallet.sso  
  inflating: ./client_credentials/tnsnames.ora  
  inflating: ./client_credentials/readme.md  
  inflating: ./client_credentials/truststore.jks  
  inflating: ./client_credentials/ojdbc.properties  
  inflating: ./client_credentials/sqlnet.ora  
  inflating: ./client_credentials/ewallet.p12  
  inflating: ./client_credentials/keystore.jks
-bash-4.2$ cd client_credentials
-bash-4.2$ cp ./sqlnet.ora /u02/deployments/Target/etc
-bash-4.2$ cp ./tnsnames.ora /u02/deployments/Target/etc
-bash-4.2$ cd /u02/deployments/Target/etc
-bash-4.2$ vi sqlnet.ora
※?/network/adminを/home/opc/stage/client_credentialsに変更
-bash-4.2$ export ORACLE_HOME=/u01/app/client/oracle18
-bash-4.2$ export TNS_ADMIN=/u02/deployments/Target/etc
-bash-4.2$ cd $ORACLE_HOME/bin
-bash-4.2$ ./sqlplus Admin/各自が設定したパスワード@target1adw_low
SQL*Plus: Release 18.0.0.0.0 - Production on Sat Mar 21 05:03:06 2020 Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
SQL>

SQL> sho parameter enable_goldengate_replication

NAME                           TYPE     VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication   boolean  TRUE

SQL>alter user GGADMIN identified by *************** account unlock;
User GGADMIN altered.

SQL> select username, account_status from dba_users where username = 'GGADMIN';
USERNAME         ACCOUNT_STATUS
-------------------   --------------------------------
GGADMIN          OPEN

SQL> create user APPADMIN identified by ***************;
User created.

SQL> grant create session, resource, create view, create table to APPADMIN;
Grant succeeded.

SQL> alter user APPADMIN quota unlimited on data;
User altered.

SQL> exit
-bash-4.2$ ./sqlplus APPADMIN /***************@target1adw_low
SQL*Plus: Release 18.0.0.0.0 - Production on Sat Mar 28 02:14:30 2020 Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
Connected to:Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 – Production 
Version 18.4.0.0.0
SQL> create table emp
  2  (
  3  emp_id char(3) primary key,
  4  emp_name varchar2(10)
  5  )
  6  ;
Table created.

SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

-bash-4.2$ ./sqlplus Admin/各自が設定したパスワード@target1adw_low

SQL*Plus: Release 18.0.0.0.0 - Production on Sat Mar 21 05:03:06 2020 Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
SQL>
SQL> grant all on APPADMIN.emp to GGADMIN;

Grant succeeded.

SQL> alter user GGADMIN quota unlimited on data;
User altered.

SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

[opc@プロキシサーバのhostname 鍵ファイル置き場]$ ssh -i myrsa opc@ SRC1CDBサーバのPrivateIPアドレス

The authenticity of host ' SRC1CDBサーバのPrivateIPアドレス' can't be established.
Are you sure you want to continue connecting (yes/no)? yes
[opc@ SRC1CDBサーバのhostname ~]$

[opc@ SRC1CDBサーバのhostname ~]$　export ORACLE_HOME=/u01/app/oracle/product/18.0.0/dbhome_1

[opc@ SRC1CDBサーバのhostname ~]$　cd $ORACLE_HOME/bin
[opc@source1db bin]$ ./sqlplus /nolog
SQL*Plus: Release 18.0.0.0.0 - Production on Sun Mar 29 00:45:21 2020
Version 18.9.0.0.0
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
SQL> connect sys/***********@先ほど確認した簡易接続名
（例：******.*******.******.oraclevcn.com:1521/******.*******.******.oraclevcn.com as sysdba）
Connected.
SQL> create user C##GGADMIN identified by **************** container=all;
User created.
SQL> grant dba to C##GGADMIN container=all;
Grant succeeded.
SQL> alter user C##GGADMIN quota unlimited on users container=all;
User altered.
SQL> exec dbms_goldengate_auth.grant_admin_privilege(grantee=>'C##GGADMIN', container=>'ALL');
PL/SQL procedure successfully completed.
SQL> select log_mode from v$database;
LOG_MODE
------------
ARCHIVELOG    ←アーカイブログモードであるため、設定変更不要
SQL> alter database add supplemental log data;
Database altered.
SQL> select force_logging from v$database;
FORCE_LOGGING
---------------------------------------
YES
SQL> alter system set enable_goldengate_replication=true scope=both;
System altered.

SQL> exit
Disconnected from Oracle Database 18c Standard Edition 2 Release 18.0.0.0.0 - Production
Version 18.9.0.0.0

[opc@source1db bin]$ ./lsnrctl status

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 28-MAR-2020 23:51:50
Copyright (c) 1991, 2019, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 18.0.0.0.0 - Production
～中略～
Service "src1pdb.******.*******.oraclevcn.com" has 1 instance(s).
  Instance "SRC1CDB", status READY, has 1 handler(s) for this service...
The command completed successfully

[opc@source1db bin]$ ./sqlplus /nolog
SQL*Plus: Release 18.0.0.0.0 - Production on Sun Mar 29 00:45:21 2020　Version 18.9.0.0.0
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
SQL> connect sys/*******@source1db.******.******.oraclevcn.com:1521/上記PDB-Service名 as sysdba
Connected.

SQL> create user APPADMIN identified by ***** default tablespace users temporary tablespace temp;
User created.
SQL> grant create session, resource, create view, create table to APPADMIN;
Grant succeeded.
SQL> alter user APPADMIN quota 100M on users;
User altered.
SQL> exit
Disconnected from Oracle Database 18c Standard Edition 2 Release 18.0.0.0.0 – Production Version 18.9.0.0.0

[opc@source1db bin]$ ./sqlplus /nolog
SQL*Plus: Release 18.0.0.0.0 - Production on Sun Mar 29 01:31:46 2020 Version 18.9.0.0.0
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
SQL> connect APPADMIN/*******@source1db.******.******.oraclevcn.com:1521/上記PDB-Service名
Connected.

SQL> create table emp
  2  (
  3  emp_id char(3) primary key,
  4  emp_name varchar2(10)
  5  )
  6  ;
Table created.
SQL> exit
Disconnected from Oracle Database 18c Standard Edition 2 Release 18.0.0.0.0 – Production Version 18.9.0.0.0

-bash-4.2$ cd /u02/deployments/Source/etc

-bash-4.2$ vi tnsnames.ora
※前述の「長い形式」のデータベース接続文字列を貼り付ける
-bash-4.2$ cat tnsnames.ora 
SRC1CDB=(DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=XXX.XXX.XXX.XXX)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=********.******.*****.oraclevcn.com)))

SRC1PDB=(DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=XXX.XXX.XXX.XXX)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=src1pdb.******.*****.oraclevcn.com)))

-bash-4.2$ export ORACLE_HOME=/u01/app/client/oracle18
-bash-4.2$ export TNS_ADMIN=/u02/deployments/Source/etc
-bash-4.2$ cd $ORACLE_HOME/bin
-bash-4.2$ ./sqlplus system/*************@SRC1CDB
SQL*Plus: Release 18.0.0.0.0 - Production on Sat Mar 28 07:56:33 2020
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
Connected to:
Oracle Database 18c Standard Edition 2 Release 18.0.0.0.0 - Production
Version 18.9.0.0.0
SQL>