在oracle 11g上创建 所需的表空间及用户
#------------------------------------------------------------------------------------
创建临时表空间
create temporary tablespace tmp_opencms
tempfile '/u01/app/oracle-db/tmp_opencms.dbf'
Size 32m
autoextend on
extent management local;
#------------------------------------------------------------------------------------
创建表空间
create tablespace opencms
logging
datafile '/u01/app/oracle-db/opencms.dbf'
Size 32m
autoextend on
extent management local;
#------------------------------------------------------------------------------------
创建用户
create user fengrz705 identified by fengrz705
default tablespace opencms
temporary tablespace tmp_opencms;
#------------------------------------------------------------------------------------
授权给用户
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,DBA,CONNECT,RESOURCE,CREATE SESSION TO fengrz705
完成之后,复制oracle 11g的最新驱动到opencms/WEB_INF/lib下
重启tomcat
localhost:8080/opencms/setup
安装即可,其它步骤与 使用mysql数据库相同,不同之处如下
OpenCMS oracle安装
最新推荐文章于 2021-02-19 06:25:39 发布