shareplex 8.6.6 实现不同数据库用户数据同步

[BEGIN] 2017/4/6 20:56:08
[root@node1 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.1.7 node1
192.168.1.8 node2
[root@node1 ~]#
[root@node1 ~]#
[root@node1 ~]#
[root@node1 ~]# uname -a
Linux node1 2.6.32-358.el6.x86_64 #1 SMP Tue Jan 29 11:47:41 EST 2013 x86_64 x86_64 x86_64 GNU/Linux
[root@node1 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.4 (Santiago)
[root@node1 ~]#
[root@node1 ~]#
[root@node1 ~]# uname -a
Linux node1 2.6.32-358.el6.x86_64 #1 SMP Tue Jan 29 11:47:41 EST 2013 x86_64 x86_64 x86_64 GNU/Linux
[root@node1 ~]#
[root@node1 ~]#
[root@node1 ~]# arch
x86_64
[root@node1 ~]#
[root@node1 ~]#
[root@node1 ~]#
[root@node1 ~]# id oracle
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1300(DBA),1301(oper)
[root@node1 ~]# su - oracle
[oracle@node1 ~]$ cat .bash_profile
# ---------------------------------------------------
# OS User:      oracle
# Application:  Oracle Database Software Owner
# Version:      Oracle 11g release 2
# ---------------------------------------------------

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
      . ~/.bashrc
fi

ORACLE_SID=orcl; export ORACLE_SID #another is dgh2
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
PATH=.{JAVA_HOME}/bin{PATH}HOME/binORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
PATH=${PATH}:/u01/app/common/oracle/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}ORACLE_HOME/network/jlib
export CLASSPATH
THREADS_FLAG=native; export THREADS_FLAG
export TEMP=/tmp
export TMPDIR=/tmp
# ---------------------------------------------------
# UMASK
# ---------------------------------------------------
# Set the default file mode creation mask
# (umask) to 022 to ensure that the user performing
# the Oracle software installation creates files
# with 644 permissions.
# ---------------------------------------------------
umask 022

[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 6 08:57:06 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> connect /as sysdba
Connected.
SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE        11.2.0.4.0        Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 6 08:57:26 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> connect /as sysdba
Connected.
SQL> archive log list;
Database log mode               Archive Mode
Automatic archival               Enabled
Archive destination               USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     4
Next log sequence to archive   6
Current log sequence               6
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ ssh node2
The authenticity of host 'node2 (192.168.1.8)' can't be established.
RSA key fingerprint is 28:5d:76:19:60:ac:26:ca:3e:84:83:5e:fe:7e:51:3d.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'node2,192.168.1.8' (RSA) to the list of known hosts.
oracle@node2's password:
[oracle@node2 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 6 08:57:50 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> connect /as sysdba
Connected.
SQL> archive log list;
Database log mode               No Archive Mode
Automatic archival               Disabled
Archive destination               USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     4
Current log sequence               6
SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE        11.2.0.4.0        Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$ exit
logout
Connection to node2 closed.
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ cat /etc/oratab
#



# This file is used by ORACLE utilities.  It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.

# A colon, ':', is used as the field terminator.  A new line terminates
# the entry.  Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
#   $ORACLE_SIDORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively.  The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
orcl:/u01/app/oracle/product/11.2.0/dbhome_1:N
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ ssh node2
oracle@node2's password:
Last login: Thu Apr  6 08:57:45 2017 from node1
[oracle@node2 ~]$ cat /etc/oratab
#



# This file is used by ORACLE utilities.  It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.

# A colon, ':', is used as the field terminator.  A new line terminates
# the entry.  Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
#   $ORACLE_SIDORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively.  The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
orcl:/u01/app/oracle/product/11.2.0/dbhome_1:N
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$ exit
logout
Connection to node2 closed.
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ ######### node1 prepare to install shareplex 8.6.6
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 6 08:59:19 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> show parameter recovery_parallelism
SP2-0640: Not connected
SQL> connect /as sysdba
Connected.
SQL> show parameter recovery_parallelism

NAME                                     TYPE         VALUE
------------------------------------ ----------- ------------------------------
recovery_parallelism                     integer         0
SQL>
SQL>
SQL> alter database add supplemental log data(primary key,unique index) columns;

Database altered.

SQL>
SQL>
SQL>
SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ ###################install shareplex 8.6.6 on node1
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ cd
[oracle@node1 ~]$ ls -l
total 104280
-r-xr-xr-x. 1 root root 106782720 Apr  6 08:41 shareplex-8.6.6-b64-oracle110-rh-40-amd64-m64.tar
[oracle@node1 ~]$ tnsping orcl

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 06-APR-2017 09:00:58

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (0 msec)
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ tar -xvf shareplex-8.6.6-b64-oracle110-rh-40-amd64-m64.tar
SharePlex-8.6.6-b64-oracle110-rh-40-amd64-m64.tpm
[oracle@node1 ~]$ ls -l
total 208560
-r-xr-xr-x. 1 root   root     106782720 Apr  6 08:41 shareplex-8.6.6-b64-oracle110-rh-40-amd64-m64.tar
-rwxr-xr-x. 1 oracle oinstall 106779251 Jan 13 12:30 SharePlex-8.6.6-b64-oracle110-rh-40-amd64-m64.tpm
[oracle@node1 ~]$ ./SharePlex-8.6.6-b64-oracle110-rh-40-amd64-m64.tpm
Unpacking ..................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ...............................................................

SharePlex installation program:
    SharePlex Version: 8.6.6
    Build platform: rh-40-amd64
    Target platform: rh-40-amd64

Please enter the product directory location? /u01/app/proddir
Please enter the variable data directory location? /u01/app/vardir2100
Please specify the SharePlex Admin group (select a number):
1. [oinstall]
2. dba
3. oper
?  1
Please wait while the installer obtains Oracle information ..
Please enter the ORACLE_SID that corresponds to this installation? [orcl]
Please enter the ORACLE_HOME directory that corresponds to this ORACLE_SID? [/u01/app/oracle/product/11.2.0/dbhome_1]
Please enter the TCP/IP port number for SharePlex communications? [2100]

Preparing to install SharePlex for Oracle v.8.6.6:
    User:                     oracle
    Admin Group:              oinstall
    Product Directory:        /u01/app/proddir
    Variable Data Directory:  /u01/app/vardir2100
    ORACLE_SID:               orcl
    ORACLE_HOME:              /u01/app/oracle/product/11.2.0/dbhome_1

Proceed with installation? [yes]
Installing ................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  ..........................................
Setting file ownerships ...................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .......................................................
Setting file permissions ..................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  ........................................................
Do you have a valid SharePlex v. 8.6.6 license? [yes]
Please enter the License key? XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Please enter the customer name associated with this license key? XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

SharePlex v. 8.6.6 license validation successful:
    Customer Name:      XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
    License Key:        XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
    Product Name:       SharePlex for Oracle - RAC
    License Key Type:   "erpetual Key"

NOTE: You can upgrade this license key or add license keys for additional machines
      by executing utility /u01/app/proddir/install/splex_add_key.

Installation log saved to: /home/oracle/.shareplex/INSTALL-SharePlex-8.6.6-1704060901.log
SharePlex for Oracle v.8.6.6 installation successful.
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ cd /u01/app/proddir/bin
[oracle@node1 bin]$ ls -l
total 4
lrwxrwxrwx. 1 oracle oinstall   27 Apr  6 09:02 cleanup.sql -> ../.app-modules/cleanup.sql
lrwxrwxrwx. 1 oracle oinstall   31 Apr  6 09:02 clean_vardir.sh -> ../.app-modules/clean_vardir.sh
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 config_parser -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 dumpfile -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 dumpque -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 hana_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 hana_setup -> ../.app-modules/launcher
drwxrwxr-x. 2 oracle oinstall 4096 Apr  6 09:02 hooks
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 ora_chpwd -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 ora_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 ora_setup -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 pb_ctrl -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 pg_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 pg_setup -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 qview -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 socket_test -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 sp_cop -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 sp_ctrl -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 sp_declt -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 sp_desvr -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 sp_sync_clt -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 sp_sync_launcher -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 sp_sync_svr -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 sp_wallet -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 td_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:02 td_setup -> ../.app-modules/launcher
-rw-rw-r--. 1 oracle oinstall    0 Apr  6 09:02 vardirs.log
[oracle@node1 bin]$ cd
[oracle@node1 ~]$ vi .bash_profile
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ grap proddir .bash_profile
-bash: grap: command not found
[oracle@node1 ~]$ grep proddir .bash_profile
PATH=${PATH}:/u01/app/proddir/bin:/u01/app/common/oracle/bin
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ sp_cop &
[1] 6507
[oracle@node1 ~]$ -bash: sp_cop: command not found

[1]+  Exit 127                sp_cop
[oracle@node1 ~]$ which sp_cop
/usr/bin/which: no sp_cop in (.:/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin:/u01/app/oracle/product/11.2.0/dbhome_1/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/app/common/oracle/bin)
[oracle@node1 ~]$ source .bash_profile
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ sp_cop &
[1] 6519
[oracle@node1 ~]$

*******************************************************
* SharePlex for Oracle Startup
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
* Version: 8.6.6.64-m64-oracle110
* VarDir : /u01/app/vardir2100
* Port   : 2100
*******************************************************

[oracle@node1 ~]$ ps -ef | grep sp_cop
oracle    6519  3117  1 09:06 pts/1    00:00:00 /u01/app/proddir/.app-modules/sp_cop
oracle    6523  3117  0 09:07 pts/1    00:00:00 grep sp_cop
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ sp_ctrl


*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************

sp_ctrl (node1:2100)> status

Brief Status for node1
Process          State                             PID     Running   Since     
---------------  ------------------------------  --------  --------------------
Cop              Running                             6519  06-Apr-17 09:07:00  
Cmd & Ctrl       Running                             6526  06-Apr-17 09:07:21  
There are no active configuration files

sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> exit
[oracle@node1 ~]$ ################ execute ora_setup on node1 to setup shareplex
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ ora_setup


Welcome to the Oracle SharePlex setup process for port 2100.
This process creates tables and user accounts needed to run
Oracle SharePlex replication.

Will the SharePlex install be using a BEQUEATH connection? (Entering 'n' implies a SQL*net connection)  [y] :
Please note the following:
** In response to prompts, a carriage return will choose the default
   given in brackets.  If there is no default, a reply must be entered.

** To exit the program while the program is waiting for input, use the
   CTRL-C key sequence.
   This sequences can be entered by holding down the CONTROL key and
   pressing the C key.


Enter the Oracle SID for which SharePlex should be installed [orcl] :

In order to create the SharePlex tables and user account, we must
connect to the database as a DBA user

Enter a DBA user for orcl  : system

Enter password for the DBA account, which will not echo :

connecting--This may take a few seconds.

validating user name and password. . . This may take a few seconds.
SharePlex objects will need to be created under a special
account.  You can pick an existing user or create a new one.
Would you like to create a new SharePlex user ? [y] :  
Enter username for new user [splex/splex] :

Warning:  This user is now being granted unlimited tablespace.
This privilege will remain in effect until it is explicitly changed.
Granting select on sys.user$ to splex

Do you want to enable replication of tables with TDE? [n] :

To enable replication of tables with TDE in the future, please rerun ora_setup.

Setup will now install SharePlex objects.

These are the existing tablespaces.

SYSTEM SYSAUX UNDOTBS1 TEMP USERS EXAMPLE

Enter the default tablespace for use by SharePlex [USERS] :

Enter the temporary tablespace for use by SharePlex [TEMP] :
Enter the index tablespace for use by SharePlex [ ] : USERS

Creating SharePlex objects [Installation type: Fresh]. . .

Creating SharePlex Oracle-timezone-region map . . . Done.

Creating Conflict Resolution Package . . . Done.

Creating SharePlex Dataequator package . . .

Loading Compare Package from "/u01/app/proddir/util/sp_deq_pkg.plb"...Done.

Loading Compare Varray Package from "/u01/app/proddir/util/sp_deq_v_pkg.plb"...Done.

Will the current setup for sid: [orcl] be used as source (including cases as source for failover or master-master setups)?  [y] :

Setup of SharePlex objects successful . . .

Changing SharePlex connection database . . .

Setup completed successfully

[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ sp_ctrl


*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************

sp_ctrl (node1:2100)> status

Brief Status for node1
Process          State                             PID     Running   Since     
---------------  ------------------------------  --------  --------------------
Cop              Running                             6519  06-Apr-17 09:07:00  
Cmd & Ctrl       Running                             6545  06-Apr-17 09:09:02  
There are no active configuration files

sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> exit
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ ###############prepare to install shareplex on node2
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ ssh node2
oracle@node2's password:
Last login: Thu Apr  6 08:58:39 2017 from node1
[oracle@node2 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 6 09:10:09 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> connect /as sysdba
Connected.
SQL> show parameter recovery_parallelism

NAME                                     TYPE         VALUE
------------------------------------ ----------- ------------------------------
recovery_parallelism                     integer         0
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node2 ~]$ ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 30447
max locked memory       (kbytes, -l) 64
max memory size         (kbytes, -m) unlimited
open files                      (-n) 1024
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 10240
cpu time               (seconds, -t) unlimited
max user processes              (-u) 2047
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$ ls -l
total 104280
-r-xr-xr-x. 1 root root 106782720 Apr  6 08:42 shareplex-8.6.6-b64-oracle110-rh-40-amd64-m64.tar
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$ #########################  install shareplex 8.6.6 on node2
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$ pwd
/home/oracle
[oracle@node2 ~]$ ls
shareplex-8.6.6-b64-oracle110-rh-40-amd64-m64.tar
[oracle@node2 ~]$ tar -xvf shareplex-8.6.6-b64-oracle110-rh-40-amd64-m64.tar
SharePlex-8.6.6-b64-oracle110-rh-40-amd64-m64.tpm
[oracle@node2 ~]$ ./SharePlex-8.6.6-b64-oracle110-rh-40-amd64-m64.tpm
Unpacking ..................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ..........................................................................
  ...............................................................

SharePlex installation program:
    SharePlex Version: 8.6.6
    Build platform: rh-40-amd64
    Target platform: rh-40-amd64

Please enter the product directory location? /u01/app/proddir
Please enter the variable data directory location? /u01/app/vardir2100
Please specify the SharePlex Admin group (select a number):
1. [oinstall]
2. dba
3. oper
?  
Please wait while the installer obtains Oracle information ..
Please enter the ORACLE_SID that corresponds to this installation? [orcl]
Please enter the ORACLE_HOME directory that corresponds to this ORACLE_SID? [/u01/app/oracle/product/11.2.0/dbhome_1]
Please enter the TCP/IP port number for SharePlex communications? [2100]

Preparing to install SharePlex for Oracle v.8.6.6:
    User:                     oracle
    Admin Group:              oinstall
    Product Directory:        /u01/app/proddir
    Variable Data Directory:  /u01/app/vardir2100
    ORACLE_SID:               orcl
    ORACLE_HOME:              /u01/app/oracle/product/11.2.0/dbhome_1

Proceed with installation? [yes]
Installing ................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  ..........................................
Setting file ownerships ...................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .......................................................
Setting file permissions ..................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  .........................................................................
  ........................................................
Do you have a valid SharePlex v. 8.6.6 license? [yes]
Please enter the License key? CN0DW1WAVEJG3NCMC4647K0YMEB0SXBJYW
Please enter the customer name associated with this license key? XINJIANG ELECTRIC POWER CORP

SharePlex v. 8.6.6 license validation successful:
    Customer Name:      XXXXXXXXXXXXXXXXXXXXXXXXXXXX
    License Key:        XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
    Product Name:       SharePlex for Oracle - RAC
    License Key Type:   "erpetual Key"

NOTE: You can upgrade this license key or add license keys for additional machines
      by executing utility /u01/app/proddir/install/splex_add_key.

Installation log saved to: /home/oracle/.shareplex/INSTALL-SharePlex-8.6.6-1704060911.log
SharePlex for Oracle v.8.6.6 installation successful.
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$ cd /u01/app/proddir/bin
[oracle@node2 bin]$ pwd
/u01/app/proddir/bin
[oracle@node2 bin]$ ls -l
total 4
lrwxrwxrwx. 1 oracle oinstall   27 Apr  6 09:12 cleanup.sql -> ../.app-modules/cleanup.sql
lrwxrwxrwx. 1 oracle oinstall   31 Apr  6 09:12 clean_vardir.sh -> ../.app-modules/clean_vardir.sh
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 config_parser -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 dumpfile -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 dumpque -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 hana_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 hana_setup -> ../.app-modules/launcher
drwxrwxr-x. 2 oracle oinstall 4096 Apr  6 09:12 hooks
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 ora_chpwd -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 ora_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 ora_setup -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 pb_ctrl -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 pg_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 pg_setup -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 qview -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 socket_test -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 sp_cop -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 sp_ctrl -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 sp_declt -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 sp_desvr -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 sp_sync_clt -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 sp_sync_launcher -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 sp_sync_svr -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 sp_wallet -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 td_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall   24 Apr  6 09:12 td_setup -> ../.app-modules/launcher
-rw-rw-r--. 1 oracle oinstall    0 Apr  6 09:12 vardirs.log
[oracle@node2 bin]$ cd
[oracle@node2 ~]$ vi .bash_profile
[oracle@node2 ~]$ source .bash_profile
[oracle@node2 ~]$ cat .bash_profile
# ---------------------------------------------------
# OS User:      oracle
# Application:  Oracle Database Software Owner
# Version:      Oracle 11g release 2
# ---------------------------------------------------

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
      . ~/.bashrc
fi

ORACLE_SID=orcl; export ORACLE_SID #another is dgh2
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
PATH=${PATH}:/u01/app/proddir/bin:/u01/app/common/oracle/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export CLASSPATH
THREADS_FLAG=native; export THREADS_FLAG
export TEMP=/tmp
export TMPDIR=/tmp
# ---------------------------------------------------
# UMASK
# ---------------------------------------------------
# Set the default file mode creation mask
# (umask) to 022 to ensure that the user performing
# the Oracle software installation creates files
# with 644 permissions.
# ---------------------------------------------------
umask 022

[oracle@node2 ~]$ sp_cop &
[1] 10607
[oracle@node2 ~]$

*******************************************************
* SharePlex for Oracle Startup
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
* Version: 8.6.6.64-m64-oracle110
* VarDir : /u01/app/vardir2100
* Port   : 2100
*******************************************************

[oracle@node2 ~]$
[oracle@node2 ~]$ sp_ctrl


*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************

sp_ctrl (node2:2100)> status

Brief Status for node2
Process          State                             PID     Running   Since     
---------------  ------------------------------  --------  --------------------
Cop              Running                            10607  06-Apr-17 09:14:35  
Cmd & Ctrl       Running                            10609  06-Apr-17 09:14:40  
There are no active configuration files

sp_ctrl (node2:2100)> exit
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$ ###########execute ora_setup command to setup shareplex
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$ ora_setup


Welcome to the Oracle SharePlex setup process for port 2100.
This process creates tables and user accounts needed to run
Oracle SharePlex replication.

Will the SharePlex install be using a BEQUEATH connection? (Entering 'n' implies a SQL*net connection)  [y] :
Please note the following:
** In response to prompts, a carriage return will choose the default
   given in brackets.  If there is no default, a reply must be entered.

** To exit the program while the program is waiting for input, use the
   CTRL-C key sequence.
   This sequences can be entered by holding down the CONTROL key and
   pressing the C key.


Enter the Oracle SID for which SharePlex should be installed [orcl] :

In order to create the SharePlex tables and user account, we must
connect to the database as a DBA user

Enter a DBA user for orcl  : system

Enter password for the DBA account, which will not echo :

connecting--This may take a few seconds.

validating user name and password. . . This may take a few seconds.
SharePlex objects will need to be created under a special
account.  You can pick an existing user or create a new one.
Would you like to create a new SharePlex user ? [y] :
Enter username for new user [splex/splex] :

Warning:  This user is now being granted unlimited tablespace.
This privilege will remain in effect until it is explicitly changed.
Granting select on sys.user$ to splex

Do you want to enable replication of tables with TDE? [n] :

To enable replication of tables with TDE in the future, please rerun ora_setup.

Setup will now install SharePlex objects.

These are the existing tablespaces.

SYSTEM SYSAUX UNDOTBS1 TEMP USERS EXAMPLE

Enter the default tablespace for use by SharePlex [USERS] :

Enter the temporary tablespace for use by SharePlex [TEMP] :
Enter the index tablespace for use by SharePlex [ ] : USERS

Creating SharePlex objects [Installation type: Fresh]. . .

Creating SharePlex Oracle-timezone-region map . . . Done.

Creating Conflict Resolution Package . . . Done.

Creating SharePlex Dataequator package . . .

Loading Compare Package from "/u01/app/proddir/util/sp_deq_pkg.plb"...Done.

Loading Compare Varray Package from "/u01/app/proddir/util/sp_deq_v_pkg.plb"...Done.

Will the current setup for sid: [orcl] be used as source (including cases as source for failover or master-master setups)?  [y] : n

Setup of SharePlex objects successful . . .

Changing SharePlex connection database . . .

Setup completed successfully

[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$ #######  node2 finished the shareplex 8.6.6 install and setup
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$ exit
logout
Connection to node2 closed.
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ ##########create test user source on host node1
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 6 09:17:15 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> connect /as sysdba
Connected.
SQL> create user source identified by source account unlock;

User created.

SQL> grant connect,resoruce to source;
grant connect,resoruce to source
              *
ERROR at line 1:
ORA-01919: role 'RESORUCE' does not exist


SQL> grant connect,resource to source;

Grant succeeded.

SQL> connect source/source
Connected.
SQL> create table (id int primary key,name varchar2(20));
create table (id int primary key,name varchar2(20))
             *
ERROR at line 1:
ORA-00903: invalid table name


SQL> create table t1 (id int primary key,name varchar2(20));

Table created.

SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node1 ~]$ #####create test user targer on host node2
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ ssh node2
oracle@node2's password:
Last login: Thu Apr  6 09:10:05 2017 from node1
[oracle@node2 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 6 09:19:29 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> connect /as sysdba
Connected.
SQL> create user target identified by target account unlock;

User created.

SQL> grant connect,resourct to target;
grant connect,resourct to target
              *
ERROR at line 1:
ORA-01919: role 'RESOURCT' does not exist


SQL> grant connect,resource to target;

Grant succeeded.

SQL> connect target/target
Connected.
SQL> create table t1 (id int primary key,name varchar2(20));

Table created.

SQL> desc t1;
Name                                           Null?    Type
----------------------------------------- -------- ----------------------------
ID                                           NOT NULL NUMBER(38)
NAME                                                    VARCHAR2(20)

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$ exit
logout
Connection to node2 closed.
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ ########## set config file for shareplex 8.6.6 on node1
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ sp_ctrl


*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************

sp_ctrl (node1:2100)> list config

File   Name                                         State       Datasource     
--------------------------------------------------  ----------  ---------------
ORA_config                                          Inactive    o.SOURCE_SID   
Last Modified At: 06-Apr-17 09:02    Size: 151   

sp_ctrl (node1:2100)> cp ORA_config to test_config
   Unknown command 'cp'
sp_ctrl (node1:2100)> copy ORA_config to test_config

   No active configuration exists
   A source SID must be specified


sp_ctrl (node1:2100)> list config

File   Name                                         State       Datasource     
--------------------------------------------------  ----------  ---------------
ORA_config                                          Inactive    o.SOURCE_SID   
Last Modified At: 06-Apr-17 09:02    Size: 151   

sp_ctrl (node1:2100)> copy config ORA_config to test_config
sp_ctrl (node1:2100)> list config

File   Name                                         State       Datasource     
--------------------------------------------------  ----------  ---------------
ORA_config                                          Inactive    o.SOURCE_SID   
Last Modified At: 06-Apr-17 09:02    Size: 151   

test_config                                         Inactive    o.SOURCE_SID   
Last Modified At: 06-Apr-17 09:22    Size: 151   

sp_ctrl (node1:2100)> edit config test_config
sp_ctrl (node1:2100)> view config test_config

#datasource.SOURCE_SID

#source tables      target tables           routing map

#splex.demo_src      splex.demo_dest             target_system@o.target_sid


datasource.orcl

source.t1           target.t1                   node2@o.orcl

sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> list config

File   Name                                         State       Datasource     
--------------------------------------------------  ----------  ---------------
ORA_config                                          Inactive    o.SOURCE_SID   
Last Modified At: 06-Apr-17 09:02    Size: 151   

test_config                                         Inactive    o.orcl         
Last Modified At: 06-Apr-17 09:24    Size: 234   

sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> activate config test_config

sp_ctrl (node1:2100)> list config

File   Name                                         State       Datasource     
--------------------------------------------------  ----------  ---------------
ORA_config                                          Inactive    o.SOURCE_SID   
Last Modified At: 06-Apr-17 09:02    Size: 151   

test_config                                         Active      o.orcl         
Last Modified At: 06-Apr-17 09:24    Size: 234     Internal Name: .conf.1            

sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> show

Process    Source                               Target                 State                   PID
---------- ------------------------------------ ---------------------- -------------------- ------
Capture    o.orcl                                                      Running                8818
Read       o.orcl                                                      Running                8823
Export     node1                                node2                  Idle                    

sp_ctrl (node1:2100)> status

Brief Status for node1
Process          State                             PID     Running   Since     
---------------  ------------------------------  --------  --------------------
Cop              Running                             6519  06-Apr-17 09:07:00  
Cmd & Ctrl       Running                             6645  06-Apr-17 09:20:51  
Capture          Running                             8818  06-Apr-17 09:24:51  
Read             Running                             8823  06-Apr-17 09:24:51  
Export           Idle                          

System is used as a source machine
There is 1 active configuration file

sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> exit
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ ########  view processes status on node2
[oracle@node1 ~]$
[oracle@node1 ~]$ ssh node2
oracle@node2's password:
Last login: Thu Apr  6 09:19:26 2017 from node1
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$ sp_ctrl


*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************


发现目标端import,post进程未启动


sp_ctrl (node2:2100)>
sp_ctrl (node2:2100)>
sp_ctrl (node2:2100)> status

Brief Status for node2
Process          State                             PID     Running   Since     
---------------  ------------------------------  --------  --------------------
Cop              Running                            10607  06-Apr-17 09:14:35  
Cmd & Ctrl       Running                            10729  06-Apr-17 09:25:54  
There are no active configuration files


[oracle@node2 ~]$ sp_ctrl


*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************

sp_ctrl (node2:2100)> status

Brief Status for node2
Process          State                             PID     Running   Since     
---------------  ------------------------------  --------  --------------------
Cop              Running                            10607  06-Apr-17 09:14:35  
Cmd & Ctrl       Running                            10770  06-Apr-17 09:31:26  
There are no active configuration files

sp_ctrl (node2:2100)> exit


[root@node2 ~]$ service iptables status 发现node2主机防火墙未关闭


node2 主机上关闭防火墙

[oracle@node2 ~]$ sp_ctrl


*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************

sp_ctrl (node2:2100)> status

Brief Status for node2
Process          State                             PID     Running   Since     
---------------  ------------------------------  --------  --------------------
Cop              Running                            10607  06-Apr-17 09:14:35  
Cmd & Ctrl       Running                            10886  06-Apr-17 09:32:29  
There are no active configuration files



关闭node1上的相关进程capture,read,export,sp_cop 进程,重新启动
[oracle@node1 ~]$ sp_ctrl


*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************

sp_ctrl (node1:2100)> status

Brief Status for node1
Process          State                             PID     Running   Since     
---------------  ------------------------------  --------  --------------------
Cop              Running                             6519  06-Apr-17 09:07:00  
Capture          Running                             8818  06-Apr-17 09:24:51  
Read             Running                             8823  06-Apr-17 09:24:51  
Export           Idle                          
Cmd & Ctrl       Running                             8972  06-Apr-17 09:33:41  

System is used as a source machine
There is 1 active configuration file

sp_ctrl (node1:2100)> stop capture
sp_ctrl (node1:2100)> stop read
sp_ctrl (node1:2100)> stop export
sp_ctrl (node1:2100)> shutdown
[oracle@node1 ~]$ ps -ef | grep sp_cop
oracle    8980  3117  0 09:34 pts/1    00:00:00 grep sp_cop
[1]+  Done                    sp_cop
[oracle@node1 ~]$ sp_cop &
[1] 8981
[oracle@node1 ~]$

*******************************************************
* SharePlex for Oracle Startup
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
* Version: 8.6.6.64-m64-oracle110
* VarDir : /u01/app/vardir2100
* Port   : 2100
*******************************************************

[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ sp_ctrl


*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************

sp_ctrl (node1:2100)> status

Brief Status for node1
Process          State                             PID     Running   Since     
---------------  ------------------------------  --------  --------------------
Cop              Running                             8981  06-Apr-17 09:34:22  
Capture          Stopped by user               
Read             Stopped by user               
Export           Stopped by user               
Cmd & Ctrl       Running                             8983  06-Apr-17 09:34:33  

System is used as a source machine
There is 1 active configuration file

sp_ctrl (node1:2100)> start capture
sp_ctrl (node1:2100)> start read
sp_ctrl (node1:2100)> start export
sp_ctrl (node1:2100)> status

Brief Status for node1
Process          State                             PID     Running   Since     
---------------  ------------------------------  --------  --------------------
Cop              Running                             8981  06-Apr-17 09:34:22  
Capture          Running                             8985  06-Apr-17 09:34:41  
Read             Running                             8992  06-Apr-17 09:34:43  
Export           Running                             9004  06-Apr-17 09:34:48  
Cmd & Ctrl       Running                             8983  06-Apr-17 09:34:33  

System is used as a source machine
There is 1 active configuration file




sp_ctrl (node1:2100)> exit

再次确认node2 import,post进程是否启动成功


[oracle@node1 ~]$ ssh node2
oracle@node2's password:
Last login: Thu Apr  6 09:25:45 2017 from node1
[oracle@node2 ~]$ sp_ctrl


*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************

sp_ctrl (node2:2100)> status

Brief Status for node2
Process          State                             PID     Running   Since     
---------------  ------------------------------  --------  --------------------
Cop              Running                            10893  06-Apr-17 09:33:16  
Import           Running                            10903  06-Apr-17 09:34:48  
Post             Running                            10904  06-Apr-17 09:34:49  
Cmd & Ctrl       Running                            10944  06-Apr-17 09:35:12  
Cmd & Ctrl       Running                            10971  06-Apr-17 09:35:29  
There are no active configuration files

sp_ctrl (node2:2100)>
sp_ctrl (node2:2100)>
sp_ctrl (node2:2100)>
sp_ctrl (node2:2100)>
sp_ctrl (node2:2100)> show sql
Last SQL statement of queue node1 and instance o.orcl-o.orcl on node2

   Thread    Session
   ------    -------
        0          0
/
   Thread is initializing : No SQL available yet.




sp_ctrl (node2:2100)> exit
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$ ############ do some dml on t1 of source user
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$ sqlplus source/source

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 6 09:36:31 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: sqlplus source
SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
      <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@node2 ~]$ sqlplus source/source

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 6 09:36:41 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@node2 ~]$ exit
logout
Connection to node2 closed.
[oracle@node1 ~]$ sqlplus source/source

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 6 09:37:13 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> desc t1;
Name                                           Null?    Type
----------------------------------------- -------- ----------------------------
ID                                           NOT NULL NUMBER(38)
NAME                                                    VARCHAR2(20)

SQL> begin
  2  for i in 1 .. 10000
  3  loop
  4  insert into t1 values (i,to_char(i));
  5  commit;
  6  end loop;
  7  end;
  8  /

PL/SQL procedure successfully completed.

SQL> select count(*) from t1;

  COUNT(*)
----------
     10000

SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node1 ~]$ sp_ctrl


*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************

sp_ctrl (node1:2100)> status

Brief Status for node1
Process          State                             PID     Running   Since     
---------------  ------------------------------  --------  --------------------
Cop              Running                             8981  06-Apr-17 09:34:22  
Capture          Running                             8985  06-Apr-17 09:34:41  
Read             Running                             8992  06-Apr-17 09:34:43  
Export           Running                             9004  06-Apr-17 09:34:48  
Cmd & Ctrl       Running                             9059  06-Apr-17 09:38:11  

System is used as a source machine
There is 1 active configuration file

sp_ctrl (node1:2100)> show sql
   No process found for poster service.
   Or invalid data source-data destination

sp_ctrl (node1:2100)> show capture detail

Host: node1     System time: 06-Apr-17 09:38:32

                           Operations
Source     Status            Captured Since
---------- --------------- ---------- ------------------
o.orcl     Running              20000 06-Apr-17 09:34:41

   Oracle current redo log          : 9
   Capture current redo log         : 9
   Capture log offset               : 14938196
   Last redo record processed:      
        Operation on SHAREPLEX internal table at 04/06/17 09:38:30

   Capture state                    : Processing
   Activation id                    : 1
   Error count                      : 0
   Operations captured              : 20000
   Transactions captured            : 10000

   Concurrent sessions              : 0
   HWM concurrent sessions          : 2
   Checkpoints performed            : 1
   Total operations processed       : 20299
   Total transactions completed     : 10299
   Total Kbytes read                : 0

   Redo records in progress         : 0
   Redo records processed           : 31443
   Redo records ignored             : 11144
   Redo records - last HRID         : AAAVpXAAEAAAAJcAA1

sp_ctrl (node1:2100)> show read detail

Host: node1
                           Operations
Source     Status           Forwarded Since              Total      Backlog
---------- --------------- ---------- ------------------ ---------- ----------
o.orcl     Running..            20000 06-Apr-17 09:34:43          0          0

   Last operation forwarded:        
        Redo log: 9          Log offset: 14857540   
        INSERT in "SOURCE"."T1" at 04/06/17 09:37:57

   Read state                       : Processing
   Activation id                    : 1

   Operations forwarded             : 20000
   Transactions forwarded           : 10000

   Full rollbacks                   : 0
   Full rollback operations skipped : 0

   Cursor cache hit count           : 0
   Cursor cache miss count          : 0
   Number of open cursors           : 0

   Number of active batches         : 0
   Batch message total              : 0

sp_ctrl (node1:2100)> show export detail

Host   : node1
Queue  : node1
                           Kbytes
Target     Status          Exported     Since              Total       Backlog
---------- --------------- ------------ ------------------ ---------- ----------
node2      Running                 7071 06-Apr-17 09:34:48          0          0


  Since activated
    Transmission rate                       : 28 Kb/sec
    Average packet size                     : 361 bytes
    Average send time                       : 11 microseconds

  Since export started
    Transmission rate                       : 28 Kb/sec
    Average packet size                     : 361 bytes
    Average send time                       : 11 microseconds

  During the last 55 seconds:
    Transmission rate                       : 127 Kb/sec
    Average packet size                     : 361 bytes
    Number of packets                       : 19999
    Average send time                       : 11 microseconds
    Largest deviation from average          : 19535 microseconds
    Send times deviating by more than %50   : %24.0  


sp_ctrl (node1:2100)> show log

m orcl) [module utl]
Notice   2017-04-06 09:24:51.807846 8818 2384041824 Capture: TDE support is disabled  (capturing from orcl) [module oct]
Notice   2017-04-06 09:24:51.821669 8818 2384041824 Capture: Setting up threads for 1 instances  (capturing from orcl) [module oct]
Notice   2017-04-06 09:24:51.821832 8818 2384041824 Capture: Instance orcl ACTIVE on host node1  (capturing from orcl) [module oct]
Notice   2017-04-06 09:24:51.821947 8818 2384041824 Capture: New instance orcl ACTIVE on host node1  (capturing from orcl) [module oct]
]
cl) [module oct]
unique_key = Enabled, foreign_key = Disabled  (capturing from orcl) [module oct]
Info     2017-04-06 09:24:51.973540 8818 2384041824 Capture now replicating actid 1, for sid o.orcl
unique_key = Enabled  (capturing from orcl) [module oct]
[module que]
Info     2017-04-06 09:24:51.984242 8823 1633273696 Reader launched, pid = 8823  (from orcl)
dule utl]
Notice   2017-04-06 09:24:53.267990 8823 1995130720 Reader: Oracle Available  (from orcl) [module ord]
]
event_log (15/60)

