cancel
Showing results for 
Search instead for 
Did you mean: 

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

hniazi
Champ in-the-making
Champ in-the-making
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=jdbcSmiley Surprisedracle: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
4 REPLIES 4

kaynezhang
World-Class Innovator
World-Class Innovator
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
Champ in-the-making
Champ in-the-making
I did set it but it dint work either.

kaynezhang
World-Class Innovator
World-Class Innovator
please upload your log file

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