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

安装成功后并验证:

执行数据库操作,生成WPS运行需要的支撑数据库

创建WPS数据库数据空间、用户、角色、权限

注:以下步骤将在数据库服务器上面进行,而非之前的WPS服务器上面。

创建推荐的TableSpace,创建以下文件01createRecWPSOraTablespaces.sql(修改所需内容)

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

REM File: 01createRecWPSOraTablespaces.sql

REM Date: 2009-05-04

REM

REM Desc: Create all recommended tablespaces for WPS 6.2.0.1

REM

REM Usage:

REM 1. Define datafile paths as needed.

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

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

 

REM Define Oracle datafile paths for WPS

Define WPS_TbsPath = “/home/oracle/oradata/ORCL”

 

REM Define Oracle datafile paths for the Message Engines

Define MEAPP_TbsPath = “/home/oracle/oradata/ORCL”

Define MESYS_TbsPath = “/home/oracle/oradata/ORCL”

Define MECEI_TbsPath = “/home/oracle/oradata/ORCL”

Define MEBPC_TbsPath = “/home/oracle/oradata/ORCL”

 

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

REM Create the Oracle tablespace for WPS

CREATE TABLESPACE WPS_COMMON_TBS DATAFILE ‘&WPS_TbsPath/WPS_COMMON.dbf’

SIZE 150 M REUSE AUTOEXTEND ON NEXT 10 M;

 

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

REM Create the Oracle tablespace for the Message Engines

CREATE TABLESPACE WPS_MEAPP_TBS DATAFILE ‘&MEAPP_TbsPath/WPS_MEAPP.dbf’

SIZE 100 M REUSE AUTOEXTEND ON NEXT 10 M;

CREATE TABLESPACE WPS_MESYS_TBS DATAFILE ‘&MESYS_TbsPath/WPS_MESYS.dbf’

SIZE 100 M REUSE AUTOEXTEND ON NEXT 10 M;

CREATE TABLESPACE WPS_MECEI_TBS DATAFILE ‘&MECEI_TbsPath/WPS_MECEI.dbf’

SIZE 100 M REUSE AUTOEXTEND ON NEXT 10 M;

CREATE TABLESPACE WPS_MEBPC_TBS DATAFILE ‘&MEBPC_TbsPath/WPS_MEBPC.dbf’

SIZE 100 M REUSE AUTOEXTEND ON NEXT 10 M;

 

REM Commit work

COMMIT;

EXIT

 

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

 

sqlplus sys/<yourPassword>@ORCL AS SYSDBA @01createRecWPSOraTablespaces.sql

 

检查得到以下运行结果

以下文章点击率最高

Loading…

发表评论