Press ENTER for next page, q to return to sp_ctrl command line.
   
Invalid input.
Invalid input.
Invalid input.
Info     2017-04-06 09:24:54.326083 8834 1633273696 Export launched, pid = 8834  (exporting to node2 queue node1)
Warning  2017-04-06 09:24:54.413769 8834 4003456864 Export cannot connect to host on node2: No route to host
Info     2017-04-06 09:24:54.414888 6519 1633273696 Export exited with code=1, pid = 8834  (exporting to node2 queue node1)
Info     2017-04-06 09:25:04.520533 8837 1633273696 Export launched, pid = 8837  (exporting to node2 queue node1)
Warning  2017-04-06 09:25:04.606011 8837 1503676256 Export cannot connect to host on node2: No route to host
Info     2017-04-06 09:25:04.606977 6519 1633273696 Export exited with code=1, pid = 8837  (exporting to node2 queue node1)
Info     2017-04-06 09:25:34.488707 8845 1633273696 Export launched, pid = 8845  (exporting to node2 queue node1)
Warning  2017-04-06 09:25:34.574722 8845 3117254496 Export cannot connect to host on node2: No route to host
Info     2017-04-06 09:25:34.575828 6519 1633273696 Export exited with code=1, pid = 8845  (exporting to node2 queue node1)
Info     2017-04-06 09:26:34.611380 8868 1633273696 Export launched, pid = 8868  (exporting to node2 queue node1)
Warning  2017-04-06 09:26:34.680910 8868 3623294816 Export cannot connect to host on node2: No route to host
Info     2017-04-06 09:26:34.681820 6519 1633273696 Export exited with code=1, pid = 8868  (exporting to node2 queue node1)
Info     2017-04-06 09:31:34.957097 8942 1633273696 Export launched, pid = 8942  (exporting to node2 queue node1)
Warning  2017-04-06 09:31:35.040506 8942 1923831648 Export cannot connect to host on node2: No route to host
Info     2017-04-06 09:31:35.041667 6519 1633273696 Export exited with code=1, pid = 8942  (exporting to node2 queue node1)
event_log (30/60)

