【SharePlex安装】Quest Splex 7.0.2 for Oracle on Linux安装

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:264

准备好数据库
目标数据库的创建
字符集:zhs16gbk
Sid : target
创建表空间,见附录2。
创建用户
配置监听。
oracle_home相同。
[root@source ~]# more /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.10.150 source
192.168.10.152 target
192.168.10.180 splex-vip

ulimit -u 10000
ulimit -n 40960
ulimit -d unlimited
ulimit -m unlimited
ulimit -s unlimited
ulimit -t unlimited
ulimit -v unlimited
ulimit -l unlimited

配置环境变量
export SP_SYS_HOST_NAME=splex-vip (非rac环境,请不要设置此参数,否则运行sp_cop时报错:./sp_cop -u2200)
export SP_SYS_VARDIR=/splex/vardir2200

为SharePlex创建文件系统,要求:
创建在共享存储上;
该文件系统可以分别被mount在节点1和节点2上(非同时);
# chown -R oracle:dba /splex

打开补充日志
打开源端的补充日志。
alter database add supplemental log data (primary key, unique index) columns;
注:打开补充日志最好在夜里业务很少的时候进行。如果是RAC需要在每个节点上都执行。
完成后建议执行一次归档操作:alter system archive log current;

SharePlex 7.0的安装(用oracle用户)
[oracle@source soft]$ ./SharePlex-7.0.2-b24-oracle100-rh-30-x86.tpm
Unpacking ..................................................................
..........................................................................
..........................................................................
..........................................................................
.......................................................................
SharePlex for Oracle installation program:
SharePlex Version: 7.0.2
Supported Oracle Version: 10gR2
Build platform. rh-30-x86
Target platform. rh-40-x86
Please enter the product directory location? /splex/prodir
Please enter the variable data directory location? /splex/vardir2200
Please specify the SharePlex Admin group (select
2. dba
? 2
Please wait while the installer obtains Oracle information ...
Please specify the ORACLE_SID that corresponds to this installation (select a number):
1. [current => source]
2. csfmis
3.
? 1
Please enter the ORACLE_HOME directory that corresponds to this ORACLE_SID? [/oracle/product/10.2.0/db_1]
Please enter the TCP/IP port number for SharePlex communications? [2100] 2200
Preparing to install SharePlex for Oracle v. 7.0.2:
User: oracle
Admin Group: dba
Product Directory: /splex/prodir
Variable Data Directory: /splex/vardir2200
ORACLE_SID: source
ORACLE_HOME: /oracle/product/10.2.0/db_1
Proceed with upgrade? [yes] yes
Upgrading .................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
..............................................
Setting file permissions ..................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
...............................................................
Setting file ownerships ...................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
..............................................................
Do you have a valid SharePlex for Oracle v. 7.0.2 license? [yes] no --如果有license,则yes.输入
NOTE: You may add a license key(s) at any time by executing utility
/splex/prodir/install/splex_add_key

Please enter the License key? D2ZPW651FKWMYCHY2W6DXML0KLAAG11D6TVZW
Please enter the customer name associated with this license key? Trial Version
SharePlex for Oracle v. 7.0.2 license validation successful:
Customer Name: Trial Version
License Key: D2ZPW651FKWMYCHY2W6DXML0KLAAG11D6TVZW
Product Name: SharePlex for Oracle
License Key Type: "Trial Key"
Expires: at Midnight of Oct 25, 2010
NOTE: You can upgrade this license key or add license keys for additional machines
by executing utility /splex/prodir/install/splex_add_key.
Installation log saved to: /home/oracle/.shareplex/INSTALL-SharePlex-7.0.2-1009130515.log
SharePlex for Oracle v. 7.0.2 upgrade successful.

[oracle@target bin]$ ./ora_setup
Failed to statvfs SYS_VARDIR: No such file or directory
failed to stat vardir '/splex/vardir'
Couldn't init parameter database: exiting...

[oracle@target product]$ export SP_SYS_VARDIR=/splex/vardir2200
[oracle@target product]$ cd bin
配置数据库:
源库用户的所属表空间:(如果是双向复制,两个库都需要创建)
CREATE TABLESPACE tbs_splex DATAFILE
'/oracle/oradata/source/splex.dbf' SIZE 20M AUTOEXTEND ON NEXT 10M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM. SIZE 512K
SEGMENT SPACE MANAGEMENT AUTO;

[oracle@source bin]$ ./ora_setup
Welcome to the Oracle SharePlex setup process.
This process creates tables and user accounts needed to run
Oracle SharePlex replication.
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 [source] : source
In order to create the SharePlex tables and user account, we must
connect to the database as SYSTEM. The SYSTEM account must have
SYSDBA privileges.
Enter password for the SYSTEM account, which will not echo [MANAGER] :system@source
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] : y
Enter username for new user [SPLEX/SPLEX] : 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.
Setup will now install SharePlex objects.
These are the existing tablespaces.
SYSTEM UNDOTBS1 SYSAUX TEMP USERS FMISMAIN FMIS0000 FMIS0001
QUEST TBS_SPLEX GG_TBS DIRECTOR
Enter the default tablespace for use by SharePlex [ ] : TBS_SPLEX
Enter the temporary tablespace for use by SharePlex [TEMP] :
Enter the index tablespace for use by SharePlex [ ] : TBS_SPLEX
Creating SharePlex objects [Installation type: Fresh]. . .
Creating SharePlex Oracle-timezone-region map . . . Done.
Creating Conflict Resolution Package . . . Done.
Setup of SharePlex objects successful . . .
Changing SharePlex parameter database . . .
Setup completed successfully

