[Building Sakai] [Deploying Sakai] Sakai on Oracle 11.2 (11R2)
Mark Norton
markjnorton at earthlink.net
Fri Jan 13 11:09:23 PST 2012
Did you set the appropriate database properties in sakai.properties?
- mark
On 1/13/2012 1:58 PM, SUSANA COLLARTE A. wrote:
> Hello, Evandro, I am working to connect sakai 2.8.1 with Oracle 11.2, Do you help with information/configuration or driver?
> I have Unix, tomcat 5.5.28, jdk1.6.0_20 , in $CATALINA_HOME/common/lib/ojdbc5.jar. But when compile of logs send:
>
> " WARN main org.hibernate.cfg.SettingsFactory - Could not obtain connection metadata
> java.sql.SQLException: Error de E/S: The Network Adapter could not establish the connection
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
> at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
> at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
> at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
> at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
> at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
> at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)
> at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
> at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
> at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.getTargetConnection(LazyConnectionDataSourcePro
> xy.java:389)
> at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:364)
> at $Proxy0.getMetaData(Unknown Source)
> at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:86)
> at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2090)
> at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2086)
> at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1311)
> at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:814)
> at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:732)
> at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
> at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
> at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:114)
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
> at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
> at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:114)
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
> at org.sakaiproject.util.NoisierDefaultListableBeanFactory.preInstantiateSingletons(NoisierDefaultListableBeanFactory.java:73)
> at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
> at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
> at org.sakaiproject.component.impl.SpringCompMgr.init(SpringCompMgr.java:154)
> at org.sakaiproject.component.cover.ComponentManager.getInstance(ComponentManager.java:98)
> at org.sakaiproject.component.cover.ComponentManager.get(ComponentManager.java:107)
> at org.sakaiproject.component.cover.ServerConfigurationService.getInstance(ServerConfigurationService.java:52)
> at org.sakaiproject.util.RequestFilter.init(RequestFilter.java:766)
> at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:221)"
>
> Thanks,
>
>
> Saludos,
>
> Susana Collarte A.
> Jefa Area de Desarrollos e Investigacion TIC en Educación
> Subdireccion de Servicios Academicos, Direccion Informatica
> Pontificia Universidad Católica de Chile
> P: 562 354 7139
>
>
>
> -----Mensaje original-----
> De: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] En nombre de Evandro Pires Alves
> Enviado el: Miércoles, 27 de Abril de 2011 12:04
> Para: Roland Groen
> CC: production at collab.sakaiproject.org; Developers Sakai-Dev
> Asunto: Re: [Building Sakai] [Deploying Sakai] Sakai on Oracle 11.2 (11R2)
>
> Hi all
>
> We at IPBragança (Portugal) have recently update our Sakai 2.5.5 on
> Oracle11R1 to Sakai 2.7.1 Oracle11R2 without major problems.
>
>
> Qua, 2011-04-20 às 00:10 +0200, Roland Groen escreveu:
>> Hi Beth,
>>
>>
>> I've missed it also (google vs. jira), but I guess the coffee will go
>> to someone at Virginia Tech: PROD-96, it seems they are running sakai
>> 2.6.2 on Oracle 11.2.0.1.0. I'll raise your offer with a nice cold
>> beer ;).
>>
>>
>> With kind regards,
>>
>>
>> --
>> Roland M.S. Groen
>> roland at edia.nl
>>
>> Edia - Educatie Technologie
>> Korte Prinsengracht 42 hs | 1013 GT Amsterdam T 020 716 36 12 | F 020
>> 716 36 13 | M 06 2423 09 06 | www.edia.nl
>>
>>
>>
>> On Tue, Apr 19, 2011 at 11:00 PM, Beth Kirschner<bkirschn at umich.edu>
>> wrote:
>> While there are no QA servers running Oracle 11g, I believe
>> there are some institutions running it in production. There is
>> a "Production/Pilot Installations" project in JIRA that tracks
>> deployment data, but I suspect it isn't up-to-date (I didn't
>> find any mention of 11g there either).
>>
>> The University of Michigan is considering an upgrade to Oracle
>> 11g this summer and we'd be extremely interested if anyone
>> could either verify they are running it in production or
>> sharing why they've chosen not to. I'll even offer a free cup
>> of coffee at the conference to anyone who shares their
>> experience running 11g in production ;-)
>>
>> Thanks!
>> - Beth
>>
>>
>> On Apr 19, 2011, at 4:47 PM, Anthony Whyte wrote:
>>
>> >
>> >> 2.8.0 release notes only mentioned about 10g and 9i.
>> >
>> >
>> > Currently, we have no QA server with Oracle 11g installed on
>> it. If an organization would like to provide one please email
>> me.
>> >
>> > Cheers,
>> >
>> > Anth
>> >
>> >
>> > On Apr 19, 2011, at 4:27 PM, Omer Piperdi wrote:
>> >
>> >> We are also interested if anyone running 2.8.x with
>> 11.2(11g) in
>> >> production as well.
>> >>
>> >> 2.8.0 release notes only mentioned about 10g and 9i.
>> >>
>> >> Thanks
>> >> Omer
>> >>
>> >> On 4/19/2011 3:01 PM, Roland Groen wrote:
>> >>> Hi all, Martin, Cheryl,
>> >>>
>> >>> I'm sorry to bother you this way; I've noticed you've been
>> discussing
>> >>> the migration and testing of Oracle 11.2 on Sakai on the
>> sakai-dev list
>> >>> and I'd like to ask you some questions about the subject.
>> >>>
>> >>> The University of Amsterdam is looking into upgrading
>> their database
>> >>> servers to Oracle 11.2. They will be running Sakai 2.7.1..
>> I'm curious
>> >>> about your experiences and findings. Did you end up
>> running Oracle 11.2
>> >>> on your production environment? Are there any challenges
>> you've run into
>> >>> that might be taken in consideration?
>> >>>
>> >>> With kind regards,
>> >>>
>> >>> --
>> >>> *Roland M.S. Groen*
>> >>> roland at edia.nl<mailto:roland at edia.nl>
>> >>>
>> >>> *Edia* - Educatie Technologie
>> >>> Korte Prinsengracht 42 hs | 1013 GT Amsterdam
>> >>> *T* 020 716 36 12 | *F* 020 716 36 13 | *M* 06 2423 09 06
>> | www.edia.nl
>> >>> <http://www.edia.nl/>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>> _______________________________________________
>> >>> 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"
>> >>>
>> >>> !DSPAM:2294,4dadea46318137989116663!
>> >> _______________________________________________
>> >> 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"
>> >>
>> >>
>> >
>> > _______________________________________________
>> > 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"
>>
>>
>> _______________________________________________
>> production mailing list
>> production at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/production
>>
>> TO UNSUBSCRIBE: send email to
>> production-unsubscribe at collab.sakaiproject.org with a subject
>> of "unsubscribe"
>>
>>
>> _______________________________________________
>> 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"
> --
> Evandro P. Alves
> ================
> CTI.ESTiG.IPB.PT
> CDEV.IPB.PT
>
> _______________________________________________
> 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"
> _______________________________________________
> 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"
More information about the sakai-dev
mailing list