Press ENTER for next page, p for previous, q to return to sp_ctrl command line.

Notice   2017-04-06 09:33:48.942542 8972 3317897056 User command: oracle stop capture (from node1)
Notice   2017-04-06 09:33:49.366746 8818 2384041824 Capture: shutting down by request  (capturing from orcl) [module oct]
Info     2017-04-06 09:33:49.380894 6519 1633273696 Capture exited normally, pid = 8818  (capturing from orcl)
Notice   2017-04-06 09:33:51.067531 8972 3317897056 User command: oracle stop read (from node1)
Notice   2017-04-06 09:33:51.068445 8823 1995130720 Reader: Shutting down by request  (from orcl) [module ord]
Notice   2017-04-06 09:33:54.343568 8972 3317897056 User command: oracle stop export (from node1)
Info     2017-04-06 09:33:57.119060 6519 1633273696 Reader exited normally, pid = 8823  (from orcl)
Notice   2017-04-06 09:34:01.485456 8972 3317897056 User command: oracle shutdown (from node1)
Info     2017-04-06 09:34:01.488890 6519 1633273696 SharePlex was shutdown
Notice   2017-04-06 09:34:22.712673 8981 3431524192 SharePlex for Oracle RAC/OPS : "erpetual Key"
Notice   2017-04-06 09:34:22.716737 8981 3431524192 Cop: Total queue shared memory usage 16916480  [module que]
Info     2017-04-06 09:34:22.727627 8981 3431524192 SharePlex was started on cpu 25614 using port 2100 version 8.6.6.64-m64-oracle110
Notice   2017-04-06 09:34:41.260392 8983 498132832 User command: oracle start capture (from node1)
Info     2017-04-06 09:34:41.262042 8985 3431524192 Capture launched, pid = 8985  (capturing from orcl)
m orcl) [module utl]
event_log (45/60)