[oracle@source bin]$ ./sp_cop -u2200
Parameter database initialization failed - exiting
去掉 bash_profile中的export SP_SYS_HOST_NAME=splex-vip后,正常
[oracle@source bin]$ ./sp_cop -u2200
Could not find SharePlex license - exiting
[oracle@source install]$ ./splex_add_key
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: 2
Enter Key: D2ZPW651FKWMYCHY2W6DXML0KLAAG11D6TVZW
Enter Customer Name: Trial Version

The SharePlex for Oracle license, "Trial Key" has been successfully added for host 49592.
It will expire after Midnight of Oct 25, 2010
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
[oracle@source install]$ ./splex_add_key
[oracle@source install]$ ls
clear_reclaim non-root-upgrade-only.rsp splex_add_key splex_remove
non-root-install-only.rsp root-upgrade-only.rsp splex_get_key splex_uname
[oracle@source install]$ ./splex_get_key
Customer Name = Trial Version
License Key = D2ZPW651FKWMYCHY2W6DXML0KLAAG11D6TVZW
Product Name = SharePlex for Oracle
License Key Type = "Trial Key"
Expires = at Midnight of Oct 25, 2010

3.2.3 设置SharePlex参数
根据应用的情况,设置SharePlex参数如下:
set param SP_ORD_CDA_LIMIT 20
set param SP_ORD_LDA_ARRAY_SIZE 10
set param SP_ORD_RMSG_LIMIT 10000
set param SP_IMP_WCMT_MSGCNT 10000
set param SP_COP_IDLETIME 600
set param SP_OSY_POST_TIMEOUT 5400
set param SP_OSY_THREADS 10
set param SP_OCF_THREAD_COUNT 8
set param SP_OPO_STOP_ON_DDL_ERR 0
set param SP_OPO_CONT_ON_ERR 1
set param SP_OSY_EXP_BUFFER_SIZE 51200
set param SP_OSY_IMP_BUFFER_SIZE 51200
set param SP_QUE_POST_SHMSIZE 67108864
set param SP_OPO_READRELEASE_INTERVAL 5000
set param SP_OPO_IDLE_LOGOUT 600
set param SP_OCT_OLOG_NO_DATA_DELAY 200000
set param SP_OCT_OPS_LOGREADER_RETRY 5
set param SP_OCT_OPS_NO_DATA_DELAY 10
set param SP_OCT_ARCH_LOC /archive
set param SP_OCT_REDO_RAW_OFFSET 0
vi ~/.bash_profile
export SP_OCT_TARGET_COMPATIBILITY=6.1
export SP_OCT_REPLICATE_DDL=2
export SP_ORD_CDA_LIMIT=20
export SP_ORD_LDA_ARRAY_SIZE=10
export SP_ORD_RMSG_LIMIT=10000
export SP_IMP_WCMT_MSGCNT=10000
export SP_COP_IDLETIME=600
export SP_OSY_POST_TIMEOUT=5400
export SP_OSY_THREADS=10
export SP_OCF_THREAD_COUNT=8
export SP_OPO_STOP_ON_DDL_ERR=0
export SP_OPO_CONT_ON_ERR=1
export SP_OSY_EXP_BUFFER_SIZE=51200
export SP_OSY_IMP_BUFFER_SIZE=51200
export SP_QUE_POST_SHMSIZE=67108864
export SP_OPO_READRELEASE_INTERVAL=5000
export SP_OPO_IDLE_LOGOUT=600
export SP_OCT_OLOG_NO_DATA_DELAY=200000
export SP_OCT_OPS_LOGREADER_RETRY=5
export SP_OCT_OPS_NO_DATA_DELAY=10
export SP_OCT_ARCH_LOC=/archive
export SP_OCT_REDO_RAW_OFFSET=0
3.2.4 验证SharePlex可用性
1. 启动SharePlex
以oracle用户登录
$export EXTSHM=ON
[oracle@source bin]$ ./sp_cop -u2200 &
[1] 7039
[oracle@source bin]$
*******************************************************
* SharePlex for Oracle Startup
* Protected by U.S. Patents: 7,461,103 and 7,065,538
* Version: 7.0.2.24
* VarDir : /splex/vardir2200
* Port : 2200
*******************************************************
[oracle@source bin]$ ps -ef|grep sp
oracle 7039 7003 11 00:55 pts/4 00:00:00 /splex/prodir/.app-modules/sp_cop -u2200
oracle 7041 7003 0 00:55 pts/4 00:00:00 grep sp
[oracle@source bin]$ export EXTSHM=OFF
$ ps -ef |grep sp_ 检查进程运行情况
$export EXTSHM=OFF
2. 关闭SharePlex
$ sp_ctrl
sp_ctrl> shutdown

[oracle@source bin]$ ./sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (source:2200)> help
List of command groups:
config - Control configurations.
connect - Control sp_cop connections.
info - Display status and statistics.
maint - Control displays and files.
misc - Miscellaneous commands.
param - Control parameters.
properties - Display properties of the system, SharePlex and user.
queues - Control queues.
run - Control processes.
sync - Control synchronization.
Type 'help' and a group name for a list of commands in the group
Type 'help' and a command name for a full description and syntax

.....
.....

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】