Oracle Database Connectivity

When installing SIS Desktop, you can also instal the Cadcorp Oracle Instant Client for connecting to Oracle databases.

Note: This feature requires at least 11MB on your hard drive.

Alternatively you can use your own Oracle client software. This must be properly configured to allow Cadcorp SIS Desktop to store and retrieve data from Oracle.

Using the standard Oracle Client

For Cadcorp SIS Desktop to store and retrieve data from Oracle, the client PC needs to have a properly configured Oracle client installed.

When installing the Oracle client ensure the Administrator level of the client is installed.

Once the Oracle client software has been installed the Local Net Service Name needs to be configured to connect to the database, see below. This task is usually carried out by the database administrator.

Note: The Oracle client version should match the database version.

Setting the Local Net Service Name

The Oracle client needs to be configured so that it can connect to the database. The Oracle Net Configuration Assistant can be used to create a Local Net Service Name:

Note: Contact your database administrator for help in setting this up.

Oracle Locator and Spatial

Location-based capabilities are available in Oracle as either Locator or Spatial.

Oracle Locator

Oracle Locator is a default component of all Oracle databases. Locator allows spatial data to be stored and spatially manipulated in the Oracle database. SIS Desktop 9 is compatible with the following features of Oracle Locator:

Supports geometries such as Points, LineStrings and Polygons
Spatial indexing – allows rapid access to data
Spatial operators – allows geometry interaction analysis to be done such as find features that intersect one another.

Locator is a feature of the following ‘flavours’ of the Oracle Database:

Express Edition - This is a free download that may be used on a 1 CPU box only. The database is restricted in size to 4GB and will address no more than 1GB of RAM.
Standard Edition - This edition is not restricted in terms of database size. The maximum addressable RAM is restricted only by the operating system. Standard Edition One may be deployed on a server with a maximum capacity of two occupied processor sockets.
Standard Edition One - This edition is not restricted in terms of database size. The maximum addressable RAM is restricted only by the operating system. Standard Edition One may be deployed on a server with a maximum capacity of four occupied processor sockets.
Enterprise Edition - This edition is not restricted in terms of database size. The maximum addressable RAM is restricted only by the operating system. There is no upper limit to the number of processors that may be deployed to run the Enterprise Edition.

All the above editions of Oracle are compatible with SIS Desktop 9. Users should contact their Oracle supplier for specific licensing information. The spatial data is stored is stored in an Oracle data type called SDO_Geometry.