[Building Sakai] [Deploying Sakai] Sakai on Oracle 11.2 (11R2)

SUSANA COLLARTE A. scollarte at uc.cl
Fri Jan 13 10:58:04 PST 2012


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"


More information about the sakai-dev mailing list