安装成功后并验证:
执行数据库操作,生成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…