Hmmm, I would say you are sitting on a time bomb because there is a good chance that the temp space becomes full again.
Do you have a support contract with Oracle giving you the possibility to open a ticket. @Steve, do you have the possibility to open a ticket I fear that this problem will reoccur many times in the future. Christian Zitat von Harikumar Reddy <[email protected]>: > Hi Christian, > > Thankyou for georaster oracle function url. Yesterday, our oracle admin has > not restarted the database after temporary table space creation. He has > restarted the database today. I think now geoserver is working fine., but i > can only confirm myself about the geoserver consistency by observing till > this weekend. > > Regards, > Hari. > > > On Tue, Sep 6, 2011 at 10:58 AM, <[email protected]> wrote: > >> 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<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 <[email protected]>: >> >> 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, <[email protected]> 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 <[email protected]>: >>>> >>>> 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, <[email protected]> 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-**<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-*<http://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<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 <[email protected]>: >>>>>> >>>>>> >>>>>> 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 <http://geo-solutions.it>< >>>>>>> simone.**[email protected]<[email protected]> >>>>>>> > >>>>>>> >> >>>>>>> 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://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.**youtube.com/**user/**GeoSolutionsIT<http://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://www.**linkedin.com/in/****simonegiannecchini<http://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 <[email protected] >>>>>>>> > >>>>>>>> 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 <http://geo-solutions.it>< >>>>>>>> simone.**[email protected]<[email protected]> >>>>>>>> > >>>>>>>> >>>>>>>> >> >>>>>>>> >>>>>>>> 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://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.**youtube.com/**user/**GeoSolutionsIT<http://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://www.**linkedin.com/in/****simonegiannecchini<http://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 < >>>>>>>> [email protected]> >>>>>>>> >> 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> >>>>>>>> > >>>>>>>> <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<http://lists.sourceforge.net> >>>>>>>> <Geoserver-**[email protected]<[email protected]> >>>>>>>> > >>>>>>>> >>>>>>>> > >>>>>>>> > 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> >>>>>>>> > >>>>>>>> <https://lists.**sourceforge.**net/lists/**listinfo/** >>>>>>>> geoserver-users<http://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. >> >> >> > ---------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
