arcsde9安装要点

环境：window2003sp1+oracle9205+arcsde9

1.安装9205
 首先保证windows installer服务启动;
 Oracle应安装"高级安全性"(net manager-本地-概要 中有此下拉选项说明已安装)
 按照文档安装9205;
 如果没有出现oracle监听器服务,执行 lsnrctl start 即可;

2.若安装9205前已经创建了数据库，则需要从9201升级到9205(可选)
 保证system有50M自由空间,XDB有20M自由空间;
 修改参数,使用java pool,shared pool改为150M以上;
 startup migrate;
 spool c:/migrate.log; --记录升级脚本运行日志
 @.../rdbms/admin/catpatch.sql;
 spool off
 @.../rdbms/admin/ultrp.sql; --重新编译对象
 恢复java pool,shared pool的参数设置

3.安装SDE
 DBCA建SDE库;
 执行arcsde的post install过程;
 注意,SDE用户除connect,resource角色外,还有以下权限:
  UNLIMITED TABLESPACE
  CREATE TRIGGER
  CREATE SEQUENCE
  CREATE LIBRARY
  CREATE SESSION
  CREATE TABLE
  CREATE PROCEDURE
 sdesetupora9i -o upgrade ...
 esri_sde服务以"local service"帐号运行（否则本机通过ip地址和5151端口间接连接可能不正常，虽然用机器名可以正常连接）;
 检查services.sde,dbinit.sde,services(win目录下)三个文件

通常以上步骤操作后,服务本机arccatalog中采用直接方式连接应该没有问题了。
间接连接可能还是不正常,原因还没找到. 
从其他机子上采用直接连接(即通过服务名)必须保证客户端和服务器dll版本相同,否则可能报告"License manager not responding"(The direct connect only works when the client and the server is from the same version.)

附:toad采用exp，imp方式转移sde数据库的操作步骤--

1）从源sde服务器的oracle按用户导出sde用户的对象；
2）确保目的sde服务器安装正确（sde库已创建，sde用户权限正确，sde表空间大小不限制）；
3）如果sde用户拥有对象，重新创建sde用户并赋予适当权限；

 DROP USER SDE CASCADE;
 
 CREATE USER "SDE"  PROFILE "DEFAULT"
 IDENTIFIED BY "PASSWORD" DEFAULT TABLESPACE "SDE"
 TEMPORARY TABLESPACE "TEMP"
 ACCOUNT UNLOCK;

 GRANT "DBA" TO "SDE";
 GRANT "CONNECT" TO "SDE";
 GRANT "RESOURCE" TO "SDE";
 GRANT ALTER ANY INDEX TO "SDE" WITH ADMIN OPTION;
 GRANT ALTER ANY TABLE TO "SDE" WITH ADMIN OPTION;
 GRANT ANALYZE ANY TO "SDE" WITH ADMIN OPTION;
 GRANT CREATE ANY INDEX TO "SDE" WITH ADMIN OPTION;
 GRANT CREATE ANY PROCEDURE TO "SDE" WITH ADMIN OPTION;
 GRANT CREATE ANY SEQUENCE TO "SDE" WITH ADMIN OPTION;
 GRANT CREATE ANY TRIGGER TO "SDE" WITH ADMIN OPTION;
 GRANT CREATE ANY VIEW TO "SDE" WITH ADMIN OPTION;
 GRANT CREATE SESSION TO "SDE" WITH ADMIN OPTION;
 GRANT DROP ANY INDEX TO "SDE" WITH ADMIN OPTION;
 GRANT DROP ANY TABLE TO "SDE" WITH ADMIN OPTION;
 GRANT DROP ANY VIEW TO "SDE" WITH ADMIN OPTION;
 GRANT DROP ANY PROCEDURE TO "SDE" WITH ADMIN OPTION;
 GRANT DROP ANY SEQUENCE TO "SDE" WITH ADMIN OPTION;
 GRANT EXECUTE ANY PROCEDURE TO "SDE" WITH ADMIN OPTION;
 GRANT SELECT ANY SEQUENCE TO "SDE" WITH ADMIN OPTION;
 GRANT SELECT ANY TABLE TO "SDE" WITH ADMIN OPTION;
 GRANT UNLIMITED TABLESPACE  TO "SDE" WITH ADMIN OPTION;

4）在目的sde服务器的oracle按用户导入sde用户的对象；