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

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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=jdbcracle: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

kaynezhang

You should set db.url property ,you can set it like this

db.username=alfresco
db.password=alfresco
db.driver=oracle.jdbc.OracleDriver
db.url=jdbc:oracle:thin:@localhost:1521:alfresco
‍‍‍‍‍‍

or like this

db.driver=oracle.jdbc.OracleDriver
db.url=jdbc:oracle:thin:@${db.host}:${db.port}:${db.name}
db.name=alfresco
db.host=localhost
db.port=1521
db.username=alfresco
db.password=alfresco
‍‍‍‍‍‍‍‍‍