Linux操作系统安装ArcSDE10

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

* Granting the required privileges to the sde user.

Grant succeeded.

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

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

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

Tablespace created.

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.

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

Grant succeeded.

Linux上安装ArcGIS 10_04安装ArcGIS Server 10
http://www.linuxidc.com/Linux/2014-04/99799.htm

exit;

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

Grant succeeded.

* ADMINISTER DATABASE TRIGGER can be revoked after install

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Linux上安装ArcGIS 10.1_01安装ArcGIS Server 10.1
http://www.linuxidc.com/Linux/2014-04/99800.htm

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

SQL>

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

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

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

Grant succeeded.

Grant succeeded.

Linux上安装ArcGIS 10_01安装Linux虚拟机及yum源配置
http://www.linuxidc.com/Linux/2014-04/99796.htm

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

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

* 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.

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

Grant succeeded.

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

Grant succeeded.

Grant succeeded.

[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 ~]$

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

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

* * * * * * * * * * * * * * *
* 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.

SQL>

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

Grant succeeded.

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

Grant succeeded.

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

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

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

Grant succeeded.

Grant succeeded.

Grant succeeded.

Linux上安装ArcGIS 10_03安装ArcSDE 10
http://www.linuxidc.com/Linux/2014-04/99798.htm

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;

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

图片 1

connect sys/oracle@orcl as sysdba

Grant succeeded.

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

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;

Grant succeeded.

User created.

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

Linux上安装ArcGIS
10_02安装Oracle11gR2
http://www.linuxidc.com/Linux/2014-04/99797.htm

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

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

prompt * Granting the required privileges to the sde user.