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

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


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

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


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

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


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.


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.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


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

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:http://www.heiqu.com/18275.html