Press ENTER for next page, p for previous, q to return to sp_ctrl command line.

Notice   2017-04-06 09:34:41.388184 8985 3458762592 Capture: TDE support is disabled  (capturing from orcl) [module oct]
Notice   2017-04-06 09:34:41.395097 8985 3458762592 Capture: Setting up threads for 1 instances  (capturing from orcl) [module oct]
Notice   2017-04-06 09:34:41.395212 8985 3458762592 Capture: Instance orcl ACTIVE on host node1  (capturing from orcl) [module oct]
le oct]
]
cl) [module oct]
unique_key = Enabled, foreign_key = Disabled  (capturing from orcl) [module oct]
Notice   2017-04-06 09:34:43.778622 8983 498132832 User command: oracle start read (from node1)
Info     2017-04-06 09:34:43.781131 8992 3431524192 Reader launched, pid = 8992  (from orcl)
dule utl]
Notice   2017-04-06 09:34:45.004181 8992 1432160096 Reader: Oracle Available  (from orcl) [module ord]
Notice   2017-04-06 09:34:48.849556 8983 498132832 User command: oracle start export (from node1)
Info     2017-04-06 09:34:48.855489 9004 3431524192 Export launched, pid = 9004  (exporting to node2 queue node1)
Info     2017-04-06 09:34:48.938848 9004 1347921760 Export connected to host on node2
Info     2017-04-06 09:34:48.939809 9004 1347921760 Export connected to import on node2
event_log (60/60)


