[Geoserver-users] GeoServer and Oracle

Charlotte_Toma_Where · September 20, 2019, 10:36am

Hello,

i would like to know which versions of oracle database are compatible
with geoserver.

I know, that you can connect oracle 11 and 12 with Geoserver in version
2.15.2. Now we want to switch to 18c / 19c and i would like to know if
it works.

Any informations regarding working versions can help - i can't find any
relevant infos in the web [1].

[1] https://docs.geoserver.org/latest/en/user/data/database/oracle.html

Greetings from Bonn

Charly

--

******************************************************
Kompaktkurs Aufbau einer GDI mit Open-Source-Software
FOSS Academy Sommerschule: 23. bis 27.09.2019
https://www.foss-academy.com/kompaktkurse.html
******************************************************

Charlotte Toma
GIS-Consultant
WhereGroup GmbH
Eifelstraße 7
53119 Bonn
Germany

Fon: +49 (0)228 / 90 90 38 - 24
Fax: +49 (0)228 / 90 90 38 - 11

info@anonymised.com
www.wheregroup.com
Geschäftsführer:
Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885

Nuno_Oliveira1 · September 24, 2019, 10:54am

Hi,

I only have experience with Oracle 12.x or lower.

That say the best way, except having GeoServer run for a few months using Oracle new versions, is to run GeoTools on line tests [1] against one of those Oracle versions

Best regards,
Nuno Oliveira

[1] http://docs.geotools.org/latest/developer/conventions/test/online.html
On Fri, 2019-09-20 at 12:36 +0200, Charlotte Toma (WhereGroup) wrote:

Hello,

i would like to know which versions of oracle database are compatible
with geoserver.

I know, that you can connect oracle 11 and 12 with Geoserver in version
2.15.2. Now we want to switch to 18c / 19c and i would like to know if
it works.

Any informations regarding working versions can help - i can't find any
relevant infos in the web [1].

