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, <christian.muel...@nvoe.at> 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 <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-**<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 <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 <http://geo-solutions.it><
>>>>>> simone.**giannecch...@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://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 <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 <http://geo-solutions.it><
>>>>>>> simone.**giannecch...@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://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 <
>>>>>>> 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>
>>>>>>> >
>>>>>>> <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-**us...@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>
>>>>>>> >
>>>>>>> <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.
>
>
>
------------------------------------------------------------------------------
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