End of event log.
Press p for previous, q to return to sp_ctrl command line.
q


sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> exit
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ ######verify data sync on node2
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ ssh node2
oracle@node2's password:
Last login: Thu Apr  6 09:35:25 2017 from node1
[oracle@node2 ~]$ sqlplus target/target

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 6 09:39:51 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> desc t1;
Name                                           Null?    Type
----------------------------------------- -------- ----------------------------
ID                                           NOT NULL NUMBER(38)
NAME                                                    VARCHAR2(20)

SQL> select count(*) from t1;

  COUNT(*)
----------
     10000

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node2 ~]$ sp_ctrl


*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************

sp_ctrl (node2:2100)> status

Brief Status for node2
Process          State                             PID     Running   Since     
---------------  ------------------------------  --------  --------------------
Cop              Running                            10893  06-Apr-17 09:33:16  
Import           Running                            10903  06-Apr-17 09:34:48  
Post             Running                            10904  06-Apr-17 09:34:49  
Cmd & Ctrl       Running                            10944  06-Apr-17 09:35:12  
Cmd & Ctrl       Running                            11037  06-Apr-17 09:40:05  
There are no active configuration files

sp_ctrl (node2:2100)> show sql
Last SQL statement of queue node1 and instance o.orcl-o.orcl on node2

   Thread    Session
   ------    -------
        0          0
