[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
|
|
京ICP备12024223-8号
不良信息举报电话：13718043309
转播
分享
淘帖