search
HomeDatabaseMysql TutorialArcSDE和Geodatabase10.1抢先版谍照介绍(2)ArcSDE10.1安装

前几天刚拿到ArcSDE10.1Beta的安装介质,就迫不及待的对ArcSDE进行安装,但是在这些过程之前经历了一个……的梦魇(这些省略号记录了倒腾虚拟机、数据库一些恶心的事情,让我郁闷了一天),下面就介绍一下ArcSDE10.1的安装吧。 我使用的是Oracle数据库,在安

ArcSDE和Geodatabase10.1抢先版谍照介绍(2)ArcSDE10.1安装


      前几天刚拿到ArcSDE10.1Beta的安装介质,就迫不及待的对ArcSDE进行安装,但是在这些过程之前经历了一个……的梦魇(这些省略号记录了倒腾虚拟机、数据库一些恶心的事情,让我郁闷了一天),下面就介绍一下ArcSDE10.1的安装吧。

      我使用的是Oracle数据库,在安装完Oracle服务器端后,我就迫不及待的安装ArcSDE软件,当启动软件安装向导时候,我发现了一个问题,如下图:

ArcSDE和Geodatabase10.1抢先版谍照介绍(2)ArcSDE10.1安装

       软件安装分(application Server和Command line tools),这让我很不解,继续安装,软件安装结束了,我就等着久违的post,但是等了一会,竟然没有post,当我还以为是不是这是beta版本的时候,没有关系,没有post,我可以手动来创建,当我废了九牛二虎之力将表空间,用户,权限搞定的时候,我需要创建Sde Schema的时候,我傻眼了:

C:\Users\esrichina>sdesetup-----------//竟然没有install命令
ArcSDE 10.1 Setup
Setup    Administration Utility
-----------------------------------------------------
-o delete    -d{ORACLE10G|ORACLE11G}
            [-H<sde_directory>] [-u <db_admin_user>] [-p<db_admin_password>]
            [-i<master_geodatabase_service>[:<user_schema>]] [-N] [q]
-o list      -d{ORACLE10G|ORACLE11G|SQLSERVER|DB2|DB2ZOS|INFORMIX|POSTGRESQL}
            [-H <sde_directory>][-u <db_admin_user>] [-p <db_admin_password>]
            [-D <database>][-s <datasource>]
            [-i<master_geodatabase_service>[:<user_schema>]] [-q]
-o update_key
             -d{ORACLE10G|ORACLE11G|SQLSERVER| DB2|DB2ZOS|INFORMIX|POSTGRESQL}
             -l <key> [-u<db_admin_user>] [-p <db_admin_password>]
            [-H<sde_directory>] [-D <database>] [-s <datasource>] [-N]
            [-i<master_geodatabase_service>[:<user_schema>]] [-q]
-o install_st_raster
             -d {ORACLE10G|ORACLE11G|SQLSERVER|POSTGRESQL}
            [-H<sde_directory>] [-u <db_admin_user>] [-p<db_admin_password>]
            [-D <database>][-s <datasource>] [-N] [-l <key>] [-q]</key></datasource></database></db_admin_password></db_admin_user></sde_directory></user_schema></master_geodatabase_service></datasource></database></sde_directory></db_admin_password></db_admin_user></key></user_schema></master_geodatabase_service></datasource></database></db_admin_password></db_admin_user></sde_directory></user_schema></master_geodatabase_service></db_admin_password></db_admin_user></sde_directory>

一个念头闪现在脑海,在前面的一个讲座中好像Post集成到了ArcToolbox工具中了:

ArcToolbox-Data Mangement Tools-Geodatabase administration-CreateEnterprise Geodatabase,

ArcSDE和Geodatabase10.1抢先版谍照介绍(2)ArcSDE10.1安装

点击打开,填写好相关参数,点击确认,系统提示:

Cannot connect to database because the database client software failed toload.Be suer that the database client software is installed and configuredcorrectly

       从上面的提示很容易看到,我们需要安装数据库的客户端。

        从上面的DBMS Type知道目前这个功能只支持(oracle、SQL Server、Postgresql),Instance填写(使用客户端配置的Netservicename),其实核心和原来的Post Installation是一样的,也是先连接sys用户,然后创建sde表空间,创建sde用户,赋予sde权限,创建sde schema等,我们点击确认。

