AnsweredAssumed Answered

Alfresco Meta Data is not populating when oracle is used as a database server

Question asked by hniazi on May 12, 2014
Latest reply on May 12, 2014 by hniazi
Hi

I have done the installation of alfresco enterprise 4.1.5 linux VM with no postgress as i want to use oracle as a backend database server. After the installation is complete, i have restarted the alfresco servers with the following oracle properties and with their respective values in alfresco global properties after commenting out the postgress properties:

db.name=ALFRESCO_USER
db.username=ALFRESCO_USER
db.password=<password>
db.host=<host>
db.port=<port>
db.sid=<sid?
db.driver=oracle.jdbc.OracleDriver
db.url=jdbc:oracle:thin:@${db.host}:${db.port}:${db.sid}
db.pool.validate.query

db.schema.update=true

so that alfresco can create the metadata. But, the catalina.out log files give the following exception and after it wait for hours:


2014-05-12 03:16:06,961  INFO  [domain.schema.SchemaBootstrap] [main] Schema managed by database dialect org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect.
2014-05-12 03:16:06,981  ERROR [alfresco.util.DatabaseMetaDataHelper] [main] Unable to determine current schema.
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

and after giving the exception it does not creates the metadata as it is suppose to.

Can someone please tell me what am i missing here?

Regards

Outcomes