Oracle installation and configuration |
The Oracle database runs on Linux and Windows platforms and the default port is 1521.
SuperMap GIS server supports Oracle Database version 11g or higher..
This article takes Oracle Database 11g R2 as an example to introduce Oracle installation and configuration methods:
Go to the Oracle official website (https://www.oracle.com/downloads/)下, download the Oracle Database 11g R2 archive for your operating system and extract the two archives to the same directory.
Depending on the type of operating system you're using, Oracle's installation process will be different. The specific process can be found in the official Oracle installation guide (https://docs.oracle.com/cd/E11882_01/nav/portal_11.htm). When installing, please remember to set the global database name (if you do not configure, Oracle defaults to orcl).
Log into Oracle as an administrator by using the following command:
sqlplus / as sysdba
Note: If you are installing an Oracle database on a Linux system, you will need to log into Linux using an Oracle user.
Create a tablespace with the following command:
create tablespace [tablespace name] datafile '[storage path]' size [tablespace size] autoextend on next [automatic extension size] maxsize [tablespace maximum size] extent management local;
For example:
create tablespace supermap datafile 'D:\dataBase\Oracle\supermap.dbf' size 128m autoextend on next 32m maxsize 1024m extent management local;
Create a temporary tablespace with the following command:
create temporary tablespace [tablespace name] tempfile '[storage path]' size [tablespace size] autoextend on next [automatic extension size] maxsize [tablespace maximum size] extent management local;
For example:
create temporary tablespace supermap_temp tempfile 'D:\dataBase\Oracle\supermap_temp.dbf' size 128m autoextend on next 32m maxsize 1024m extent management local;
After creating the tablespace, create a user associated with the tablespace with the following command:
create user [username] identified by [password] default tablespace [tablespace name] temporary tablespace [temporary tablespace name];
For example:
create user root identified by root default tablespace supermap temporary tablespace supermap_temp;
After creating the user association the tablespace, grant the user permission with the following command:
grant connect,resource,dba to [username];
For example:
grant connect,resource,dba to root;
When Configuring the geoprocessing service in iServer, if you configure an Oracle type database then you need to manually put the relevant ojdbc driver package (the recommended version ojdbc 14-10.2.0.4.0.jar) to %SuperMap iServer_HOME%\webapps\iserver\WEB-INF\lib directory.
After the configurations of the above steps, you can use the Oracle database to store security information in iServer/iPortal/iEdge. For details on how to configure it, see: Security information storage. In addition, you can use Oracle to store portal data in iPortal. For details, see: Portal data storage configuration.