Alfresco Meta Data is not populating when oracle is used as a database server
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2014 09:44 AM
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
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
Labels:
- Labels:
-
Archive
4 REPLIES 4
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2014 10:07 AM
You should set db.url property ,you can set it like this
or like this
db.username=alfrescodb.password=alfrescodb.driver=oracle.jdbc.OracleDriverdb.url=jdbc:oracle:thin:@localhost:1521:alfresco
or like this
db.driver=oracle.jdbc.OracleDriverdb.url=jdbc:oracle:thin:@${db.host}:${db.port}:${db.name}db.name=alfrescodb.host=localhostdb.port=1521db.username=alfrescodb.password=alfresco
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2014 10:35 AM
I did set it but it dint work either.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2014 11:23 AM
please upload your log file
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2014 12:03 PM
Did you actually create an empty schema for alfresco to use? And give the account you are going to use full access.