[Building Sakai] Oracle database for sakai

[Steve Swinsburg]

HI,

Whats the issues you are experiencing with Oracle? I've had Sakai  
runing under multiple Oracle setups without issue.
What version Sakai, Oracle and oracle driver are you using?

For reference, here's a block for 2.5.x on Oracle
#######################################
##### DATABASE CONFIGURATION
#######################################

# establish auto.ddl - on by default
auto.ddl=true
#auto.ddl=false

## Oracle settings
username at javax.sql.BaseDataSource=XXXXXXXX
password at javax.sql.BaseDataSource=XXXXXXXX
vendor at org.sakaiproject.db.api.SqlService=oracle
driverClassName at javax.sql.BaseDataSource=oracle.jdbc.driver.OracleDriver
hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
url at javax.sql.BaseDataSource=jdbc:oracle:thin:@XXXXXXXX:1521:sand
validationQuery at javax.sql.BaseDataSource=select 1 from DUAL
defaultTransactionIsolationString 
@javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED

# For improved Oracle performance, implementers using Oracle should  
strongly consider
# enabling all the following settings just as they appear (suggestion  
from the University of Michigan).
validationQuery at javax.sql.BaseDataSource=
defaultTransactionIsolationString at javax.sql.BaseDataSource=
testOnBorrow at javax.sql.BaseDataSource=false

# enable hibernate SQL debugging output
hibernate.show_sql=false

If you are using Oracle 11g, I have heard the connection string needs  
to be changed.

Also make sure your user has the necessry permissions to create tables  
et al.

cheers,
Steve


On 14/11/2009, at 3:33 AM, Mathieu Cantin wrote:

> Hi everyone,
>
> I am looking for information about Oracle database specifications  
> for Sakai and this is not as easy as for MySQL.  If you are using  
> Sakai with an Oracle database, I would like to know what is your  
> Oracle config and what is the number of Sakai users on your site.   
> Is there any Sakai related parameters that need to be set when  
> creating the Oracle database for good performance?
>
> Thank you.
>
> Mathieu Cantin
> <Mathieu_Cantin.vcf>_______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org 
>  with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20091114/ce300479/attachment.html