Configuration environment: Workshop Installer: xubobo installation time: 2012-12-20 installation media: ArcSDE10_UNIX_121100.iso2.53G (select lin
Configuration environment: Red Hat Enterprise Linux 5_5 64-bit1_oracle11gr2.zip Virtual Machine configured in installing ArcGIS 10_02 on Linux
Installer: xubobo
Installation time:
Installation media: ArcSDE10_UNIX_121100.iso 2.53G (select linux/oracle11g_64)
ArcSDE installation account: arcsde/arcsde, which belongs to the oinstall group.
Database instance: orcl.
Sde account on the database: sde/sde.
Virtual Machine version: Red Hat Enterprise Linux 5_5 64-bit1_oracle11gr2?arcsde10=arcgisserver10.zip
NOTE: Refer to region.
========================================================== ==================
Install ArcGIS 10 on Linux:
Install ArcGIS 10_01 on Linux install Linux Virtual Machine and yum source configuration http://www.linuxidc.com/Linux/2014-04/99796.htm
Install ArcGIS 10_02 on Linux install Oracle11gR2 http://www.linuxidc.com/Linux/2014-04/99797.htm
Install ArcGIS 10_03 on Linux install ArcSDE 10 http://www.linuxidc.com/Linux/2014-04/99798.htm
Install ArcGIS 10_04 install ArcGIS Server 10 http://www.linuxidc.com/Linux/2014-04/99799.htm on Linux
Install ArcGIS 10.1 _ 01 install ArcGIS Server 10.1 http://www.linuxidc.com/Linux/2014-04/99800.htm on Linux
========================================================== ==================
1: Start the listener as an oracle user, connect to the database, and start the orcl database.
[Root @ localhost ~] $ Su-oracle // switch to oracle user
[Oracle @ localhost ~] $ Lsnrctl start // start the listener [oracle @ localhost ~] $ Sqlplus sys/admin as sysdba // connect to the database
SQL * Plus: Release 11.2.0.1.0 Production on Wed Feb 22 10:59:05 2012
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> startup // start the database
2. Create an arcsde user at the operating system level and set the password to arcsde.
[Root @ localhost ~] # Useradd-d/home/arcsde-G oinstall-m arcsde // create an account and Directory
[Root @ localhost ~] # Passwd arcsde // set the password
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 // switch to a roacle user
[Arcsde @ localhost ~] $
3. Create SDE users, tablespaces, and grant permissions.
Check the related SQL file. Pay attention to the user name and password for logon, and the location of the dbf File (the directory must exist ).
The sorted SQL file (create. SQL) is:
Free onHttp://linux.linuxidc.com/
Both the user name and password areWww.linuxidc.com
The specific download directory is in/July 6,/July 9/Linux install ArcGIS 10_03 install ArcSDE 10
Download Method see http://www.linuxidc.com/Linux/2013-07/87684.htm
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/ To create the sde
Prompt * tablespace and user.
Connect sys/admin @ orcl as sysdba
Prompt * Create the sde tablespace.
Prompt * Before you run this script update LOCATION for the desired datafile pathname.
// Create an SDE tablespace. Note the path.
Create tablespace sde datafile '/home/oracle/app/oracle/oradata/ORCL/sde. dbf' size 400 M extent management local uniform size 512 K;
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;
After logging on to the database as an oracle user, run the SQL file (execute the syntax SQL-> @/home/arcsde/create. SQL, check whether the oracle user has the relevant permissions on the file). The created user is sde and the password is sde.
[Oracle @ localhost ~] $ Sqlplus sys/admin @ orcl as sysdba
SQL * Plus: Release 11.2.0.1.0 Production on Wed Feb 22 11:44:53 2012
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @ home/arcsde/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 *
* 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/ 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
Test sde user connectivity
[Oracle @ localhost ~] $ Sqlplus sde/sde @ orcl
SQL * Plus: Release 11.2.0.1.0 Production on Wed Feb 22 11:46:18 2012
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
3. Install ArcSDE Software
First, insert the ArcSDE into the optical drive, and use the mount command. if conditions permit, you can directly import
[Root @ localhost ~] # Mount/dev/cdrom/mnt/cdrom
Mount: block device/dev/cdrom is write-protected, mounting read-only
Mount:/dev/cdrom already mounted or/mnt/cdrom busy
Mount: according to mtab,/dev/hdc is already mounted on/mnt/cdrom
[Root @ localhost ~] # Cd/mnt/cdrom
[Root @ localhost sde] # ls
Documentation_server htm install_db2.htm install_oracle.htm linux solaris
Hpia IBM install_informix.htm install_postgresql.htm quickstart.htm
Then we run the installation command to prompt you where the software installation media is located and where the software needs to be installed.
[Root @ localhost oracle11g_64] #./install-load
Can you read this line of text?
Is the previous statement legible in your native language? [Yes]
Continue installation with the selected language interaction? [Yes]
If you have read and agree to the terms in the attached License Agreement, enter 'yes' to continue the installation process. Otherwise <回车> Key or enter 'no' to exit the installation process. [no] yes
Press enter to select the default item ,'? 'Help, '^' returns
The previous question or 'q' exits.
Input CD-ROM mount point: [/mediamnt]/mnt/cdrom/linux/oracle11g_64/
Enter the path name of the installation directory: [/opt/sde/linux/oracle11g_64]/home/arcsde/
ArcSDE version 10.0 for Oracle11g-May 20,201 0
--------------------------------------------------
ArcSDE Product
Software Module number to be installed: [all]
Software module selected
--------------------------
You have chosen to install the following software modules
ArcSDE Product
ArcSDE Server
Is this correct? [Yes]
Is the file name listed during installation? [No]
Installing software. Please wait...
Software Installed
Exit...
[Root @ localhost oracle11g_64] #
4. Set Environment Variables
Add arcsde environment variables based on the location of your software installation and Oracle software installation information.
[Arcsde @ localhost ~] $ Vi. bash_profile
#. Bash_profile
# Get the aliases and functions
If [-f ~ /. Bashrc]; then
.~ /. Bashrc
Fi
# User specific environment and startup programs
# Export PATH = $ PATH: $ HOME/bin
Export ORACLE_BASE =/home/oracle/app/oracle
Export ORACLE_HOME = $ ORACLE_BASE/product/11.2.0/dbhome_1
Export ORACLE_SID = orcl
Export TNS_ADMIN = $ ORACLE_HOME/network/admin
Export SDEHOME =/home/arcsde/sdeexe100
Export LD_LIBRARY_PATH = $ SDEHOME/lib:/usr/lib: $ ORACLE_HOME/lib
Export PATH = $ PATH: $ HOME: $ ORACLE_HOME/bin: $ SDEHOME/bin
Modify the environment variable to make it take effect, and then test whether it takes effect.
[Arcsde @ localhost ~] $ Vi. bash_profile
[Arcsde @ localhost ~] $ ../. Bash_profile // you can also use source. bash_profile to make it take effect.
[Arcsde @ localhost ~] $ Echo $ SDEHOME
/Home/arcsde/sdeexe100
[Arcsde @ localhost sdeexe100] $
5. modify configuration file Parameters
Modify the $ SDEHOME/etc/services. sde file under the ArcSDE user to add the Instance name and port number.
[Arcsde @ localhost etc] $ vi services. sde
[Arcsde @ localhost etc] $ more services. sde
/* $ Id: services. sde, v 1.2 01:01:35 donna Exp $ */
# S
# Esri sde Remote Protocol
# Note: uncomment the line below to use ESRI's default port
#
Esri_sde 5151/tcp
Add esri_sde 5151/tcp in the same way as the/etc/services file under the root user
[Root @ localhost ~] # Vi/etc/services