Linux操作系统安装ArcSDE10

文章由LinuxBoy分享于2019-03-27 12:03:01热评（524）

Linux操作系统安装ArcSDE10

=====================================================

Linux上安装ArcGIS 10安装系列文章：

Linux上安装ArcGIS 10_01安装Linux虚拟机及yum源配置

Linux上安装ArcGIS 10_02安装Oracle11gR2

Linux上安装ArcGIS 10_03安装ArcSDE 10

Linux上安装ArcGIS 10_04安装ArcGIS Server 10

Linux上安装ArcGIS 10.1_01安装ArcGIS Server 10.1

=====================================================

1：首先检查一下在Linux操作系统下Oracle数据库是否能启动，是否能连通等

[oracle@localhost ~]$ sqlplus sys/oracle@orcl as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 22 10:33:47 2012

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

[oracle@localhost ~]$ sqlplus sys/oracle as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 22 10:59:05 2012

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

创建操作系统级别的ArcSDE用户

[root@localhost ~]# user add -d /home/arcsde -G oinstall -m arcsde
-bash: user: command not found
[root@localhost ~]# useradd -d /home/arcsde -G oinstall -m arcsde
[root@localhost ~]# passwd arcsde
Changing password for user arcsde.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@localhost ~]# su - arcsde
[arcsde@localhost ~]$

创建SDE的用户、表空间、赋予权限，查看一下相关的SQL文件

prompt * Granting of permissions by the SYS user in Oracle, on two packages
prompt * to the public role.

grant execute on dbms_pipe to public;
grant execute on dbms_lock to public;

prompt * * * * * * * * * * * * * * *
prompt * ArcSDE NEW INSTALLATION *
prompt * * * * * * * * * * * * * * *

prompt * Connect as system/<password> to create the sde
prompt * tablespace and user.

connect sys/oracle@orcl as sysdba

prompt * Create the sde tablespace.
prompt * Before you run this script update LOCATION for the desired datafile pathname.
//创建SDE表空间，路径需要注意
create tablespace sde
datafile '/opt/oracle/oradata/ORCL/sde.dbf' size 400M
extent management local uniform size 512K;

prompt * Create the sde user
prompt * The password for the sde user is set to "sde". You may
prompt * change this if you wish.

create user sde identified by sde
default tablespace sde temporary tablespace temp;

prompt * Granting the required privileges to the sde user.

grant CREATE SESSION to sde;
grant CREATE TABLE to sde;
grant CREATE PROCEDURE to sde;
grant CREATE SEQUENCE to sde;
grant CREATE TRIGGER to sde;
grant CREATE TYPE to sde;
grant CREATE LIBRARY to sde;
grant CREATE PUBLIC SYNONYM to sde;
grant CREATE OPERATOR to sde;
grant CREATE INDEXTYPE to sde;
grant DROP PUBLIC SYNONYM to sde;
grant CREATE VIEW to sde;
prompt * UNLIMITED TABLESPACE is not required. Grant this privilege
prompt * if you do not wish to explicitly manage and grant tablespace quota to SDE user.
grant UNLIMITED TABLESPACE to sde;
prompt * ADMINISTER DATABASE TRIGGER can be revoked after install
grant ADMINISTER DATABASE TRIGGER to sde;

exit;

执行该SQL语句，得到如下信息

[oracle@localhost ~]$ sqlplus sys/oracle@orcl as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 22 11:44:53 2012

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @ create.sql;
* CREATESDEORACLE.SQL script *
* *
* Purpose: *
* *
* To create the SDE tablespace, the SDE Oracle user *
* and grant privileges to the SDE user *
* *
* NOTES: 1. Before running this script *
* Replace the word LOCATION with the pathname for *
* the sde.dbf datafile to be created. *
* *
* 2. If upgrading remove rem from the grants and *
* revokes in the upgrade section *
* *
* 3. Please use the sys user to run this script. *
* You will also need the system user password *
* *
* Example: *
* % sqlplus "sys as sydba" @createsdeoracle.sql *
* *
* *
**************************************************************
* Granting of permissions by the SYS user in Oracle, on two packages
* to the public role.

Grant succeeded.

* * * * * * * * * * * * * * *
* ArcSDE NEW INSTALLATION *
* * * * * * * * * * * * * * *
* Connect as system/<password> to create the sde
* tablespace and user.
Connected.
* Create the sde tablespace.
* Before you run this script update LOCATION for the desired datafile pathname.

Tablespace created.

* Create the sde user
* The password for the sde user is set to "sde". You may
* change this if you wish.

User created.

* Granting the required privileges to the sde user.

Grant succeeded.

* UNLIMITED TABLESPACE is not required. Grant this privilege
* if you do not wish to explicitly manage and grant tablespace quota to SDE user .

Grant succeeded.

* ADMINISTER DATABASE TRIGGER can be revoked after install

Grant succeeded.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Pr oduction
With the Partitioning, OLAP, Data Mining and Real Application Testing options

推荐文章：

Linux操作系统安装ArcSDE10