shareplex 8.6.6 实现不同数据库用户数据同步
2017/4/6 20:56:08# 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
#
#
#
# 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
# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.4 (Santiago)
#
#
# 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
#
#
# arch
x86_64
#
#
#
# id oracle
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1300(dba),1301(oper)
# su - oracle
$ 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/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
$
$
$
$
$
$ 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
$
$
$
$
$ 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
$
$
$ 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:
$ 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
$
$
$ exit
logout
Connection to node2 closed.
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$ 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_SID:$ORACLE_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
$
$
$
$ ssh node2
oracle@node2's password:
Last login: Thu Apr6 08:57:45 2017 from 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_SID:$ORACLE_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
$
$
$ exit
logout
Connection to node2 closed.
$
$
$
$
$
$
$
$
$
$
$ ######### node1 prepare to install shareplex 8.6.6
$
$
$ 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
$
$
$
$
$
$
$
$
$ ###################install shareplex 8.6.6 on node1
$
$
$
$ cd
$ ls -l
total 104280
-r-xr-xr-x. 1 root root 106782720 Apr6 08:41 shareplex-8.6.6-b64-oracle110-rh-40-amd64-m64.tar
$ 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)
$
$
$
$
$ tar -xvf shareplex-8.6.6-b64-oracle110-rh-40-amd64-m64.tar
SharePlex-8.6.6-b64-oracle110-rh-40-amd64-m64.tpm
$ ls -l
total 208560
-r-xr-xr-x. 1 root root 106782720 Apr6 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
$ ./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.
2. dba
3. oper
?1
Please wait while the installer obtains Oracle information ..
Please enter the ORACLE_SID that corresponds to this installation?
Please enter the ORACLE_HOME directory that corresponds to this ORACLE_SID?
Please enter the TCP/IP port number for SharePlex communications?
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?
Installing ................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
..........................................
Setting file ownerships ...................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.......................................................
Setting file permissions ..................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
........................................................
Do you have a valid SharePlex v. 8.6.6 license?
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: "Perpetual 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.
$
$
$
$
$
$
$
$ cd /u01/app/proddir/bin
$ ls -l
total 4
lrwxrwxrwx. 1 oracle oinstall 27 Apr6 09:02 cleanup.sql -> ../.app-modules/cleanup.sql
lrwxrwxrwx. 1 oracle oinstall 31 Apr6 09:02 clean_vardir.sh -> ../.app-modules/clean_vardir.sh
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 config_parser -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 dumpfile -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 dumpque -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 hana_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 hana_setup -> ../.app-modules/launcher
drwxrwxr-x. 2 oracle oinstall 4096 Apr6 09:02 hooks
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 ora_chpwd -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 ora_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 ora_setup -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 pb_ctrl -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 pg_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 pg_setup -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 qview -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 socket_test -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 sp_cop -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 sp_ctrl -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 sp_declt -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 sp_desvr -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 sp_sync_clt -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 sp_sync_launcher -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 sp_sync_svr -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 sp_wallet -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 td_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:02 td_setup -> ../.app-modules/launcher
-rw-rw-r--. 1 oracle oinstall 0 Apr6 09:02 vardirs.log
$ cd
$ vi .bash_profile
$
$
$
$ grap proddir .bash_profile
-bash: grap: command not found
$ grep proddir .bash_profile
PATH=${PATH}:/u01/app/proddir/bin:/u01/app/common/oracle/bin
$
$
$
$ sp_cop &
6507
$ -bash: sp_cop: command not found
+Exit 127 sp_cop
$ 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)
$ source .bash_profile
$
$
$
$ sp_cop &
6519
$
*******************************************************
* 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
*******************************************************
$ ps -ef | grep sp_cop
oracle 651931171 09:06 pts/1 00:00:00 /u01/app/proddir/.app-modules/sp_cop
oracle 652331170 09:07 pts/1 00:00:00 grep sp_cop
$
$
$
$
$
$ 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 651906-Apr-17 09:07:00
Cmd & Ctrl Running 652606-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
$ ################ execute ora_setup on node1 to setup shareplex
$
$
$ 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) :
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 :
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 ? :
Enter username for new user :
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? :
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 :
Enter the temporary tablespace for use by SharePlex :
Enter the index tablespace for use by SharePlex [ ] : USERS
Creating SharePlex objects . . .
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: be used as source (including cases as source for failover or master-master setups)? :
Setup of SharePlex objects successful . . .
Changing SharePlex connection database . . .
Setup completed successfully
$
$
$
$
$
$
$ 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 651906-Apr-17 09:07:00
Cmd & Ctrl Running 654506-Apr-17 09:09:02
There are no active configuration files
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> exit
$
$
$
$
$ ###############prepare to install shareplex on node2
$
$
$ ssh node2
oracle@node2's password:
Last login: Thu Apr6 08:58:39 2017 from node1
$ 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
$ 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
$
$
$
$ ls -l
total 104280
-r-xr-xr-x. 1 root root 106782720 Apr6 08:42 shareplex-8.6.6-b64-oracle110-rh-40-amd64-m64.tar
$
$
$
$
$
$ #########################install shareplex 8.6.6 on node2
$
$
$
$ pwd
/home/oracle
$ ls
shareplex-8.6.6-b64-oracle110-rh-40-amd64-m64.tar
$ tar -xvf shareplex-8.6.6-b64-oracle110-rh-40-amd64-m64.tar
SharePlex-8.6.6-b64-oracle110-rh-40-amd64-m64.tpm
$ ./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.
2. dba
3. oper
?
Please wait while the installer obtains Oracle information ..
Please enter the ORACLE_SID that corresponds to this installation?
Please enter the ORACLE_HOME directory that corresponds to this ORACLE_SID?
Please enter the TCP/IP port number for SharePlex communications?
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?
Installing ................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
..........................................
Setting file ownerships ...................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.......................................................
Setting file permissions ..................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
........................................................
Do you have a valid SharePlex v. 8.6.6 license?
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: "Perpetual 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.
$
$
$
$
$
$ cd /u01/app/proddir/bin
$ pwd
/u01/app/proddir/bin
$ ls -l
total 4
lrwxrwxrwx. 1 oracle oinstall 27 Apr6 09:12 cleanup.sql -> ../.app-modules/cleanup.sql
lrwxrwxrwx. 1 oracle oinstall 31 Apr6 09:12 clean_vardir.sh -> ../.app-modules/clean_vardir.sh
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 config_parser -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 dumpfile -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 dumpque -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 hana_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 hana_setup -> ../.app-modules/launcher
drwxrwxr-x. 2 oracle oinstall 4096 Apr6 09:12 hooks
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 ora_chpwd -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 ora_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 ora_setup -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 pb_ctrl -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 pg_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 pg_setup -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 qview -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 socket_test -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 sp_cop -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 sp_ctrl -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 sp_declt -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 sp_desvr -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 sp_sync_clt -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 sp_sync_launcher -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 sp_sync_svr -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 sp_wallet -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 td_cleansp -> ../.app-modules/launcher
lrwxrwxrwx. 1 oracle oinstall 24 Apr6 09:12 td_setup -> ../.app-modules/launcher
-rw-rw-r--. 1 oracle oinstall 0 Apr6 09:12 vardirs.log
$ cd
$ vi .bash_profile
$ source .bash_profile
$ 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
$ sp_cop &
10607
$
*******************************************************
* 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
*******************************************************
$
$ 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 1060706-Apr-17 09:14:35
Cmd & Ctrl Running 1060906-Apr-17 09:14:40
There are no active configuration files
sp_ctrl (node2:2100)> exit
$
$
$
$
$
$
$ ###########execute ora_setup command to setup shareplex
$
$
$
$ 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) :
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 :
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 ? :
Enter username for new user :
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? :
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 :
Enter the temporary tablespace for use by SharePlex :
Enter the index tablespace for use by SharePlex [ ] : USERS
Creating SharePlex objects . . .
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: be used as source (including cases as source for failover or master-master setups)? : n
Setup of SharePlex objects successful . . .
Changing SharePlex connection database . . .
Setup completed successfully
$
$
$
$
$
$
$
$
$
$ #######node2 finished the shareplex 8.6.6 install and setup
$
$
$
$
$
$ exit
logout
Connection to node2 closed.
$
$
$
$
$
$
$
$ ##########create test user source on host 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
$ #####create test user targer on host node2
$
$
$ ssh node2
oracle@node2's password:
Last login: Thu Apr6 09:10:05 2017 from node1
$ 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
$
$
$ exit
logout
Connection to node2 closed.
$
$
$
$ ########## set config file for shareplex 8.6.6 on 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:o.SOURCE_SID
#source tables target tables routing map
#splex.demo_src splex.demo_dest target_system@o.target_sid
datasource:o.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 651906-Apr-17 09:07:00
Cmd & Ctrl Running 664506-Apr-17 09:20:51
Capture Running 881806-Apr-17 09:24:51
Read Running 882306-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
$
$
$ ########view processes status on node2
$
$ ssh node2
oracle@node2's password:
Last login: Thu Apr6 09:19:26 2017 from 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
*******************************************************
发现目标端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 1060706-Apr-17 09:14:35
Cmd & Ctrl Running 1072906-Apr-17 09:25:54
There are no active configuration files
$ 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 1060706-Apr-17 09:14:35
Cmd & Ctrl Running 1077006-Apr-17 09:31:26
There are no active configuration files
sp_ctrl (node2:2100)> exit
$ service iptables status 发现node2主机防火墙未关闭
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 1060706-Apr-17 09:14:35
Cmd & Ctrl Running 1088606-Apr-17 09:32:29
There are no active configuration files
关闭node1上的相关进程capture,read,export,sp_cop 进程，重新启动
$ 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 651906-Apr-17 09:07:00
Capture Running 881806-Apr-17 09:24:51
Read Running 882306-Apr-17 09:24:51
Export Idle
Cmd & Ctrl Running 897206-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
$ ps -ef | grep sp_cop
oracle 898031170 09:34 pts/1 00:00:00 grep sp_cop
+Done sp_cop
$ sp_cop &
8981
$
*******************************************************
* 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
*******************************************************
$
$
$
$
$ 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 898106-Apr-17 09:34:22
Capture Stopped by user
Read Stopped by user
Export Stopped by user
Cmd & Ctrl Running 898306-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 898106-Apr-17 09:34:22
Capture Running 898506-Apr-17 09:34:41
Read Running 899206-Apr-17 09:34:43
Export Running 900406-Apr-17 09:34:48
Cmd & Ctrl Running 898306-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进程是否启动成功
$ ssh node2
oracle@node2's password:
Last login: Thu Apr6 09:25:45 2017 from 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 (node2:2100)> status
Brief Status for node2
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 1089306-Apr-17 09:33:16
Import Running 1090306-Apr-17 09:34:48
Post Running 1090406-Apr-17 09:34:49
Cmd & Ctrl Running 1094406-Apr-17 09:35:12
Cmd & Ctrl Running 1097106-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
$
$
$
$
$
$
$
$ ############ do some dml on t1 of source user
$
$
$
$ 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 [{logon|/|proxy} ]
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
$ 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
$ exit
logout
Connection to node2 closed.
$ 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
2for i in 1 .. 10000
3loop
4insert into t1 values (i,to_char(i));
5commit;
6end loop;
7end;
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
$ 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 898106-Apr-17 09:34:22
Capture Running 898506-Apr-17 09:34:41
Read Running 899206-Apr-17 09:34:43
Export Running 900406-Apr-17 09:34:48
Cmd & Ctrl Running 905906-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)
Notice 2017-04-06 09:24:51.807846 8818 2384041824 Capture: TDE support is disabled(capturing from orcl)
Notice 2017-04-06 09:24:51.821669 8818 2384041824 Capture: Setting up threads for 1 instances(capturing from orcl)
Notice 2017-04-06 09:24:51.821832 8818 2384041824 Capture: Instance orcl ACTIVE on host node1(capturing from orcl)
Notice 2017-04-06 09:24:51.821947 8818 2384041824 Capture: New instance orcl ACTIVE on host node1(capturing from orcl)
]
cl)
unique_key = Enabled, foreign_key = Disabled(capturing from orcl)
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)
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)
]
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)
Warning2017-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)
Warning2017-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)
Warning2017-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)
Warning2017-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)
Warning2017-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)
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)
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 : "Perpetual Key"
Notice 2017-04-06 09:34:22.716737 8981 3431524192 Cop: Total queue shared memory usage 16916480
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)
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)
Notice 2017-04-06 09:34:41.395097 8985 3458762592 Capture: Setting up threads for 1 instances(capturing from orcl)
Notice 2017-04-06 09:34:41.395212 8985 3458762592 Capture: Instance orcl ACTIVE on host node1(capturing from orcl)
le oct]
]
cl)
unique_key = Enabled, foreign_key = Disabled(capturing from orcl)
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)
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
$
$
$
$ ######verify data sync on node2
$
$
$ ssh node2
oracle@node2's password:
Last login: Thu Apr6 09:35:25 2017 from node1
$ 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
$ 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 1089306-Apr-17 09:33:16
Import Running 1090306-Apr-17 09:34:48
Post Running 1090406-Apr-17 09:34:49
Cmd & Ctrl Running 1094406-Apr-17 09:35:12
Cmd & Ctrl Running 1103706-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
sp_ctrl (node2:2100)> show import detail on host
Usage: show import
sp_ctrl (node2:2100)> show import
Host: node2
KBytes
Source Status Imported Since
------------------------ ---------------------------------------------
node1 Running 707106-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 %
2017/4/6 21:41:07
shareplex 8.6.6默认支持以下ddl:
alter table drop column/add column
truncate table
create table
序列sequence复制默认参数值为0，不开启
页:
[1]