Executing: CreateEnterpriseGeodatabase Oracle orcl # DATABASE_AUTH sys***** SDE_SCHEMA sde ***** sde C:\Users\esrichina\Desktop\ArcSDE10.ecp
Start Time: Tue Aug 09 15:02:37 2011
User has privileges required to create database objects.
Tablespace already exists.
Geodatabase admin user already exists.
Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
Connected RDBMS instance is not setup for ESRI spatial typeconfiguration. [ (Unable to determine current version of ST_SHAPELIB
The latest ST_GEOMETRY and dependent libraries need
to be copied to the correct software location.
Please consult ArcSDE for Oracle Installation Guide
for further details.
)]
Created geodatabase tables and stored procedures.
Finished creating geodatabase schema.
Succeeded at Tue Aug 09 15:03:32 2011 (Elapsed Time: 55.00 seconds)

       上面的库我反反复复的做过几次,所以在这次创建过程中,如果已经存在的比如说表空间用户等就会提示已存在,也会提示你要引用ST_SHAPELIB,但是这个我仍然很担心如果在创建Schema出现问题这该怎么办呢?

       安装到现在,其实使用ArcCatalog就可以直连数据库了,如下:

ArcSDE和Geodatabase10.1抢先版谍照介绍(2)ArcSDE10.1安装

        现在ArcGIS10.1的连接设置为使用服务连接使用application Server这是个通用的使用服务连接的界面,直连就选择不同的数据库,不再需要特殊的设置什么如原来直连SQLServer实例名填写sde:sqlserver:servername等,现在只需要填写,系统内部就会自动转换进行直连了,这样降低了直连门槛。

         那么需要服务连接时,就需要使用sde命令来创建服务启动服务了,这个大家应该比较熟悉,就不做介绍了。

总结一下

      个人感觉,新版本在ArcSDE安装方面,虽然说在桌面上集成了Post 功能,但是放弃了原有的post installation,这点让习惯于原来安装的用户很难接受,而且不知道出于什么考虑,连sdesetup –o install的命令就直接给去掉了,现在ArcSDE的安装必须安装ArcGIS Desktop,必须安装数据库的客户端,环境比以前要求的苛刻的多。

      而且原来在Post的过程中用户也可以自定义自己的dbtune.sde,giomgr.def这些配置文件,但是在新版本中就根本不提供这些文件的导入界面了。

       关于注册文件,由原来的ArcSDE9的ecp文件,到ArcSDE10的prvc文件,现在ArcSDE10.1注册只有一个注册文件界面(应该还是ecp文件,或者prvc还要转换为ecp),这点感觉又回到从前了。

       关于数据连接方面感觉做的还是有进步的,分开了服务连接和直连,而且直连不需要用户再记忆很复杂的直连实例格式,但是感觉这个界面是不是少了一个数据连接测试按钮啊。

        在更新注册文件时,用户也不需要非要掌握sde命令来更新了,ArcToolbox提供了Enable Enterprise Geodatabase直接进行更新注册文件,非常方便。

关于ArcSDE软件安装界面上面的那个Command line tools,目前还不知道为什么要把这块单独拿出来用。

       差点忘记了还有一个最重要的点没有说,ArcSDE10.1都是64Bit的,所以用户的操作系统、数据库(对Oracle来说数据库客户端需要32bit)都需要安装64Bit的才可以。


PS:(更新至2011年8月11日)

刚看到帮助上对Command Line Tool的说明是如果你不想使用ArcSDE服务连接,但是又希望使用ArcSDE命令,就可以只安装这个包就可以了。

注意

         因为都是beta版本,大家看到这篇文章仅仅了解就可以了,由于笔者刚刚接触这个软件,有些新功能可能并未发现或者理解有出入,这个请大家见谅!

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
MySQL's Place: Databases and ProgrammingMySQL's Place: Databases and ProgrammingApr 13, 2025 am 12:18 AM

