Software environment

Operating System

Oracle database can run on Linux and Windows platforms, and the default port is 1521.

Software version

SuperMap GIS Server supports Oracle Database 9i/10g/11g/12c.

Oracle Installation and Configuration

This article takes Oracle Database 11g R2 as an example to introduce the installation and configuration methods of Oracle:

Go to the Oracle official website to download the Oracle Database 11g R2 compressed package corresponding to your operating system, and extract the two compressed packages to the same directory.

Install Oracle

The Oracle installation process varies depending on the type of operating system you are using. Please refer to the official Oracle installation guide ( https://docs.oracle.com/cd/E11882_01/nav/portal_11.htm ) for the specific process. When installing, remember to set the global database name (if not configured, the default value is orcl).

Log in to Oracle

Log in to Oracle as an administrator with the following command:

sqlplus / as sysdba

Note: If you are installing an Oracle database on a Linux system, you need to log in to Linux using the Oracle user.

Create a tablespace

Create the tablespace with the following command:

create tablespace [tablespace name] datafile '[storage path]' size [tablespace size] autoextend on next [auto extend size] maxsize [maximum size of tablespace] 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 by using the following command:

create temporary tablespace [tablespace name] tempfile '[storage path]' size [tablespace size] autoextend on next [auto extend size] maxsize [maximum tablespace 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;

Create a user

After creating the tablespace, create the users associated with the tablespace by using 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;

Authorized user

After the created user is associated with the tablespace, grant the user permissions with the following command:

grant connect, resource, dba to [user name];

For example:

grant connect,resource,dba to root;

Add the driver package

After configuration completed by following the above steps, you can use Oracle in iServer/iPortal/iEdge to store security information. Please refer to the security info storage for the specific configuration method. In addition, you can use the Oracle stores portal data in iPortal. Please refer to Portal Data Storage Configuration for the specific configuration method.