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

[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
‍‍‍‍‍‍‍‍‍

[hniazi]

I did set it but it dint work either.

[kaynezhang]

please upload your log file

[mrogers]

Did you actually create an empty schema for alfresco to use?  And give the account you are going to use full access.