小X的安装备忘

2007/12/17 9:59:52
1、安装Oracle

2、以超户登陆Oracle（只能在本机登）

    sqlplus "/as sysdba"

3、创建用户XCOM,密码为XCOM

    create user xcom identified by xcom;

4、给用户XCOM赋权限

    grant resource, connect to xcom;

    grant execute on dbms_pipe to xcom;

    grant execute on dbms_lob to xcom;

    grant execute on dbms_lock to xcom;

5、运行建表脚本，运行前改连接字符串

    echo off

    set DB_STRING=xcom/xcom@ORCL

    sqlplus %DB_STRING%  < xcom_table.sql

    sqlplus %DB_STRING%  < bsdb.sql

    sqlplus %DB_STRING%  < xcom_pack.sql

6、配置XCOM所用表

    hostconfig表、messageconfig表

7、改xconfig.ini配置文件

    [Server]

    storage=xcom.core.xdbstore

    [db]

    args=数据库连接

8、改xproc.ini配置文件

    都设为1

9、改edservice.ini配置文件

    [db]

    connstr=数据库连接