rac to single instance shareplex 8.6.5 实践操作测试记录
INST_A_SP =(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))
CREATE TABLESPACE SPLEXDAT DATAFILE SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE 5G
LOGGING EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON;
CREATE TABLESPACE SPLEXIDX DATAFILE SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE 5G
LOGGING EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON;
INST_A_SP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcc)
(INSTANCE_NAME = orcc1)
)
)
INST_A_SP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcc)
(INSTANCE_NAME = orcc2)
)
)
# cat /etc/hosts
127.0.0.1 localhost
192.168.1.155 node1
192.168.1.156 node2
192.168.1.157 node1-vip
192.168.1.158 node2-vip
192.168.1.159 node-scan
10.10.5.155 node1-priv
10.10.5.156 node2-priv
192.168.1.10 inst_a-splex_vip
Utah Silo A (only on one of the nodes)
as root:
$ORACLE_HOME/bin/appvipcfg create -network=1 -ip=192.168.1.10 -vipname=shareplex.vip -user=orardbms -group=dba
as oracle:
crsctl start resource shareplex.vip
$ ifconfig
bond0 Link encap:EthernetHWaddr 00:0C:29:01:5E:6C
inet addr:192.168.1.155Bcast:192.168.1.255Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe01:5e6c/64 Scope:Link
UP BROADCAST RUNNING MASTER MULTICASTMTU:1500Metric:1
RX packets:239084 errors:0 dropped:0 overruns:0 frame:0
TX packets:235235 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:263041312 (250.8 MiB)TX bytes:171239478 (163.3 MiB)
bond0:1 Link encap:EthernetHWaddr 00:0C:29:01:5E:6C
inet addr:192.168.1.157Bcast:192.168.1.255Mask:255.255.255.0
UP BROADCAST RUNNING MASTER MULTICASTMTU:1500Metric:1
bond0:2 Link encap:EthernetHWaddr 00:0C:29:01:5E:6C
inet addr:192.168.1.10Bcast:192.168.1.255Mask:255.255.255.0
UP BROADCAST RUNNING MASTER MULTICASTMTU:1500Metric:1
bond1 Link encap:EthernetHWaddr 00:0C:29:01:5E:80
inet addr:10.10.5.155Bcast:10.10.5.255Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe01:5e80/64 Scope:Link
UP BROADCAST RUNNING MASTER MULTICASTMTU:1500Metric:1
RX packets:114190 errors:0 dropped:0 overruns:0 frame:0
TX packets:86618 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:81530237 (77.7 MiB)TX bytes:43836253 (41.8 MiB)
bond1:1 Link encap:EthernetHWaddr 00:0C:29:01:5E:80
inet addr:169.254.107.172Bcast:169.254.255.255Mask:255.255.0.0
UP BROADCAST RUNNING MASTER MULTICASTMTU:1500Metric:1
eth0 Link encap:EthernetHWaddr 00:0C:29:01:5E:6C
inet6 addr: fe80::20c:29ff:fe01:5e6c/64 Scope:Link
UP BROADCAST RUNNING SLAVE MULTICASTMTU:1500Metric:1
RX packets:238815 errors:0 dropped:0 overruns:0 frame:0
TX packets:235229 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:263017683 (250.8 MiB)TX bytes:171239010 (163.3 MiB)
eth1 Link encap:EthernetHWaddr 00:0C:29:01:5E:6C
inet6 addr: fe80::20c:29ff:fe01:5e6c/64 Scope:Link
UP BROADCAST RUNNING SLAVE MULTICASTMTU:1500Metric:1
RX packets:269 errors:0 dropped:0 overruns:0 frame:0
TX packets:6 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:23629 (23.0 KiB)TX bytes:468 (468.0 b)
eth2 Link encap:EthernetHWaddr 00:0C:29:01:5E:80
UP BROADCAST RUNNING SLAVE MULTICASTMTU:1500Metric:1
RX packets:114004 errors:0 dropped:0 overruns:0 frame:0
TX packets:86612 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:81497458 (77.7 MiB)TX bytes:43835785 (41.8 MiB)
eth3 Link encap:EthernetHWaddr 00:0C:29:01:5E:80
inet6 addr: fe80::20c:29ff:fe01:5e80/64 Scope:Link
UP BROADCAST RUNNING SLAVE MULTICASTMTU:1500Metric:1
RX packets:186 errors:0 dropped:0 overruns:0 frame:0
TX packets:6 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:32779 (32.0 KiB)TX bytes:468 (468.0 b)
lo Link encap:Local Loopback
inet addr:127.0.0.1Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNINGMTU:65536Metric:1
RX packets:22735 errors:0 dropped:0 overruns:0 frame:0
TX packets:22735 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:15039669 (14.3 MiB)TX bytes:15039669 (14.3 MiB)
$ cat /etc/hosts
127.0.0.1 localhost
192.168.1.155 node1
192.168.1.156 node2
192.168.1.157 node1-vip
192.168.1.158 node2-vip
192.168.1.159 node-scan
10.10.5.155 node1-priv
10.10.5.156 node2-priv
192.168.1.10 inst_a-splex_vip
$ ping inst_a-splex_vip
PING inst_a-splex_vip (192.168.1.10) 56(84) bytes of data.
64 bytes from inst_a-splex_vip (192.168.1.10): icmp_seq=1 ttl=64 time=0.020 ms
64 bytes from inst_a-splex_vip (192.168.1.10): icmp_seq=2 ttl=64 time=0.019 ms
^C
--- inst_a-splex_vip ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1867ms
rtt min/avg/max/mdev = 0.019/0.019/0.020/0.004 ms
$
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.ARCH.dg ora....up.type ONLINE ONLINE node1
ora.DATA.dg ora....up.type ONLINE ONLINE node1
ora....ER.lsnr ora....er.type ONLINE ONLINE node1
ora....N1.lsnr ora....er.type ONLINE ONLINE node2
ora.OCRVOTE.dg ora....up.type ONLINE ONLINE node1
ora.asm ora.asm.type ONLINE ONLINE node1
ora.cvu ora.cvu.type ONLINE ONLINE node2
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE node1
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsdapplication OFFLINE OFFLINE
ora.node1.onsapplication ONLINE ONLINE node1
ora.node1.vipora....t1.type ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsdapplication OFFLINE OFFLINE
ora.node2.onsapplication ONLINE ONLINE node2
ora.node2.vipora....t1.type ONLINE ONLINE node2
ora.oc4j ora.oc4j.typeONLINE ONLINE node2
ora.ons ora.ons.type ONLINE ONLINE node1
ora.orcc.db ora....se.type ONLINE ONLINE node1
ora....ry.acfs ora....fs.type ONLINE ONLINE node1
ora.scan1.vipora....ip.type ONLINE ONLINE node2
shareplex.vipapp....t1.type ONLINE ONLINE node1
# su - orardbms
$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=node2
export ORACLE_UNQNAME=orcc
export ORACLE_BASE=/oracle/oracle_base
export ORACLE_HOME=/oracle/oracle_home
export ORACLE_SID=orcc2
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
SP_SYS_HOST_NAME="inst_a-splex_vip" ; export SP_SYS_HOST_NAME
SP_INSTALL_DIR="/u02/app/quest"; export SP_INSTALL_DIR
SP_SYS_VARDIR="${SP_INSTALL_DIR}/vardir" ; export SP_SYS_VARDIR
SP_SYS_PRODDIR="${SP_INSTALL_DIR}/sp" ; export SP_SYS_PRODDIR
SP_OCT_ASM_SID="+ASM2" ; export SP_OCT_ASM_SID
export PATH=/u02/app/quest/sp/bin:$PATH
# ---------------------------------------------------
# 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_SYS_HOST_NAME="inst_a-splex_vip" ; export SP_SYS_HOST_NAME
SP_INSTALL_DIR="/u02/app/quest"; export SP_INSTALL_DIR
SP_SYS_VARDIR="${SP_INSTALL_DIR}/vardir" ; export SP_SYS_VARDIR
SP_SYS_PRODDIR="${SP_INSTALL_DIR}/sp" ; export SP_SYS_PRODDIR
SP_OCT_ASM_SID="+ASM1" ; export SP_OCT_ASM_SID
SP_SYS_HOST_NAME="inst_a-splex_vip" ; export SP_SYS_HOST_NAME
SP_INSTALL_DIR="/u02/app/quest"; export SP_INSTALL_DIR
SP_SYS_VARDIR="${SP_INSTALL_DIR}/vardir" ; export SP_SYS_VARDIR
SP_SYS_PRODDIR="${SP_INSTALL_DIR}/sp" ; export SP_SYS_PRODDIR
SP_OCT_ASM_SID="+ASM2" ; export SP_OCT_ASM_SID
$ cat /etc/oratab
#Backup file is/oracle/oracle_home/srvm/admin/oratab.bak.node2 line added by Agent
#
# 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.
#
#
+ASM2:/grid/grid_home:N # line added by Agent
orcc:/oracle/oracle_home:N # line added by Agent
inst_a_sp:/oracle/oracle_home:N
create acfs filesystem on the rac.mount point /u02.调整权限及属组
# export DISPLAY=192.168.1.1:0.0
# xhost +
access control disabled, clients can connect from any host
xhost:must be on local machine to enable or disable access control.
# su - oragrid
$ xhost +
access control disabled, clients can connect from any host
xhost:must be on local machine to enable or disable access control.
$ asmca
$ export LANG=C
$
# id orardbms
uid=1101(orardbms) gid=1200(oinstall) 组=1200(oinstall),1204(asmdba),1201(dba),1202(oper)
# chown -R orardbms:oinstall /u02
# chmod -R 775 /u02/
# cd /
# ls -l | grep u02
drwxrwxr-x 4 orardbms oinstall4096 11月 16 01:53 u02
# su - orardbms
$ mkdir -p /u02/app/quest/sp
$ mkdir -p /u02/app/quest/vardir
$
###########################rac node1 install shareplex
2016/11/15 18:00:54
$ tar -xf shareplex-8.6.3-b171-oracle110-rh-40-amd64-m64.tar
$ ls -ltr
??? 193740
-rwxr-xr-x1 orardbms oinstall 99055976 1?12 2016 SharePlex-8.6.3-b171-oracle110-rh-40-amd64-m64.tpm
-rw-------. 1 root root 0 7?15 03:42 yum.log
-rw-r--r--. 1 root root 206806 7?15 03:44 modules.dep
drwx------. 2 root root 4096 7?15 06:25 keyring-yrDUkF
drwx------. 2 orardbms oinstall 4096 7?16 09:10 yum-orardbms-aoY3Hz
drwx------. 2 root root 4096 7?16 23:10 pulse-KsqRSipl4QlT
drwxr-xr-x2 oragridoinstall 4096 7?16 23:37 logs
drwxr-xr-x2 oragridoinstall 4096 7?16 23:39 Logs
drwxr-x---2 oragridoinstall 4096 7?16 23:49 OraInstall2016-07-16_11-49-09PM
drwxr-xr-x4 oragridoinstall 4096 7?16 23:52 CVU_11.2.0.4.0_oragrid_fixup
-rwxr-xr-x1 orardbms oinstall 2411 7?17 00:05 acfsutil
drwxr-xr-x3 oragridoinstall 4096 7?17 00:17 CVU_11.2.0.4.0_oragrid
-rw-------1 root root 3096 7?17 00:24 yum_save_tx-2016-07-17-00-24Hcg2Oy.yumtx
drwxr-x---2 orardbms oinstall 4096 7?17 00:50 dbca
drwxr-xr-x3 orardbms oinstall 4096 7?17 01:36 CVU_11.2.0.4.0_orardbms
drwx------2 gdm gdm 4096 11? 16 00:55 orbit-gdm
drwx------. 2 gdm gdm 4096 11? 16 00:55 pulse-I0itRPt8I2b3
drwxr-xr-x2 oragridoinstall 4096 11? 16 01:52 hsperfdata_oragrid
-rwxrwxrwx1 orardbms oinstall 99061760 11? 16 01:59 shareplex-8.6.3-b171-oracle110-rh-40-amd64-m64.tar
$ ./SharePlex-8.6.3-b171-oracle110-rh-40-amd64-m64.tpm
Unpacking ..................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
....................................................
SharePlex installation program:
SharePlex Version: 8.6.3
Build platform: rh-40-amd64
Target platform: rh-40-amd64
Please enter the product directory location? /u02/app/quest/sp
Please enter the variable data directory location? /u02/app/quest/vardir
Please specify the SharePlex Admin group (select a number):
1.
2. asmdba
3. dba
4. oper
?1
Please wait while the installer obtains Oracle information ...
Please specify the ORACLE_SID that corresponds to this installation (select a number):
1.
2. inst_a_sp
3. <Other ...>
?2
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.3:
User: orardbms
Admin Group: oinstall
Product Directory: /u02/app/quest/sp
Variable Data Directory:/u02/app/quest/vardir
ORACLE_SID: inst_a_sp
ORACLE_HOME: /oracle/oracle_home
Proceed with installation? yes
Installing ................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
........................
Setting file ownerships ...................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.....................................
Setting file permissions ..................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
......................................
Do you have a valid SharePlex v. 8.6.3 license?
Please enter the License key? CU40GU35J56Y7YH2MFLGA23ZRGN27F81JW
Please enter the customer name associated with this license key? taiji
WARNING: Invalid license key: The license expired on Jun 13, 2016: License "CU40GU35J56Y7YH2MFLGA23ZRGN27F81JW": Customer "taiji"
NOTE: Installation will continue. You may add license keys by executing utility
/u02/app/quest/sp/install/splex_add_key
Installation log saved to: /home/oracle/.shareplex/INSTALL-SharePlex-8.6.3-1611160201.log
SharePlex for Oracle v.8.6.3 installation successful.
####################### rac node2 add lincense
$ ssh node2
$ /u02/app/quest/sp/util/splex_uname
Dell Inc. splex_unameversion 8.6.3.171-m64-oracle110
Local system info:
Host Name = node2
Host ID = 61688
Operating System = Linux
OS Version = 2.6.32-573.el6.x86_64
Machine Model = x86_64
CPU Type = 6666
CPU Speed =
$ /u02/app/quest/sp/install/splex_add_key
gethostbyname(inst_a-splex-vip) failed
SharePlex License Utility
1) Read license key from file
2) Enter license key manually
3) Add license key for alternate host
q) Quit License Utility
Enter option: 3
Enter hostID returned by util/splex_uname program: 61688
SharePlex License Utility
Adding license for machine ID : 61688
1) Read license key from file
2) Enter license key manually
q) Quit License Utility
Enter option: 2
Enter Key: CU40GU35J56Y7YH2MFLGA23ZRGN27F81JW
Enter Customer Name: taiji
The SharePlex license has been successfully added for host 61688.
SharePlex License Utility
1) Read license key from file
2) Enter license key manually
3) Add license key for alternate host
q) Quit License Utility
Enter option: q
$
$
$
$ pwd
/u02/app/quest/sp/bin
$ ./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) : n
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 TNS alias for which SharePlex should be installed : inst_a_sp
Verifying TNS supplied ... done.
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 inst_a_sp: system
NOTE: Appending the tns alias to the password via @ sign is not needed.
Enter password for the DBA account, which will not echo :
NOTE: @ was detected in the password for TNS connection.It is no longer needed.
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.
Current SharePlex user is : SPLEX
Warning: Changing SharePlex user requires
reactivating the current configuration.
Would you like to create a new SharePlex user ? : y
NOTE: Appending the tns alias to the password via @ sign is not needed.
Enter username for new user : splex
Enter password for new user :
Re-enter password for new user :
Warning:This user is now being granted unlimited tablespace.
This privilege will remain in effect until it is explicitly changed.
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 UNDOTBS2 USERS SPLEXDAT SPLEXIDX
EXAMPLE
Enter the default tablespace for use by SharePlex : SPLEXDAT
Enter the temporary tablespace for use by SharePlex :
Enter the index tablespace for use by SharePlex [ ] : SPLEXIDX
Creating SharePlex objects . . .
Creating SharePlex Oracle-timezone-region map . . . Done.
Creating Conflict Resolution Package . . . Done.
Creating SharePlex Dataequator package . . .
Loading Compare Package from "/u02/app/quest/sp/util/sp_deq_pkg.plb"...Done.
Loading Compare Varray Package from "/u02/app/quest/sp/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)? : y
ASM detected.Do you wish to connect to ASM using BEQUEATH connection? :
Enter the ASM Sid to be used by SharePlex:[+ASM1] :
Make sure that $SP_SYS_PRODDIR/.app-modules/adminize is owned by a user who also belongs in the ASM admin group.
SharePlex ASM support enabled.
Setup of SharePlex objects successful . . .
Changing SharePlex connection database . . .
Setup completed successfully
#####################单实例节点安装shareplex
create tablespace splexdat datafile '/u01/app/oracle/oradata/orcl/splexdat.dbf' SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE 5G
Tablespace created.
create tablespace splexidx datafile '/u01/app/oracle/oradata/orcl/splexidx.dbf' SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE 5G;
Tablespace created.
SQL>
$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.1.7 node3
$ 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
SP_SYS_HOST_NAME="node3" ; export SP_SYS_HOST_NAME
SP_INSTALL_DIR="/u02/app/quest"; export SP_INSTALL_DIR
SP_SYS_VARDIR="${SP_INSTALL_DIR}/vardir" ; export SP_SYS_VARDIR
SP_SYS_PRODDIR="${SP_INSTALL_DIR}/sp" ; export SP_SYS_PRODDIR
# ---------------------------------------------------
# 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
$ exit
logout
# cd /
# mkdir -p /u02/app/quest
# mkdir -p /u02/app/quest/vardir
# mkdir -p /u02/app/quest/sp
# chown oracle:oinstall /u02
# chown -R oracle:oinstall /u02
# chmod -R 775 /u02
$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.7)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
INST_B_SP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.7)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
(INSTANCE_NAME = orcl)
)
)
$ tail -2 /etc/oratab
orcl:/u01/app/oracle/product/11.2.0/dbhome_1:N
inst_b_sp:/u01/app/oracle/product/11.2.0/dbhome_1:N
#####单实例安装shareplex
# 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
SP_SYS_HOST_NAME="node3" ; export SP_SYS_HOST_NAME
SP_INSTALL_DIR="/u02/app/quest"; export SP_INSTALL_DIR
SP_SYS_VARDIR="${SP_INSTALL_DIR}/vardir" ; export SP_SYS_VARDIR
SP_SYS_PRODDIR="${SP_INSTALL_DIR}/sp" ; export SP_SYS_PRODDIR
export PATH=/u02/app/quest/sp/bin:$PATH
# ---------------------------------------------------
# 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
2016/11/15 18:44:02
$ cd /tmp
$ ls -l| grep shareplex
-rw-r--r--. 1 root root 99061760 Nov 15 05:43 shareplex-8.6.3-b171-oracle110-rh-40-amd64-m64.tar
$ chmod 777 shareplex-8.6.3-b171-oracle110-rh-40-amd64-m64.tar
chmod: changing permissions of `shareplex-8.6.3-b171-oracle110-rh-40-amd64-m64.tar': Operation not permitted
$ exit
logout
# cd /tmp
# chmod 777 shareplex-8.6.3-b171-oracle110-rh-40-amd64-m64.tar
# su - oracle
$ cd /tmp
$ tar -xf shareplex-8.6.3-b171-oracle110-rh-40-amd64-m64.tar
$ ls -l | grep Share
-rwxr-xr-x. 1 oracle oinstall 99055976 Jan 112016 SharePlex-8.6.3-b171-oracle110-rh-40-amd64-m64.tpm
$ ./SharePlex-8.6.3-b171-oracle110-rh-40-amd64-m64.tpm
Unpacking ..................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
....................................................
SharePlex installation program:
SharePlex Version: 8.6.3
Build platform: rh-40-amd64
Target platform: rh-40-amd64
Please enter the product directory location? /u02/app/quest/sp
Please enter the variable data directory location? /u02/app/quest/vardir
Please specify the SharePlex Admin group (select a number):
1.
2. dba
3. oper
?1
Please wait while the installer obtains Oracle information ...
Please specify the ORACLE_SID that corresponds to this installation (select a number):
1.
2. inst_b_sp
3. <Other ...>
?2
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.3:
User: oracle
Admin Group: oinstall
Product Directory: /u02/app/quest/sp
Variable Data Directory:/u02/app/quest/vardir
ORACLE_SID: inst_b_sp
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.3 license?
Please enter the License key? CU40GU35J56Y7YH2MFLGA23ZRGN27F81JW
Please enter the customer name associated with this license key? taiji
WARNING: Invalid license key: The license expired on Jun 13, 2016: License "CU40GU35J56Y7YH2MFLGA23ZRGN27F81JW": Customer "taiji"
NOTE: Installation will continue. You may add license keys by executing utility
/u02/app/quest/sp/install/splex_add_key
Installation log saved to: /home/oracle/.shareplex/INSTALL-SharePlex-8.6.3-1611150545.log
SharePlex for Oracle v.8.6.3 installation successful.
rac
cd /u02/app/quest/vardir/data
view paramdb
SP_COP_TPORT 2100
SP_COP_UPORT 2100
SP_OCT_TDE_SHARED_SECRET "" # SPO TDE Shared Secret
SP_OCT_ASM_SUPPORT "1" # ASM support on or off
SP_OCT_ASM_USE_OCI "1"
SP_ORD_LOGIN_O.inst_a_SP "77bff9a39a0c2bb430c6c013e35ba8617cc4521279ff"
SP_ORD_OWNER_O.inst_a_SP "SPLEX"
SP_SYS_LIC_61688 "CN0DW1WAVEJG3NCMC4647K0YMEB0SXBJYW:XINJIANG ELECTRIC POWER CORP"
SP_SYS_LIC_35426 "CN0DW1WAVEJG3NCMC4647K0YMEB0SXBJYW:XINJIANG ELECTRIC POWER CORP"
SP_SHS_SHMSIZE "33554432" # Statistics shared-memory Size
SP_OCT_USE_DST "0" # If 1, factor in DST when computing REDOLOG_ENSURE
SP_OCT_REPLICATE_SEQUENCES 0
SP_OCT_REPLICATE_DDL 0
SP_OCT_AUTOADD_ENABLE 1
SP_DEQ_THREADS "1" # Number of compare threads to run
SP_SYS_API_KEY "18188a00-ab7a-11e6-9512-091373480034" #SPO Encryption Salt
单实例
cd /u02/app/quest/vardir/data
view paramdb
SP_COP_TPORT 2100
SP_COP_UPORT 2100
SP_OCT_TDE_SHARED_SECRET "" # SPO TDE Shared Secret
SP_ORD_LOGIN_O.inst_b_SP "77bff9a39a0c2bb430c6e89c013ba8617cc4511279ff"
SP_ORD_OWNER_O.inst_b_SP "SPLEX"
SP_SYS_LIC_8737 "CN0DW1WAVEJG3NCMC4647K0YMEB0SXBJYW:XINJIANG ELECTRIC POWER CORP"
SP_SHS_SHMSIZE "33554432" # Statistics shared-memory Size
SP_OCT_USE_DST "0" # If 1, factor in DST when computing REDOLOG_ENSURE
SP_OCT_REPLICATE_DDL 0
SP_OCT_AUTOADD_ENABLE 1
SP_DEQ_THREADS "1" # Number of compare threads to run
rac
$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 16 03:54:27 2016
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 88
Next log sequence to archive 89
Current log sequence 89
SQL> select force_logging from v$database;
FOR
---
NO
SQL> alter database force logging;
Database altered.
SQL>alter database add supplemental log data (primary key, unique index) columns;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL>
rac:
cd /u02/app/quest/vardir/config
vi schema_name_all
datasource:o.inst_a_sp
#source tables target tables routing map
expand hr.% hr.% node3@o.inst_b_sp
单实例：
cd /u02/app/quest/vardir/config
$ more schema_name_all
datasource:o.inst_b_SP
#source tables target tables routing map
expand hr.% hr.% node3@o.inst_a_SP
############
# cat /etc/hosts
127.0.0.1 localhost
192.168.1.155 node1
192.168.1.156 node2
192.168.1.157 node1-vip
192.168.1.158 node2-vip
192.168.1.159 node-scan
10.10.5.155 node1-priv
10.10.5.156 node2-priv
192.168.1.10 inst_a-splex_vip
192.168.1.7 node3
# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.1.7 node3
192.168.1.10 inst_a-splex_vip
Start SharePlex:
On silo A and silo B (on the host with SP VIP):
sp_cop &
Stop Target Post:
On silo B ONLY (on the host with SP VIP):
sp_ctrl
stop post
Activate Config:
On the Silo A (on the host with the SP VIP):
sp_ctrl
activate config schema_name_all
$ ./sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Dell, Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (inst_a-splex_vip:2100)> status
Brief Status for inst_a-splex_vip
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 1359616-Nov-16 05:32:48
Capture Running 1362216-Nov-16 05:33:03
Read Running 1364116-Nov-16 05:33:04
Export Running 1376516-Nov-16 05:34:49
Cmd & Ctrl Running 1535916-Nov-16 06:00:31
System is used as a source machine
There is 1 active configuration file
sp_ctrl (inst_a-splex_vip:2100)> status
Brief Status for inst_a-splex_vip
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 1359616-Nov-16 05:32:48
Capture Running 1362216-Nov-16 05:33:03
Read Running 1364116-Nov-16 05:33:04
Export Running 1376516-Nov-16 05:34:49
Cmd & Ctrl Running 1535916-Nov-16 06:00:31
System is used as a source machine
There is 1 active configuration file
sp_ctrl (node3:2100)> status
Brief Status for node3
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 349915-Nov-16 08:34:14
Cmd & Ctrl Running 350115-Nov-16 08:34:21
Import Running 350515-Nov-16 08:34:50
Post Stopped by user
There are no active configuration files
$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 16 06:03:44 2016
Copyright (c) 1982, 2013, Oracle.All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> select current_scn from v$database;
CURRENT_SCN
-----------
1056866
SQL>
expdp system/oracle DUMPFILE=hr.dmp DIRECTORY=dir1 SCHEMAS=hr flashback_scn=1056866
$ expdp system/oracle DUMPFILE=hr.dmp DIRECTORY=dir1 SCHEMAS=hr flashback_scn=1056866
Export: Release 11.2.0.4.0 - Production on Wed Nov 16 06:07:06 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":system/******** DUMPFILE=hr.dmp DIRECTORY=dir1 SCHEMAS=hr flashback_scn=1056866
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 448 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "HR"."COUNTRIES" 6.367 KB 25 rows
. . exported "HR"."DEPARTMENTS" 7.007 KB 27 rows
. . exported "HR"."EMPLOYEES" 16.80 KB 107 rows
. . exported "HR"."JOBS" 6.992 KB 19 rows
. . exported "HR"."JOB_HISTORY" 7.054 KB 10 rows
. . exported "HR"."LOCATIONS" 8.273 KB 23 rows
. . exported "HR"."REGIONS" 5.476 KB 4 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/tmp/hr.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Wed Nov 16 06:07:32 2016 elapsed 0 00:00:26
# cd /tmp
# scp -pr hr.dmpnode3:/tmp/
The authenticity of host 'node3 (192.168.1.7)' 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 'node3,192.168.1.7' (RSA) to the list of known hosts.
root@node3's password:
hr.dmp 100%504KB 504.0KB/s 00:00
#
impdp system/oracle DIRECTORY=dir1 DUMPFILE=hr.dmp
# cd /tmp
# chmod 777 hr.dmp
# impdp system/oracle DIRECTORY=dir1 DUMPFILE=hr.dmp
-bash: impdp: command not found
# su - oracle
$ impdp system/oracle DIRECTORY=dir1 DUMPFILE=hr.dmp
Import: Release 11.2.0.4.0 - Production on Tue Nov 15 09:10:02 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates.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
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01":system/******** DIRECTORY=dir1 DUMPFILE=hr.dmp
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "HR"."COUNTRIES" 6.367 KB 25 rows
. . imported "HR"."DEPARTMENTS" 7.007 KB 27 rows
. . imported "HR"."EMPLOYEES" 16.80 KB 107 rows
. . imported "HR"."JOBS" 6.992 KB 19 rows
. . imported "HR"."JOB_HISTORY" 7.054 KB 10 rows
. . imported "HR"."LOCATIONS" 8.273 KB 23 rows
. . imported "HR"."REGIONS" 5.476 KB 4 rows
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at Tue Nov 15 09:10:08 2016 elapsed 0 00:00:05
禁用查找相关JOB
select job_name from dba_scheduler_jobs where OWNER='HR';
禁用触发器
select 'alter trigger '||owner||'.'||object_name||' disable'
from dba_objects
where object_type='TRIGGER' and owner='HR';
查找外键及约束
select'alter table '||t.owner||'.'||t.table_name||' disable constraint '||t.constraint_name||';'
From dba_constraints t
where owner='HR' and constraint_type='R';
$ ./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) : n
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 TNS alias for which SharePlex should be installed : inst_b_sp
Verifying TNS supplied ... done.
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 inst_b_sp: system
NOTE: Appending the tns alias to the password via @ sign is not needed.
Enter password for the DBA account, which will not echo :
NOTE: @ was detected in the password for TNS connection.It is no longer needed.
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.
Current SharePlex user is : SPLEX
Warning: Changing SharePlex user requires
reactivating the current configuration.
Would you like to create a new SharePlex user ? : n
NOTE: Appending the tns alias to the password via @ sign is not needed.
Enter username of an existing user : splex
'splex' is not a current SharePlex user.Would you like to create a new SharePlex user ? : n
NOTE: Appending the tns alias to the password via @ sign is not needed.
Enter username of an existing user : splex
'splex' is not a current SharePlex user.Would you like to create a new SharePlex user ? : y
NOTE: Appending the tns alias to the password via @ sign is not needed.
Enter username for new user : splex
Enter password for new user :
Re-enter password for new user :
Warning:This user is now being granted unlimited tablespace.
This privilege will remain in effect until it is explicitly changed.
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 SPLEXDAT SPLEXIDX
Enter the default tablespace for use by SharePlex : SPLEXDAT
Enter the temporary tablespace for use by SharePlex :
Enter the index tablespace for use by SharePlex [ ] : SPLEXIDX
Creating SharePlex objects . . .
Creating SharePlex Oracle-timezone-region map . . . Done.
Creating Conflict Resolution Package . . . Done.
Creating SharePlex Dataequator package . . .
Loading Compare Package from "/u02/app/quest/sp/util/sp_deq_pkg.plb"...Done.
Loading Compare Varray Package from "/u02/app/quest/sp/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
$ ./sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Dell, Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (node3:2100)> status
Brief Status for node3
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 349915-Nov-16 08:34:14
Import Running 350515-Nov-16 08:34:50
Post Stopped by user
Cmd & Ctrl Running 374415-Nov-16 09:15:03
There are no active configuration files
sp_ctrl (node3:2100)>
reconcile queue inst_a-splex_vip for o.INST_A_SP-o.INST_B_SP scn 1056866
单实例启动post:
$ ./sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Dell, Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (node3:2100)> status
Brief Status for node3
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 349915-Nov-16 08:34:14
Import Running 350515-Nov-16 08:34:50
Post Stopped by user
Cmd & Ctrl Running 377815-Nov-16 09:22:02
There are no active configuration files
sp_ctrl (node3:2100)> start post
sp_ctrl (node3:2100)> status
Brief Status for node3
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 349915-Nov-16 08:34:14
Import Running 350515-Nov-16 08:34:50
Post Running 377915-Nov-16 09:22:08
Cmd & Ctrl Running 377815-Nov-16 09:22:02
There are no active configuration files
rac :
$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Dell, Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (inst_a-splex_vip:2100)> qstatus
Queues Statistics for inst_a-splex_vip
Name:o.inst_a_sp (Capture queue)
Number of messages: 0 (Age 0 min; Size 65 mb)
Backlog (messages): 0 (Age 0 min)
Name:inst_a-splex_vip (Export queue)
Number of messages: 0 (Age 0 min; Size 65 mb)
Backlog (messages): 0 (Age 0 min)
单实例：
$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Dell, Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (node3:2100)> status
Brief Status for node3
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 277816-Nov-16 04:04:12
Post Stopped by user
Import Running 289016-Nov-16 04:16:23
Cmd & Ctrl Running 301716-Nov-16 04:47:35
There are no active configuration files
sp_ctrl (node3:2100)> reconcile queue inst_a_sp for o.inst_a_sp-o.inst_b_sp scn 1736488
internal error -- see event log
sp_ctrl (node3:2100)> qstatus
Queues Statistics for node3
Name:inst_a-splex_vip (o.inst_a_sp-o.inst_b_sp) (Post queue)
Number of messages: 0 (Age 0 min; Size 35 mb)
Backlog (messages): 0 (Age 0 min)
sp_ctrl (node3:2100)> reconcile queue inst_a-splex_vip for o.inst_a_sp-o.inst_b_sp scn 1736488
If this Process hangs it is likely related to no activity on the source.Log into the source database and create at least one transaction, then force a log switch.
sp_ctrl (node3:2100)> reconcile queue inst_a-splex_vip for o.inst_a_sp-o.inst_b_sp scn 1736488
sp_ctrl (node3:2100)>
sp_ctrl (node3:2100)>
sp_ctrl (node3:2100)>
sp_ctrl (node3:2100)>
sp_ctrl (node3:2100)>
sp_ctrl (node3:2100)> qstatus
Queues Statistics for node3
Name:inst_a-splex_vip (o.inst_a_sp-o.inst_b_sp) (Post queue)
Number of messages: 19 (Age 0 min; Size 88 mb)
Backlog (messages): 18 (Age 0 min)
sp_ctrl (node3:2100)> show
Process Source Target State PID
---------- ------------------------------------ ---------------------- -------------------- ------
Post o.inst_a_sp-inst_a-splex_vip o.inst_b_sp Stopped by user
Import inst_a-splex_vip node3 Running 2890
sp_ctrl (node3:2100)> status
Brief Status for node3
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 277816-Nov-16 04:04:12
Post Stopped by user
Import Running 289016-Nov-16 04:16:23
Cmd & Ctrl Running 301716-Nov-16 04:47:35
Cmd & Ctrl Running 331716-Nov-16 05:00:41
There are no active configuration files
sp_ctrl (node3:2100)> start post
sp_ctrl (node3:2100)> status
Brief Status for node3
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 277816-Nov-16 04:04:12
Post Running 334816-Nov-16 05:06:09
Import Running 289016-Nov-16 04:16:23
Cmd & Ctrl Running 301716-Nov-16 04:47:35
Cmd & Ctrl Running 331716-Nov-16 05:00:41
There are no active configuration files
Cleanup Target Tables:
Run the cleanup.sql script to truncate all of the SharePlex internal tables.
Only run this on Silo B:
cd?/u02/app/quest/sp/bin
sqlplus splex/<pass>@inst_b_sp
@cleanup.sql
On rac (as root):
su - orardbms
cd /u02/app/quest/vardir/
mkdir tmp
第一次调用脚本后调整下面两个文件的权限
cd /u02/app/quest
chown orardbms:oinstall startsplex
chown orardbms:oinstall stopsplex
chmod 777startsplex
chmod 777stopsplex
$ pwd
/u02/app/quest/scripts
# more spctl.sh
#!/bin/sh
export SP_SYS_PRODDIR=/u02/app/quest/sp
export TOUCH=/bin/touch
export RM=/bin/rm
export PATH_NAME=/u02/app/quest/vardir/tmp/splexagent_`hostname`
export SP_COP_TPORT=2100
export SP_COP_UPORT=2100
export SP_SYS_HOST_NAME="inst_a-splex_vip"
export SP_SYS_VARDIR=/u02/app/quest/vardir
export SP_SYS_PRODDIR=/u02/app/quest/sp
export LOG=/u02/app/quest
case "$1" in
'start')
echo "Creating the file: $PATH_NAME"
$TOUCH $PATH_NAME
chmod 777 $PATH_NAME
echo `date` > $LOG/startsplex
echo `ps -ef|grep pmon` >> $LOG/startsplex
$SP_SYS_PRODDIR/bin/sp_cop -u2100 >> $LOG/startsplex &
exit 0
;;
'stop')
echo "Deleting the file: $PATH_NAME"
$RM $PATH_NAME
echo "issue shareplex stop command ......."
echo "shutdown" |$SP_SYS_PRODDIR/bin/sp_ctrl> $LOG/stopsplex
echo `date`>> $LOG/stopsplex
echo `ps -ef|grep pmon` >> $LOG/stopsplex
exit 0
;;
'check')
echo "CHECK entry point has been called.."
if [ -e $PATH_NAME ]; then
echo "Check -- SUCCESS"
exit 0
else
echo "Check -- FAILED"
exit 1
fi
;;
'clean')
echo "CLEAN entry point has been called.."
echo "Deleting the file: $PATH_NAME"
$RM -f $PATH_NAME
exit 0
;;
esac
自动启动还是有问题：
状态显示正常，但是为未启动，
手动启动：
VIP 在那台机器上就在那台机器上启动 su - orardbms
sp_cop &
sp_ctrl
root:
#/grid/grid_home/bin/crsctl add resource shareplex -type cluster_resource -attr "ACTION_SCRIPT=/u02/app/quest/scripts/spctl.sh, CHECK_INTERVAL=30, START_DEPENDENCIES='hard(ora.registry.acfs,ora.orcc.db) pullup(shareplex.vip)', STOP_DEPENDENCIES='hard(shareplex.vip,ora.orcc.db)'"
#/grid/grid_home/bin/crsctl add resource shareplex -type cluster_resource -attr "ACTION_SCRIPT=/u02/app/quest/scripts/spctl.sh, CHECK_INTERVAL=30, START_DEPENDENCIES='hard(ora.registry.acfs) pullup(shareplex.vip)', STOP_DEPENDENCIES='hard(shareplex.vip)'"
#/grid/grid_home/bin/crsctl add resource shareplex -type cluster_resource -attr "ACTION_SCRIPT=/u02/app/quest/scripts/spctl.sh,CHECK_INTERVAL=30, START_DEPENDENCIES='hard(shareplex.vip) pullup(shareplex.vip)', STOP_DEPENDENCIES='hard(shareplex.vip)'"
/grid/grid_home/bin/crsctl add resource shareplex -type cluster_resource -attr "ACTION_SCRIPT=/u02/app/quest/scripts/spctl.sh,CHECK_INTERVAL=30, START_DEPENDENCIES='hard(shareplex.vip,ora.asm) pullup(shareplex.vip)', STOP_DEPENDENCIES='hard(shareplex.vip)'"
root:
/grid/grid_home/bin/crsctl setperm resource shareplex -o orardbms
4: Start the application
$ORA_CRS_HOME/bin/crsctl start resource shareplex
问题1:
sp_ctrl (inst_a-splex_vip:2100)> status
Brief Status for inst_a-splex_vip
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 1314116-Nov-16 05:26:31
Cmd & Ctrl Running 1314516-Nov-16 05:26:41
Capture Stopped - due to error
日志：
otice 2016-11-16 05:27:04.367557 13215 1594824544 Capture: The database supplemental logging state = Enabled, primary_key = Disabled, unique_key = Disabled(capturing from inst_a_sp)
Error 2016-11-16 05:27:04.818307 13215 1301313280 Capture: Error reading block 0 from file +DATA/orcc/onlinelog/group_2.258.917398465: ASMreadBlock: ASMFileReadBlock: ASMFileReadExtent: ASMDgroupReadDisk: ASMDgroupDiskRead: Open Error 13 on disk 0, path /dev/mapper/data: Permission denied. (group 2 DATA). (extent number 0, file +DATA/orcc/onlinelog/group_2.258.917398465). (block number 0, file +DATA/orcc/onlinelog/group_2.258.917398465).(capturing from inst_a_sp)
Error 2016-11-16 05:27:04.819812 13215 1301313280 Capture: If this setup is on an Exadata environment or if capture is reading logs located on a remote server, make sure that the parameter SP_OCT_ASM_USE_OCI is set to 1.Restart the capture process after setting the parameter.(capturing from inst_a_sp)
Error 2016-11-16 05:27:04.837847 13215 1301313280 Capture stopped: Internal error encountered; cannot continue(capturing from inst_a_sp)
Error 2016-11-16 05:27:04.893314 13215 1290823424 Capture: Error reading block 0 from file +DATA/orcc/onlinelog/group_3.265.917400205: ASMreadBlock: ASMFileReadBlock: ASMFileReadExtent: ASMDgroupReadDisk: ASMDgroupDiskRead: Open Error 13 on disk 0, path /dev/mapper/data: Permission denied. (group 2 DATA). (extent number 0, file +DATA/orcc/onlinelog/group_3.265.917400205). (block number 0, file +DATA/orcc/onlinelog/group_3.265.917400205).(capturing from inst_a_sp)
Error 2016-11-16 05:27:04.898349 13215 1290823424 Capture: If this setup is on an Exadata environment or if capture is reading logs located on a remote server, make sure that the parameter SP_OCT_ASM_USE_OCI is set to 1.Restart the capture process after setting the parameter.(capturing from inst_a_sp)
Error 2016-11-16 05:27:04.901108 13215 1290823424 Capture stopped: Internal error encountered; cannot continue(capturing from inst_a_sp)
Notice 2016-11-16 05:27:05.857330 13215 1594824544 Capture: shutting down by request(capturing from inst_a_sp)
Info 2016-11-16 05:27:05.865166 13141 266577760 Capture exited normally, pid = 13215(capturing from inst_a_sp)
event_log (60/60)
解决：
$ pwd
/u02/app/quest/vardir/data
$ cat paramdb
#
# User Parameter Database
#
# This file contains any parameter values which are different from
# their default values.The customer may changes to this file
# as they see fit - HOWEVER, certain parameters such as SP_ORD_LOGIN
# and SP_ORD_OWNER are NOT user manageable and should only be changed
# by ora_setup.
#
# The format of this file is:
#
#key value pending # desc
#
# key The unique name for this parameter.It should be of the format
# module.name
#
# value The current value of this parameter.
#
# pending The pending value of this parameter.This change will take
# effect at the next reboot.
#
# desc Description for this parameter.
#
#
#SP_COP_TPORT 2100
#SP_COP_UPORT 2100
#SP_SYS_LIC_61688 "CN0DW1WAVEJG3NCMC4647K0YMEB0SXBJYW:XINJIANG ELECTRIC POWER CORP"
#SP_SYS_LIC_35426 "CN0DW1WAVEJG3NCMC4647K0YMEB0SXBJYW:XINJIANG ELECTRIC POWER CORP"
SP_COP_TPORT 2100
SP_COP_UPORT 2100
SP_OCT_TDE_SHARED_SECRET "" # SPO TDE Shared Secret
SP_OCT_ASM_SUPPORT "1" # ASM support on or off
SP_OCT_ASM_USE_OCI "1" ######添加此参数
SP_ORD_LOGIN_O.inst_a_SP "77bff9a39a0c2bb430c6c013e35ba8617cc4521279ff"
SP_ORD_OWNER_O.inst_a_SP "SPLEX"
SP_SYS_LIC_61688 "CN0DW1WAVEJG3NCMC4647K0YMEB0SXBJYW:XINJIANG ELECTRIC POWER CORP"
SP_SYS_LIC_35426 "CN0DW1WAVEJG3NCMC4647K0YMEB0SXBJYW:XINJIANG ELECTRIC POWER CORP"
SP_SHS_SHMSIZE "33554432" # Statistics shared-memory Size
SP_OCT_USE_DST "0" # If 1, factor in DST when computing REDOLOG_ENSURE
SP_OCT_REPLICATE_SEQUENCES 0
SP_OCT_REPLICATE_DDL 0
SP_OCT_AUTOADD_ENABLE 0
SP_DEQ_THREADS "1" # Number of compare threads to run
SP_SYS_API_KEY "18188a00-ab7a-11e6-9512-091373480034" #SPO Encryption Salt
页:
[1]