alfresco-oracle

最新推荐文章于 2025-08-10 13:24:43 发布

原创最新推荐文章于 2025-08-10 13:24:43 发布 · 238 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #java

ECM企业内容管理Alfresco 专栏收录该内容

2 篇文章

订阅专栏

本文档提供了在Oracle数据库上部署Alfresco的具体步骤，包括创建Alfresco模式及表空间、设置权限、配置属性文件等内容。适用于希望在Oracle环境中安装和运行Alfresco系统的管理员和技术人员。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1. Create a new schema alfresco and tablespace alfresco in your database
Example:
CREATE TABLESPACE alfresco DATAFILE 'ALFRESCO-TS.DAT' SIZE 512M REUSE AUTOEXTEND ON NEXT 256M;
CREATE USER alfresco DEFAULT TABLESPACE alfresco TEMPORARY TABLESPACE temp IDENTIFIED BY strongpassword;
ALTER USER alfresco QUOTA unlimited ON alfresco;
GRANT connect TO alfresco;
GRANT resource TO alfresco;
2. Ensure that the alfresco user has the required privileges to create and modify tables. This can be removed once the server has started, but may be required during upgrades.
3. Override following properties in your alfresco-global.properties:
hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect
db.driver=oracle.jdbc.OracleDriver
db.name=alfresco
db.url=jdbc:oracle:thin:@server.domain:1521:DBTNSNAME
db.username=alfresco
db.password=strongpassword
db.pool.validate.query=SELECT 1 FROM DUAL
If you get ORA errors then set hibernate.show_sql=true for debugging.

4. If you have multiple Alfresco instances installed on an Oracle server, you will need to force the database metadata queries to target the schema that each database user is using. Put the following in alfresco-global.properties:
hibernate.default_schema=ALFRESCO
5. Copy the Oracle JDBC driver JAR into \tomcat\lib (on Tomcat 6) or \jboss\server\default\lib (JBoss). Example:
cp oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar \tomcat\lib
6. You can now startup the Tomcat or Jboss server

FROM
https://github.com/krumboeck/oracle-alfresco/tree/4.2_e/src/config/alfresco/dbscripts
天行浏览器