WPS V7 ON AIX WITH ORACLE群集安装记录(14)

创建WPS数据库用户

创建以下sql文件:04createWPSOraUser.sql(修改所需内容)

REM *******************************************************************

REM File: 04createWPSOraUser.sql

REM Date: 2009-05-04

REM

REM Desc: Create all Oracle database user for WPS 6.2.0.1

112

REM

REM Usage:

REM 1. Define db user names

REM 2. Define db user passwords for all WPS user

REM 3. Optional: Adjust default tablespaces.

REM 4. Execute the sql script as user oracle on the database host.

REM *******************************************************************

 

REM Create user for WPS common db

CREATE USER WPS_COMMONDB IDENTIFIED BY WPS_COMMONDB DEFAULT TABLESPACE WPS_COMMON_TBS;

GRANT WPS_USER_ROLE TO WPS_COMMONDB;

GRANT UNLIMITED TABLESPACE TO WPS_COMMONDB;

REM Create user for SCA application message engine

CREATE USER WPS_SCAAPPMSG IDENTIFIED BY WPS_SCAAPPMSG DEFAULT TABLESPACE WPS_MEAPP_TBS;

GRANT WPS_USER_ROLE TO WPS_SCAAPPMSG;

GRANT UNLIMITED TABLESPACE TO WPS_SCAAPPMSG;

REM Create user for SCA system message engine

CREATE USER WPS_SCASYSMSG IDENTIFIED BY WPS_SCASYSMSG DEFAULT TABLESPACE WPS_MESYS_TBS;

GRANT WPS_USER_ROLE TO WPS_SCASYSMSG;

GRANT UNLIMITED TABLESPACE TO WPS_SCASYSMSG;

REM Create user for CEI message engine

CREATE USER WPS_CEIMSG IDENTIFIED BY WPS_CEIMSG DEFAULT TABLESPACE WPS_MECEI_TBS;

GRANT WPS_USER_ROLE TO WPS_CEIMSG;

GRANT UNLIMITED TABLESPACE TO WPS_CEIMSG;

REM Create user for BPC message engine

CREATE USER WPS_BPCMSG IDENTIFIED BY WPS_BPCMSG DEFAULT TABLESPACE WPS_MEBPC_TBS;

GRANT WPS_USER_ROLE TO WPS_BPCMSG;

GRANT UNLIMITED TABLESPACE TO WPS_BPCMSG;

REM Create user for BPC data

CREATE USER WPS_BPCDB IDENTIFIED BY WPS_BPCDB;

GRANT WPS_USER_ROLE TO WPS_BPCDB;

GRANT UNLIMITED TABLESPACE TO WPS_BPCDB;

REM Create user for BPC Observer data

CREATE USER WPS_BPCOBS IDENTIFIED BY WPS_BPCOBS;

GRANT WPS_USER_ROLE TO WPS_BPCOBS;

GRANT UNLIMITED TABLESPACE TO WPS_BPCOBS;

REM Create user for CEI data

CREATE USER WPS_CEIDB IDENTIFIED BY WPS_CEIDB;

GRANT WPS_USER_ROLE TO WPS_CEIDB;

GRANT UNLIMITED TABLESPACE TO WPS_CEIDB;

REM Create user for Business Space data

CREATE USER WPS_BSPACE IDENTIFIED BY WPS_BSPACE;

GRANT WPS_USER_ROLE TO WPS_BSPACE;

GRANT UNLIMITED TABLESPACE TO WPS_BSPACE;

REM Commit work

COMMIT;

EXIT

用oracle用户登录到数据库服务器上执行以下语句,以创建(注意,sql文件当中定义的目录需要事先手工创建好,否则执行时会出错!)

 

sqlplus sys/<yourPassword>@ORCL AS SYSDBA @04createWPSOraUser.sql

 

检查运行结果,看看是否有错误发生。

 

创建WPS数据库XA Recovery用户

创建以下sql文件:05AcreateWPSrecoveryUser.sql(修改所需内容)

