安裝成功後並驗證：
執行數據庫操作，生成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…