/
   Thread is initializing : No SQL available yet.


   Thread    Session
   ------    -------
        3          2
/
   insert into "TARGET"."T1" ("ID","NAME") values (:V001,:V002)


   Thread    Session
   ------    -------
        4          3
/
   insert into "TARGET"."T1" ("ID","NAME") values (:V001,:V002)


   Thread    Session
   ------    -------
        5          4
/
   Thread is initializing : No SQL available yet.


   Thread    Session
   ------    -------
        0          5
/
   Thread is initializing : No SQL available yet.


   Thread    Session
   ------    -------
        0          6
/
   insert into "TARGET"."T1" ("ID","NAME") values (:V001,:V002)


   Thread    Session
   ------    -------
        0          7
/
   insert into "TARGET"."T1" ("ID","NAME") values (:V001,:V002)


   Thread    Session
   ------    -------
        2          8
/
   insert into "TARGET"."T1" ("ID","NAME") values (:V001,:V002)




sp_ctrl (node2:2100)> show import detail

   Usage: show import [queue quename] [from host] [on host]

sp_ctrl (node2:2100)> show import detail on host

   Usage: show import [queue quename] [from host] [on host]

sp_ctrl (node2:2100)> show import

Host: node2
                                          KBytes
Source                   Status           Imported      Since
------------------------ ---------------  ------------  ------------------
node1                    Running                  7071  06-Apr-17 09:34:48

