SharePlex需要配置数据库,在数据库中建立一个模式用户(以下称之为Oracle SharePlex用户),并在该模式下建立一些数据对象,这些对象对于复制至关重要,他们保存了关于复制链路的状态的信息。
配置数据库的工作由SharePlex提供的ora_setup脚本完成,以下是运行该脚本的步骤:
在安装SharePlex的节点上以oracle用户身份登录;
在/queue/splex/bin目录下运行ora_setup脚本,(其中/queue/splex为SharePlex的安装目录);
pmlnhdb2:/queue/splex/bin$ ora_setup
以下是ora_setup脚本的运行过程:
$ 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 [sid2] : splex1
注意:在此处不要使用本地的实例名,要输入TNS别名,然后回车;
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] :
注意:此处输入oracle数据库system帐户的口令,但应当在口令的后面加上@TNS_ALIAS, 然后回车;
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
此处脚本程序询问是否要建立一个新的Oracle SharePlex用户。如果是第一次为SharePlex配置数据库,在此处输入y,然后回车;如果是重新为SharePlex配置数据库,最好在此出输入n,然后回车;
Enter username for new user [SPLEX/SPLEX] :splex
如果是第一次为SharePlex配置数据库,在此处输入一个新的Oracle模式用户名建议用SPLEX,然后回车;如果是重新为SharePlex配置数据库,在此出输入先前为SharePlex配置的模式用户名,然后回车;
Enter password for new user :
注意:此处输入Oracle SharePlex用户的口令,但应当在口令的后面加上@TNS_ALIAS, 然后回车;源端输入d3nku81w@SPLEX1,目标端输入d3nku81w@SPLEX2
Re-enter password for new user :
此处再次输入Oracle SharePlex用户的口令,但应当在口令的后面加上@TNS_ALIAS, 然后回车;
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 UNDOTBS2 USERS EPMDAT1 EPMIDX EPMRANGE1
EPCDAT1 EPSA EPMTMP EPCTMP
Enter the default tablespace for use by SharePlex [ ] : users
:
此处输入Oracle SharePlex用户缺省的表空间名,然后回车;
Enter the temporary tablespace for use by SharePlex [TEMP] :
此处输入Oracle SharePlex用户的临时表空间名,建议用TEMP,然后回车;
Enter the index tablespace for use by SharePlex [ ] : users
此处输入Oracle SharePlex用户索引所在表空间名,然后回车;
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 .
此时,配置数据库工作完成,SharePlex for Oracle 的整个安装过程结束。
注:源端和目标端的配置类似。
配置数据库的工作由SharePlex提供的ora_setup脚本完成,以下是运行该脚本的步骤:
在安装SharePlex的节点上以oracle用户身份登录;
在/queue/splex/bin目录下运行ora_setup脚本,(其中/queue/splex为SharePlex的安装目录);
pmlnhdb2:/queue/splex/bin$ ora_setup
以下是ora_setup脚本的运行过程:
$ 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 [sid2] : splex1
注意:在此处不要使用本地的实例名,要输入TNS别名,然后回车;
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] :
注意:此处输入oracle数据库system帐户的口令,但应当在口令的后面加上@TNS_ALIAS, 然后回车;
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
此处脚本程序询问是否要建立一个新的Oracle SharePlex用户。如果是第一次为SharePlex配置数据库,在此处输入y,然后回车;如果是重新为SharePlex配置数据库,最好在此出输入n,然后回车;
Enter username for new user [SPLEX/SPLEX] :splex
如果是第一次为SharePlex配置数据库,在此处输入一个新的Oracle模式用户名建议用SPLEX,然后回车;如果是重新为SharePlex配置数据库,在此出输入先前为SharePlex配置的模式用户名,然后回车;
Enter password for new user :
注意:此处输入Oracle SharePlex用户的口令,但应当在口令的后面加上@TNS_ALIAS, 然后回车;源端输入d3nku81w@SPLEX1,目标端输入d3nku81w@SPLEX2
Re-enter password for new user :
此处再次输入Oracle SharePlex用户的口令,但应当在口令的后面加上@TNS_ALIAS, 然后回车;
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 UNDOTBS2 USERS EPMDAT1 EPMIDX EPMRANGE1
EPCDAT1 EPSA EPMTMP EPCTMP
Enter the default tablespace for use by SharePlex [ ] : users
:
此处输入Oracle SharePlex用户缺省的表空间名,然后回车;
Enter the temporary tablespace for use by SharePlex [TEMP] :
此处输入Oracle SharePlex用户的临时表空间名,建议用TEMP,然后回车;
Enter the index tablespace for use by SharePlex [ ] : users
此处输入Oracle SharePlex用户索引所在表空间名,然后回车;
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 .
此时,配置数据库工作完成,SharePlex for Oracle 的整个安装过程结束。
注:源端和目标端的配置类似。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14639914/viewspace-2137949/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14639914/viewspace-2137949/