Specifics of working with Oracle DBMS

It is allowed to use DBMS Oracle 11g and higher, release not lower than Oracle Standard One, which integrates support for the technology for working with spatial data - Oracle Spatial.

Tables with spatial data should be registered in USER_SDO_GEOM_METADATA properly.

When working with the Oracle DBMS, it is unacceptable to use tables with data to be reflected on the map in the schemes of system users (SYS, etc.), where it is prohibited to add triggers to the tables.

For the program to function, it is required that the user, on whose behalf the connection to the database is made in GIS Panorama, has read access (SELECT) to the following system views and database tables:

• ALL_TAB_COLUMNS;
• USER_TABLES;
• USER_SDO_GEOM_METADATA;
• SDO_COORD_REF_SYS CRS;
• SDO_COORD_AXES AXES;
• SDO_UNITS_OF_MEASURE.

Authorization is also required to execute functions from the packages MDSYS.SDO_UTIL and MDSYS.SDO_CS.

Notes on connecting to Oracle DBMS.

To connect to the Oracle database, a set of Oracle call interface (OCI) libraries is used, thus a connection is established with a type called «easy connect naming» in Oracle terminology (http://docs.oracle.com/cd/B12037_01/network.101/b10775/naming.htm#i498306).

This approach does not require prescribing LISTNER and TNS, it is enough that this type of connection is allowed in the server settings (by default, it is enabled). Enabling this type of connection on the DBMS server is performed through the Oracle Net Manager, or by manually prescribing the EZCONNECT - NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT) parameter in the sqlnet.ora file.

Only the host address, port and database name are used for connection. The latter is specified either as a SID or as a SERVICE_NAME. Both names are specified when creating the database.

The «easy connect naming» type is analogous to the «Basic» connection in SQL Developer.