REM *******************************************************************

REM File: 05createWPSrecoveryUser.sql

REM Date: 2009-05-04

REM

REM Desc: Create WPS recovery database user for WPS 6.2.0.1

REM

REM Usage:

REM 1. Define db user names

REM 2. Define db user passwords for WPS recovery user

REM 3. Execute the sql script as user oracle on the database host.

REM *******************************************************************

REM Create WPS recovery user

CREATE USER WPS_RECOVERY IDENTIFIED BY WPS_RECOVERY;

GRANT WPS_USER_ROLE TO WPS_RECOVERY;

GRANT WPS_RECOVERY_ROLE TO WPS_RECOVERY;

REM Commit work

COMMIT;

EXIT

用oracle用户登录到数据库服务器上执行以下语句,以创建(注意,sql文件当中定义的目录需要事先手工创建好,否则执行时会出错!)

 

sqlplus sys/<yourPassword>@ORCL AS SYSDBA @05AcreateWPSrecoveryUser.sql

 

检查运行结果,看看是否有错误发生。

 

让所有WPS数据库用户获得recovery权限

创建以下sql文件:05BgrantWPSallUsersRecoveryPrivileges.sql(修改所需内容)

REM *******************************************************************

REM File: 05BgrantWPSallUSersRecoveryPrivileges.sql

REM Date: 2009-05-04

REM

REM Desc: Grant all Oracle database user the XA recovery privileges.

REM

REM Usage:

REM 1. Define db user names

REM 2. Execute the sql script as user oracle on the database host.

REM *******************************************************************

GRANT WPS_RECOVERY_ROLE TO WPS_COMMONDB;

GRANT WPS_RECOVERY_ROLE TO WPS_SCAAPPMSG;

GRANT WPS_RECOVERY_ROLE TO WPS_SCASYSMSG;

GRANT WPS_RECOVERY_ROLE TO WPS_CEIMSG;

GRANT WPS_RECOVERY_ROLE TO WPS_BPCMSG;

GRANT WPS_RECOVERY_ROLE TO WPS_BPCDB;

GRANT WPS_RECOVERY_ROLE TO WPS_BPCOBS;

GRANT WPS_RECOVERY_ROLE TO WPS_CEIDB;

GRANT WPS_RECOVERY_ROLE TO WPS_BSPACE;

REM Commit work

COMMIT;

EXIT

用oracle用户登录到数据库服务器上执行以下语句,以创建(注意,sql文件当中定义的目录需要事先手工创建好,否则执行时会出错!)

 

sqlplus sys/<yourPassword>@ORCL AS SYSDBA @05BgrantWPSallUsersRecoveryPrivileges.sql

 

检查运行结果,看看是否有错误发生。

 

创建WPS数据库CEI用户权限配置

创建以下sql文件:07AgrantCEIOraInstRights.sql(修改所需内容)

REM *******************************************************************

REM File: 07AgrantCEIOraInstRights.sql

REM Date: 2009-05-04

REM

REM Desc: Grant all needed privileges for installation/migration

REM to CEI db user for WPS 6.2.0.1

REM

REM Usage:

REM 1. Define db user name

REM 2. Execute the sql script as user oracle on the database host.

REM *******************************************************************

REM Grant install/migration privileges for CEI user

GRANT CREATE TABLESPACE TO WPS_CEIDB;

GRANT DROP TABLESPACE TO WPS_CEIDB;

GRANT CREATE TABLE TO WPS_CEIDB;

GRANT CREATE VIEW TO WPS_CEIDB;

REM Commit work

COMMIT;

EXIT

用oracle用户登录到数据库服务器上执行以下语句,以创建(注意,sql文件当中定义的目录需要事先手工创建好,否则执行时会出错!)

 

sqlplus sys/<yourPassword>@ORCL AS SYSDBA @07AgrantCEIOraInstRights.sql

 

检查运行结果,看看是否有错误发生。

 

让所有WPS数据库CEI用户获得额外权限

以下文章点击率最高

Loading…

发表评论