MySQL's position in databases and programming is very important. It is an open source relational database management system that is widely used in various application scenarios. 1) MySQL provides efficient data storage, organization and retrieval functions, supporting Web, mobile and enterprise-level systems. 2) It uses a client-server architecture, supports multiple storage engines and index optimization. 3) Basic usages include creating tables and inserting data, and advanced usages involve multi-table JOINs and complex queries. 4) Frequently asked questions such as SQL syntax errors and performance issues can be debugged through the EXPLAIN command and slow query log. 5) Performance optimization methods include rational use of indexes, optimized query and use of caches. Best practices include using transactions and PreparedStatemen

MySQL: From Small Businesses to Large EnterprisesMySQL: From Small Businesses to Large EnterprisesApr 13, 2025 am 12:17 AM

MySQL is suitable for small and large enterprises. 1) Small businesses can use MySQL for basic data management, such as storing customer information. 2) Large enterprises can use MySQL to process massive data and complex business logic to optimize query performance and transaction processing.

What are phantom reads and how does InnoDB prevent them (Next-Key Locking)?What are phantom reads and how does InnoDB prevent them (Next-Key Locking)?Apr 13, 2025 am 12:16 AM

InnoDB effectively prevents phantom reading through Next-KeyLocking mechanism. 1) Next-KeyLocking combines row lock and gap lock to lock records and their gaps to prevent new records from being inserted. 2) In practical applications, by optimizing query and adjusting isolation levels, lock competition can be reduced and concurrency performance can be improved.

MySQL: Not a Programming Language, But...MySQL: Not a Programming Language, But...Apr 13, 2025 am 12:03 AM

MySQL is not a programming language, but its query language SQL has the characteristics of a programming language: 1. SQL supports conditional judgment, loops and variable operations; 2. Through stored procedures, triggers and functions, users can perform complex logical operations in the database.

MySQL: An Introduction to the World's Most Popular DatabaseMySQL: An Introduction to the World's Most Popular DatabaseApr 12, 2025 am 12:18 AM

MySQL is an open source relational database management system, mainly used to store and retrieve data quickly and reliably. Its working principle includes client requests, query resolution, execution of queries and return results. Examples of usage include creating tables, inserting and querying data, and advanced features such as JOIN operations. Common errors involve SQL syntax, data types, and permissions, and optimization suggestions include the use of indexes, optimized queries, and partitioning of tables.

The Importance of MySQL: Data Storage and ManagementThe Importance of MySQL: Data Storage and ManagementApr 12, 2025 am 12:18 AM

MySQL is an open source relational database management system suitable for data storage, management, query and security. 1. It supports a variety of operating systems and is widely used in Web applications and other fields. 2. Through the client-server architecture and different storage engines, MySQL processes data efficiently. 3. Basic usage includes creating databases and tables, inserting, querying and updating data. 4. Advanced usage involves complex queries and stored procedures. 5. Common errors can be debugged through the EXPLAIN statement. 6. Performance optimization includes the rational use of indexes and optimized query statements.

Why Use MySQL? Benefits and AdvantagesWhy Use MySQL? Benefits and AdvantagesApr 12, 2025 am 12:17 AM

MySQL is chosen for its performance, reliability, ease of use, and community support. 1.MySQL provides efficient data storage and retrieval functions, supporting multiple data types and advanced query operations. 2. Adopt client-server architecture and multiple storage engines to support transaction and query optimization. 3. Easy to use, supports a variety of operating systems and programming languages. 4. Have strong community support and provide rich resources and solutions.

Describe InnoDB locking mechanisms (shared locks, exclusive locks, intention locks, record locks, gap locks, next-key locks).Describe InnoDB locking mechanisms (shared locks, exclusive locks, intention locks, record locks, gap locks, next-key locks).Apr 12, 2025 am 12:16 AM

InnoDB's lock mechanisms include shared locks, exclusive locks, intention locks, record locks, gap locks and next key locks. 1. Shared lock allows transactions to read data without preventing other transactions from reading. 2. Exclusive lock prevents other transactions from reading and modifying data. 3. Intention lock optimizes lock efficiency. 4. Record lock lock index record. 5. Gap lock locks index recording gap. 6. The next key lock is a combination of record lock and gap lock to ensure data consistency.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: How To Unlock Everything In MyRise
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

DVWA

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

Atom editor mac version download

Atom editor mac version download

The most popular open source editor