shareplex安装文档

最新推荐文章于 2020-11-30 16:37:06 发布

cmbyw04880

最新推荐文章于 2020-11-30 16:37:06 发布

阅读量151

点赞数

文章标签：数据库网络

前期规划
源数据库 10.25.5.42 数据库sid rman
目标数据库 10.25.5.43 数据库sid rman

安装规划

源数据库
Oracle_Home                   /home/oracle/product/10.2.
SharePlex OS user             splex
SharePlex admin group         dba
SharePlex port number(seed)   2200
SharePlex home directory      /quest1/splex
SharePlex vardir dir          /quest1/splex/vardir22   /该文件夹不用创建，安装时自动创建
SharePlex Oracle user         splex22
SharePlex user tablespace     SPLEX22
SharePlex temp tablespace     Temp22
SharePlex index tablespace    SPLEX22

目标数据库
Oracle_Home                   /home/oracle/product/10.2.
SharePlex OS user             splex
SharePlex admin group         dba
SharePlex port number(seed)   2200
SharePlex home directory      /quest1/splex
SharePlex vardir dir          /quest1/splex/vardir22
SharePlex Oracle user         splex22
SharePlex user tablespace     SPLEXU22
SharePlex temp tablespace     Temp22
SharePlex index tablespace    SPLEXI22

将源数据库改为归档模式
alter database archivelog;
alter database open;

alter system archive log start;
alter database add supplemental log data (primary key, unique index) columns; 附加日志
注意：对于RAC数据库，以上命令要在每个实例上运行一次，否则会出现capture无法捕获未执行以上命令的实例生成的REDO的情况。
添加OS 用于shareplex的用户 splex
useradd -u 600 -g dba splex

创建上面的表空间
报错
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
Tue Mar 2 23:46:19 2010
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************

解决办法
rman target /
crosscheck archivelog all;
delete expired archivelog all;

tar xvf SharePlex-6.1.1-b25-oracle100-rh-30-x86.tar

源数据库上
[splex@orabak_42 splex]$ rm -f vardir22/
rm: cannot remove `vardir22/': Is a directory
[splex@orabak_42 splex]$ rm -rf vardir22/
[splex@orabak_42 splex]$ ll
total 0
[splex@orabak_42 splex]$ cd /data/tools/
[splex@orabak_42 tools]$ ./SharePlex-6.1.1-b25-oracle100-rh-30-x86.tpm
Unpacking ..................................................................
..........................................................................
..........................................................................
..........................................................................
...................................................

SharePlex for Oracle installation program:
    SharePlex Version: 6.1.1
    Supported Oracle Version: 10gR2
    Build platform. rh-30-x86
    Target platform. rh-40-amd64

Please enter the product directory location? /quest1/splex
Please enter the variable data directory location? /quest1/splex/vardir2
Please specify the SharePlex Admin group (select a number):
1. [dba]
? 1
Please wait while the installer obtains Oracle information ..
Please enter the ORACLE_SID that corresponds to this installation? [rman]
Please enter the ORACLE_HOME directory that corresponds to this ORACLE_SID? [/home/oracle/product/10.2.0]
Please enter the TCP/IP port number for SharePlex communications? [2100] 2200

Preparing to install SharePlex for Oracle v. 6.1.1:
    User:                     splex
    Admin Group:              dba
    Product Directory:        /quest1/splex
    Variable Data Directory: /quest1/splex/vardir2
    ORACLE_SID:               rman
    ORACLE_HOME:              /home/oracle/product/10.2.0

Proceed with installation? [yes]
Installing ................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
......................
Setting file permissions ..................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
....................................
Do you have a valid SharePlex for Oracle v. 6.1.1 license? [yes] no

NOTE: You may add a license key(s) at any time by executing utility
/quest1/splex/install/splex_add_key

Customer Name    = Trial Version
License Key      = *************************
Product Name     = SharePlex for Oracle
License Key Type = "Trial Key"
Expires          = at Midnight of Apr 26, 2010

Installation log saved to: /home/splex/.shareplex/INSTALL-SharePlex-6.1.1-1003022328.log
SharePlex for Oracle v. 6.1.1 installation successful.

目标数据库上

[splex@grid tools]$ ./SharePlex-6.1.1-b25-oracle100-rh-30-x86.tpm
Unpacking ..................................................................
..........................................................................
..........................................................................
..........................................................................
...................................................

SharePlex for Oracle installation program:
    SharePlex Version: 6.1.1
    Supported Oracle Version: 10gR2
    Build platform. rh-30-x86
    Target platform. rh-40-amd64

NOTE: You may add a license key(s) at any time by executing utility
/quest1/splex/install/splex_add_key

Installation log saved to: /home/splex/.shareplex/INSTALL-SharePlex-6.1.1-1003022352.log
SharePlex for Oracle v. 6.1.1 installation successful.

源数据库配置

[splex@orabak_42 bin]$ ora_setup
-bash: ora_setup: command not found
[splex@orabak_42 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 [rman] :

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] :

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] : n
Enter username of an existing user : splex22
Enter user password for splex22 :
validating user name and password. . . This may take a few seconds.

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 RMAN DATA LOG_INDX TSIMD10
TSIMD11 TSIMD12 TBPA01 TBPA02 TBPA03 TBPA04 TBPA05 TBPA06 TBPA07
TBPA08 TBPA09 TBPA10 TBPA11 TBPA12 SPLEXU22 SPLEXI22 TEMP22

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

Enter the temporary tablespace for use by SharePlex [TEMP22] :

Enter the index tablespace for use by SharePlex [ ] : splexi22

The current index tablespace for user splex22 is TOOLS.
Do you want to change to splexi22? [y] : n

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

./ora_setup

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16719800/viewspace-662296/，如需转载，请注明出处，否则将追究法律责任。