Oracle installation and configuration |
Oracle database can run on Linux and Windows platforms, and the default port is 1521.
SuperMap GIS Server supports Oracle Database 9i/10g/11g/12c.
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.
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 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 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;
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;
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;
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.