sp_ctrl (node2:2100)> show post detail

Host   : node2
Source : o.orcl     Queue : node1

                           Operations
Target     Status              Posted Since              Total      Backlog
---------- --------------- ---------- ------------------ ---------- ----------
o.orcl     Running              10000 06-Apr-17 09:34:49          0          0

   Last operation posted:
        Redo log: 9              Log offset: 14854160   
        INSERT in "TARGET"."T1" at 04/06/17 09:37:57

   Last transaction posted:
        Redo log: 9              Log offset: 14857540   
        SCN: 1025891             Source time: 04/06/17 09:37:57

   Post state                        : Waiting
   Activation Id                     : 1
   Number of messages read released  : 0

   Number of threads                 : 4
   Number of Oracle connections      : 6
   Concurrency (Active sessions)     : 0
   Peak number of sessions           : 7

   Operations posted                 : 10000
   Transactions posted               : 10000

   Full rollbacks                    : 0
   Full rollback operations posted   : 0
   Rollback operations skipped       : 0

   Transactions <= 2                 : 10000
   Transactions > 10000              : 0
   Largest transaction               : 1

   Insert operations                 : 10000
   Update operations                 : 0
   Delete operations                 : 0

   Insert batch operations / average : 0 / 0 rows
   Update batch operations / average : 0 / 0 rows
   Delete batch operations / average : 0 / 0 rows

   Other operations                  : 0
   Lob changes                       : 0

   Key cache hit count               : 0
   SQL cache hit count               : 99 %



[END] 2017/4/6 21:41:07
标签: 暂无标签
dongxujian

写了 86 篇文章,拥有财富 384,被 13 人关注

转播转播 分享分享 分享淘帖
回复

使用道具

P4 | 发表于 2017-4-7 10:33:46
shareplex 8.6.6默认支持以下ddl:
alter table drop column/add column
truncate table
create table
序列sequence复制默认参数值为0,不开启
回复

使用道具

您需要登录后才可以回帖 登录 | 加入社区

本版积分规则

意见
反馈