[1] [https://docs.geoserver.org/latest/en/user/data/database/oracle.html](https://docs.geoserver.org/latest/en/user/data/database/oracle.html)

Greetings from Bonn

Charly

```
_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:
- Earning your support instead of buying it, but Ian Turton: [http://www.ianturton.com/talks/foss4g.html#/](http://www.ianturton.com/talks/foss4g.html#/)
- The GeoServer user list posting guidelines: [http://geoserver.org/comm/userlist-guidelines.html](http://geoserver.org/comm/userlist-guidelines.html)

If you want to request a feature or an improvement, also see this: [https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer](https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer)

[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@lists.sourceforge.net)
[https://lists.sourceforge.net/lists/listinfo/geoserver-users](https://lists.sourceforge.net/lists/listinfo/geoserver-users)

```

-- 
Regards,
Nuno Oliveira
==
GeoServer Professional Services from the
experts! 
Visit http://goo.gl/it488V for more information.
==

Nuno Miguel Carvalho Oliveira
@nmcoliveira
Software Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax:      +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------

Con riferimento alla normativa sul trattamento dei dati 
personali (Reg. UE 2016/679 - Regolamento generale sulla 
protezione dei dati “GDPR”), si precisa che ogni 
circostanza inerente alla presente email (il suo contenuto, 
gli eventuali allegati, etc.) è un dato la cui conoscenza 
è riservata al/i solo/i destinatario/i indicati dallo 
scrivente. Se il messaggio Le è giunto per errore, è 
tenuta/o a cancellarlo, ogni altra operazione è illecita. 
Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to 
which it is addressed and may contain information that 
is privileged, confidential or otherwise protected from 
disclosure. We remind that - as provided by European 
Regulation 2016/679 “GDPR” - copying, dissemination or 
use of this e-mail or the information herein by anyone 
other than the intended recipient is prohibited. If you 
have received this email by mistake, please notify 
us immediately by telephone or e-mail.

Andrea_Aime4 · September 24, 2019, 12:10pm

Hi,
I don’t know anyone that has tried version 19 yet, but you might do it and report back?
I believe there are Oracle docker images to ease the setup

Cheers
Andrea

···

Regards, Andrea Aime == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.

pradeep2751 · October 23, 2020, 6:08am

hi,

We are migrating Oracle 12C database to 19C and facing performance issue.
Anyone faced similar problem after migration ?

--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html

Imran_Rajjad · October 23, 2020, 2:14pm

Hello Pradeep,

What kind of performance issues are we talking about?

regards,
Imran

···

I.R

pradeep2751 · October 23, 2020, 3:38pm

hi,

Facing performance issue with loading spatial data and any update related to
spatial is taking more time then 12C database. As number of users increases
this even get worse, i have collected some stats which I am attaching with
post.
stats.JPG <http://osgeo-org.1560.x6.nabble.com/file/t383959/stats.JPG>

--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html

Mark_Prins · October 24, 2020, 12:18pm

Really this question should be asked of Oracle, as you haven’t changed your geoserver setup (unless you haven’t told us everything you did).
The codepath for those versions of Oracle in our codebase is identical.

Op vr 23 okt. 2020 16:06 schreef pradeep2751 <pradeepkumawat@anonymised.com>:

hi,

We are migrating Oracle 12C database to 19C and facing performance issue.
Anyone faced similar problem after migration ?

–
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html

Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/

The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Humphries_Graham · October 25, 2020, 10:37pm

Have the DBA's set the SPATIAL_ACCELERATOR option on the Oracle DB?

-----Original Message-----
From: pradeep2751 [mailto:pradeepkumawat@anonymised.com]
Sent: Saturday, 24 October 2020 2:38 AM
To: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer and Oracle

hi,

Facing performance issue with loading spatial data and any update related to spatial is taking more time then 12C database. As number of users increases this even get worse, i have collected some stats which I am attaching with post.
stats.JPG <https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fosgeo-org.1560.x6.nabble.com%2Ffile%2Ft383959%2Fstats.JPG&data=04|01|graham.humphries%40stategrowth.tas.gov.au|264ec66788834a5c3fe808d8776bae23|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637390652637490473|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|3000&sdata=5cIkrl3XWxGePOeIwe8ELeHSGPQLJ%2BMuHF3mgTxoef8%3D&reserved=0>

_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:
- Earning your support instead of buying it, but Ian Turton: https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.ianturton.com%2Ftalks%2Ffoss4g.html%23%2F&data=04|01|graham.humphries%40stategrowth.tas.gov.au|264ec66788834a5c3fe808d8776bae23|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637390652637500468|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|3000&sdata=%2FJoNvQJJuyPyp%2B9t%2FPmK5ni9vhwbPlJRcb3Trw1xY%2Fk%3D&reserved=0
- The GeoServer user list posting guidelines: https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgeoserver.org%2Fcomm%2Fuserlist-guidelines.html&data=04|01|graham.humphries%40stategrowth.tas.gov.au|264ec66788834a5c3fe808d8776bae23|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637390652637500468|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|3000&sdata=2zbK%2F15Po%2FvS0Vmc6IBBV2%2F07gdcFw4nxaZfrB9yI9s%3D&reserved=0

If you want to request a feature or an improvement, also see this: https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fgeoserver%2Fgeoserver%2Fwiki%2FSuccessfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer&data=04|01|graham.humphries%40stategrowth.tas.gov.au|264ec66788834a5c3fe808d8776bae23|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637390652637500468|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|3000&sdata=bDoCzQj8QQaydd4BKTrMXMM8zDAT2SwAYJP7HFQ6VI0%3D&reserved=0

Geoserver-users@lists.sourceforge.net
https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fgeoserver-users&data=04|01|graham.humphries%40stategrowth.tas.gov.au|264ec66788834a5c3fe808d8776bae23|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637390652637500468|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|3000&sdata=GY68j9k2RX6xTjFnRHe%2BSmdF4AAt%2BAQ4%2FZXB445UFAk%3D&reserved=0

________________________________

CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.

pradeep2751 · October 26, 2020, 2:18pm

I spoke to DBA and they have not made any changes to this parameter after
migration but i am sharing value of parameter .

NUM 5077
NAME spatial_vector_acceleration
TYPE 1
VALUE FALSE
DISPLAY_VALUE FALSE
DEFAULT_VALUE FALSE
ISDEFAULT TRUE
ISSES_MODIFIABLE TRUE
ISSYS_MODIFIABLE IMMEDIATE
ISPDB_MODIFIABLE TRUE
ISINSTANCE_MODIFIABLE TRUE
ISMODIFIED FALSE
ISADJUSTED FALSE
ISDEPRECATED FALSE
ISBASIC FALSE
DESCRIPTION enable spatial vector acceleration
UPDATE_COMMENT null
HASH 1203174869
CON_ID 4

--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html

Humphries_Graham · October 26, 2020, 9:31pm

Looks like you need to have your DBA set this to TRUE.

I don't know why Oracle don't have this set to TRUE by default

-----Original Message-----
From: pradeep2751 [mailto:pradeepkumawat@anonymised.com]
Sent: Tuesday, 27 October 2020 1:19 AM
To: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer and Oracle

I spoke to DBA and they have not made any changes to this parameter after migration but i am sharing value of parameter .

NUM 5077
NAME spatial_vector_acceleration
TYPE 1
VALUE FALSE
DISPLAY_VALUE FALSE
DEFAULT_VALUE FALSE
ISDEFAULT TRUE
ISSES_MODIFIABLE TRUE
ISSYS_MODIFIABLE IMMEDIATE
ISPDB_MODIFIABLE TRUE
ISINSTANCE_MODIFIABLETRUE
ISMODIFIED FALSE
ISADJUSTED FALSE
ISDEPRECATED FALSE
ISBASIC FALSE
DESCRIPTION enable spatial vector acceleration
UPDATE_COMMENT null
HASH 1203174869
CON_ID 4

_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:
- Earning your support instead of buying it, but Ian Turton: https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.ianturton.com%2Ftalks%2Ffoss4g.html%23%2F&data=04|01|graham.humphries%40stategrowth.tas.gov.au|3c9b258c905841a258bc08d879bc9fef|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637393198783658605|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|3000&sdata=7zS65V%2BtnovCEWz1t78ajMyf6a9lbdnEc1d34KOBHjw%3D&reserved=0
- The GeoServer user list posting guidelines: https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgeoserver.org%2Fcomm%2Fuserlist-guidelines.html&data=04|01|graham.humphries%40stategrowth.tas.gov.au|3c9b258c905841a258bc08d879bc9fef|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637393198783658605|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|3000&sdata=0jYgjGD7S2bSav21YgM3vNuSTTCikMtQbIJBoiSswKg%3D&reserved=0

If you want to request a feature or an improvement, also see this: https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fgeoserver%2Fgeoserver%2Fwiki%2FSuccessfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer&data=04|01|graham.humphries%40stategrowth.tas.gov.au|3c9b258c905841a258bc08d879bc9fef|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637393198783658605|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|3000&sdata=8IVLdFU6JeXuEhVhY%2Bs8cbNBlCQNVlW51xQraeREV%2FQ%3D&reserved=0

Geoserver-users@lists.sourceforge.net
https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fgeoserver-users&data=04|01|graham.humphries%40stategrowth.tas.gov.au|3c9b258c905841a258bc08d879bc9fef|64ebab8accf44b5ca2d32b4e972d96b2|0|0|637393198783658605|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|3000&sdata=sPFuB3%2BGnQ5wzf3ptJ7uGegPYWW3y3TTU%2F%2FFX%2FMUz2s%3D&reserved=0

________________________________

CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.

Mark_Prins · October 27, 2020, 3:33pm

On 26-10-2020 22:31, Humphries, Graham wrote:

Looks like you need to have your DBA set this to TRUE.

I don't know why Oracle don't have this set to TRUE by default

It's how Oracle make money.

-M