Some additional Info. Here is the Oracle Function causing the problem http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11827/geor_ref.htm#CHEDHBII
Geoserver uses this function to export the image into a BLOB. Cheers Christian Zitat von Harikumar Reddy <harik....@gmail.com>: > Hi Christian, > > Thankyou for response. Oracle admin freed up oracle temporary table space > (when they checked free space was zero kb as you have expected) and created > new temporary table space also., but it didnt corrected geoserver problem. > > we may need to do R & D and observe the results, from image processing & > oracle side (with oracle admin). > > Regards, > Hari. > > On Mon, Sep 5, 2011 at 10:53 PM, <christian.muel...@nvoe.at> wrote: > >> Hi Hari, I am not working with Oracle, as a consequence I have less >> experience, but: >> >> creating an extra Oracle table space is ok, the question was if the table >> space was full at the moment geoserver refuses work. >> >> Was it ? >> >> If the temp tablespace is full then we have the reason but no solution. You >> have to open an oracle ticket because this seems to be an Oracle problem. Of >> course I can assist you in describing the situation since I developed the >> georaster plugin. >> >> >> Cheers >> Christian >> >> >> >> >> Zitat von Harikumar Reddy <harik....@gmail.com>: >> >> Hi Christian, >>> >>> Our oracle admin has created oracle temporary table space, but still this >>> problem exists. Any further investigation i need to do...Please advise me, >>> if you have any idea...The geoserver error is not specific to the problem >>> in >>> log file. >>> >>> Thanking you, >>> >>> Regards, >>> Hari. >>> >>> >>> On Sat, Sep 3, 2011 at 12:38 PM, <christian.muel...@nvoe.at> wrote: >>> >>> Hi, I examined your log file and there is nothing special. There is only >>>> one exception which has nothing to do with our problem here. >>>> >>>> Another user, Steve Way had similar problems and did investigations. Look >>>> here >>>> http://osgeo-org.1803224.n2.****nabble.com/Question-about-**<http://nabble.com/Question-about-**> >>>> GeoServer-or-GeoTools-support-****for-Oracle-Spatial-**td6283994.**html< >>>> http://osgeo-**org.1803224.n2.nabble.com/**Question-about-GeoServer-or-* >>>> *GeoTools-support-for-Oracle-**Spatial-td6283994.html<http://osgeo-org.1803224.n2.nabble.com/Question-about-GeoServer-or-GeoTools-support-for-Oracle-Spatial-td6283994.html> >>>> > >>>> >>>> >>>> The important fact: >>>> It seems that Oracle uses its temporary table space to create the image. >>>> Unfortunately it does not release this space afterwards and as a >>>> consequence, the temporary table space reaches its limit. >>>> >>>> Please do the following: >>>> Wait for the next geoserver stop and have an Oracle admin ready to look >>>> at >>>> the temporary table space. If it is filled up we may have found the >>>> reason. >>>> >>>> Cheers >>>> Christian >>>> >>>> >>>> >>>> >>>> Zitat von Harikumar Reddy <harik....@gmail.com>: >>>> >>>> >>>> Hi Simone, >>>> >>>>> >>>>> I have imported raster data into oracle spatial 11g r2 as georaster and >>>>> configured with ImageMosaicJDBC plugin datastore. >>>>> >>>>> - Geoserver version is 2.1.0. >>>>> - Connections: 5 >>>>> - GeoServer RAM 4GB >>>>> - JAI Memory 1GB >>>>> - Environment : Linux Cent OS >>>>> - Dervlet container : Tomcat 6.0 >>>>> - deployment environment : Springsource TCserver environment >>>>> - Database : Oracle spatial 11g R2 >>>>> - Raster images type : Georaster (SPOT images) >>>>> - Jai & Jai Image IO are still showing false even after successful >>>>> installation. >>>>> >>>>> I am a pure geotechnician, so i have less knowledge on hardware >>>>> configuration side. Please let me know, if you need any other >>>>> information. >>>>> >>>>> Thanking you, >>>>> >>>>> Regards, >>>>> Hari. >>>>> >>>>> On Fri, Sep 2, 2011 at 10:34 PM, Simone Giannecchini < >>>>> simone.giannecchini@geo-**solu**tions.it <http://solutions.it>< >>>>> simone.giannecchini@**geo-solutions.it<simone.giannecch...@geo-solutions.it> >>>>> >> >>>>> wrote: >>>>> >>>>> Ciao Hari, >>>>> >>>>>> I would need to know a bit more about how you configured this data and >>>>>> about the server config otherwiser I would be alone in the dark. >>>>>> >>>>>> Regards, >>>>>> Simone Giannecchini >>>>>> ------------------------------****------------------------- >>>>>> Ing. Simone Giannecchini >>>>>> GeoSolutions S.A.S. >>>>>> Founder >>>>>> >>>>>> Via Poggio alle Viti 1187 >>>>>> 55054 Massarosa (LU) >>>>>> Italy >>>>>> >>>>>> phone: +39 0584 962313 >>>>>> fax: +39 0584 962313 >>>>>> mob: +39 333 8128928 >>>>>> >>>>>> http://www.geo-solutions.it >>>>>> http://geo-solutions.blogspot.****com/<http://geo-solutions.** >>>>>> blogspot.com/ <http://geo-solutions.blogspot.com/>> >>>>>> http://www.youtube.com/user/****GeoSolutionsIT<http://www.youtube.com/user/**GeoSolutionsIT> >>>>>> <http://www.**youtube.com/user/**GeoSolutionsIT<http://www.youtube.com/user/GeoSolutionsIT> >>>>>> > >>>>>> http://www.linkedin.com/in/****simonegiannecchini<http://www.linkedin.com/in/**simonegiannecchini> >>>>>> <http://www.**linkedin.com/in/**simonegiannecchini<http://www.linkedin.com/in/simonegiannecchini> >>>>>> > >>>>>> >>>>>> http://twitter.com/simogeo >>>>>> >>>>>> ------------------------------****------------------------- >>>>>> >>>>>> >>>>>> >>>>>> On Fri, Sep 2, 2011 at 5:50 PM, Harikumar Reddy <harik....@gmail.com> >>>>>> wrote: >>>>>> > Hi Simone, >>>>>> > >>>>>> > Thankyou for quick reply. >>>>>> > >>>>>> > I am working directly in production environment (only for imageries). >>>>>> So >>>>>> I >>>>>> > need to inform client priorly. If newer version will surely solve the >>>>>> > problem, then i can request them. For checking locally, we dont have >>>>>> those >>>>>> > imageries with us. We are working through secured gateways. I haven't >>>>>> > observed this problem before in 2.0.2 version. I have configured >>>>>> around >>>>>> 110 >>>>>> > GB SPOT imageries 2 months before (now also i have to remove old and >>>>>> need >>>>>> to >>>>>> > configure same area with updated imageries). Any work around is >>>>>> possible >>>>>> ? >>>>>> > >>>>>> > Could you please suggest me that is it caused due to memory problems >>>>>> > (hardware side or geoserver side). From logs URI not receiving error >>>>>> i >>>>>> have >>>>>> > seen...but i need to investigate this problem. >>>>>> > >>>>>> > Regards, >>>>>> > Hari. >>>>>> > >>>>>> > On Fri, Sep 2, 2011 at 8:11 PM, Simone Giannecchini >>>>>> > <simone.giannecchini@geo-**sol**utions.it <http://solutions.it>< >>>>>> simone.giannecchini@**geo-solutions.it<simone.giannecch...@geo-solutions.it> >>>>>> >> >>>>>> >>>>>> wrote: >>>>>> >> >>>>>> >> Ciao Hari, >>>>>> >> quick suggestion since we fixed a few glitches with raster data in >>>>>> >> 2,1.0, can you try to upgrade to 2.1.1 or even to 2.1.x nightly and >>>>>> >> then check this issues again? >>>>>> >> >>>>>> >> Regards, >>>>>> >> Simone Giannecchini >>>>>> >> ------------------------------****------------------------- >>>>>> >> Ing. Simone Giannecchini >>>>>> >> GeoSolutions S.A.S. >>>>>> >> Founder >>>>>> >> >>>>>> >> Via Poggio alle Viti 1187 >>>>>> >> 55054 Massarosa (LU) >>>>>> >> Italy >>>>>> >> >>>>>> >> phone: +39 0584 962313 >>>>>> >> fax: +39 0584 962313 >>>>>> >> mob: +39 333 8128928 >>>>>> >> >>>>>> >> http://www.geo-solutions.it >>>>>> >> http://geo-solutions.blogspot.****com/<http://geo-solutions.** >>>>>> blogspot.com/ <http://geo-solutions.blogspot.com/>> >>>>>> >> >>>>>> http://www.youtube.com/user/****GeoSolutionsIT<http://www.youtube.com/user/**GeoSolutionsIT> >>>>>> <http://www.**youtube.com/user/**GeoSolutionsIT<http://www.youtube.com/user/GeoSolutionsIT> >>>>>> > >>>>>> >> >>>>>> http://www.linkedin.com/in/****simonegiannecchini<http://www.linkedin.com/in/**simonegiannecchini> >>>>>> <http://www.**linkedin.com/in/**simonegiannecchini<http://www.linkedin.com/in/simonegiannecchini> >>>>>> > >>>>>> >>>>>> >> http://twitter.com/simogeo >>>>>> >> >>>>>> >> ------------------------------****------------------------- >>>>>> >> >>>>>> >> >>>>>> >> >>>>>> >> On Fri, Sep 2, 2011 at 2:46 PM, Harikumar Reddy < >>>>>> harik....@gmail.com> >>>>>> >> wrote: >>>>>> >> > Hari >>>>>> > >>>>>> > >>>>>> > >>>>>> ------------------------------****----------------------------**--** >>>>>> ------------------ >>>>>> > Special Offer -- Download ArcSight Logger for FREE! >>>>>> > Finally, a world-class log management solution at an even better >>>>>> > price-free! And you'll get a free "Love Thy Logs" t-shirt when you >>>>>> > download Logger. Secure your free ArcSight Logger TODAY! >>>>>> > >>>>>> http://p.sf.net/sfu/****arcsisghtdev2dev<http://p.sf.net/sfu/**arcsisghtdev2dev> >>>>>> <http://p.sf.**net/sfu/arcsisghtdev2dev<http://p.sf.net/sfu/arcsisghtdev2dev> >>>>>> > >>>>>> > ______________________________****_________________ >>>>>> > Geoserver-users mailing list >>>>>> > Geoserver-users@lists.**source**forge.net <http://sourceforge.net>< >>>>>> Geoserver-users@**lists.sourceforge.net<Geoserver-users@lists.sourceforge.net> >>>>>> > >>>>>> > >>>>>> https://lists.sourceforge.net/****lists/listinfo/geoserver-**users<https://lists.sourceforge.net/**lists/listinfo/geoserver-users> >>>>>> <https://lists.**sourceforge.net/lists/**listinfo/geoserver-users<https://lists.sourceforge.net/lists/listinfo/geoserver-users> >>>>>> > >>>>>> > >>>>>> > >>>>>> >>>>>> >>>>>> >>>>> >>>> >>>> ------------------------------****----------------------------**--**---- >>>> This message was sent using IMP, the Internet Messaging Program. >>>> >>>> >>>> >>>> >>> >> >> >> ------------------------------**------------------------------**---- >> This message was sent using IMP, the Internet Messaging Program. >> >> >> > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------------ Special Offer -- Download ArcSight Logger for FREE! Finally, a world-class log management solution at an even better price-free! And you'll get a free "Love Thy Logs" t-shirt when you download Logger. Secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsisghtdev2dev _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
