After a fresh install of GN 2.8.0 (ANZMEST), on startup I get the following exception:
2013-09-04 10:52:07,797 INFO [jeeves.apphand] - - Database connection on jdbc:oracle:thin:@server.uri:1532:devdb ...
2013-09-04 10:52:07,906 INFO [jeeves.apphand] - jdbc:oracle:thin:@server.uri:1532:devdb is an empty database (Metadata table not found).
2013-09-04 10:52:07,906 INFO [jeeves.apphand] - - SQL create file:D:\geonetwork28\web\geonetwork\WEB-INF/classes/setup/sql/create prefix:create-db- ...
2013-09-04 10:52:09,141 WARN [geonetwork.database] - SQL failure for: CREATE TABLE spatialIndex ( fid int, id varchar2(250), the_geom SDO_GEOMETRY, primary key(fid) ), error is:ORA-00902: invalid datatype
Does GN 2.8 require Oracle Spatial? (hope not, we don't use it)
Or is there some configuration change I need to request our DBAs to make to enable SDO_GEOMETRY?
Or is there a way to force GN to use a shapefile for the spatial index?
Regards
Luke Pinner
If you have received this transmission in error please notify us immediately by return e-mail and delete all copies. If this e-mail or any attachments have been sent to you in error, that error does not constitute waiver of any confidentiality, privilege or copyright in respect of information in the e-mail or attachments.
Please consider the environment before printing this email.
Sorry, forgot to mention... current Oracle version is 10g, but will be upgrading to 11g in the next year.
-----Original Message-----
From: Pinner, Luke [mailto:Luke.Pinner@anonymised.com]
Sent: Wednesday, 4 September 2013 11:01 AM
To: geonetwork-users@lists.sourceforge.net
Subject: [GeoNetwork-users] ORA-00902 invalid datatype after install of GN 2.8.0 (ANZMEST)
After a fresh install of GN 2.8.0 (ANZMEST), on startup I get the following exception:
2013-09-04 10:52:07,797 INFO [jeeves.apphand] - - Database connection on jdbc:oracle:thin:@server.uri:1532:devdb ...
2013-09-04 10:52:07,906 INFO [jeeves.apphand] - jdbc:oracle:thin:@server.uri:1532:devdb is an empty database (Metadata table not found).
2013-09-04 10:52:07,906 INFO [jeeves.apphand] - - SQL create file:D:\geonetwork28\web\geonetwork\WEB-INF/classes/setup/sql/create<file:///D:\geonetwork28\web\geonetwork\WEB-INF\classes\setup\sql\create> prefix:create-db- ...
2013-09-04 10:52:09,141 WARN [geonetwork.database] - SQL failure for: CREATE TABLE spatialIndex ( fid int, id varchar2(250), the_geom SDO_GEOMETRY, primary key(fid) ), error is:ORA-00902: invalid datatype
Does GN 2.8 require Oracle Spatial? (hope not, we don't use it)
Or is there some configuration change I need to request our DBAs to make to enable SDO_GEOMETRY?
Or is there a way to force GN to use a shapefile for the spatial index?
Regards
Luke Pinner
If you have received this transmission in error please notify us immediately by return e-mail and delete all copies. If this e-mail or any attachments have been sent to you in error, that error does not constitute waiver of any confidentiality, privilege or copyright in respect of information in the e-mail or attachments.
Please consider the environment before printing this email.