2024年1月29日发(作者：)
ArcSDE升级Service Pack
-ArcSDE9.3.1升级SP2
补丁概念
在ArcGIS系列软件有一些补丁的概念比较让人郁闷，以ArcSDE9.3为例，在该版本发布之后，Esri公司在该版本后会发布一些免费的Service Pack，这些补丁可以解决ArcSDE9.3的相关Bugs，但是ArcSDE9.3.1相比较9.3算是一个比较大的版本升级，这个升级补丁不会供用户免费下载，需要与相关销售联系才能获得，但是升级到9.3.1之后，还会有相关的SP补丁，可以这么理解，SP理解为小补丁（免费），9.3到9.3.1就理解为大补丁（正版用户可以获得，是否免费不太清楚），以下我们所介绍的都是SP补丁的升级。
参考网址：
/content/patches-and-service-packs?fa=viewPatch&PID=66&MetaID=1623
补丁页面参考
补丁说明
ArcSDE补丁一般包括Windows和Unix操作系统，针对不同的数据库补丁，而且包括相关SDK的补丁，而且会有相关的软件（PatchFinder）查看我们版本打补丁打到多少，升级步骤网址说明的非常清楚，下面笔者就一步步介绍一下升级的步骤。
升级步骤
环境
操作系统：Cent OS 5.5
数据库：Oracle11g(11.2.0.1)
中间件：ArcSDE9.3.1
操作目的：升级9.3.1 SP2
升级前：请备份相关数据
从图片可以看出，目前ArcSDE版本为9.3.1，服务状态为启动状态。
步骤一
下载相关数据库的SP2补丁，上传到CentOS系统上。
步骤二
停止ArcSDE服务
步骤三
提取Tar包
步骤四
下面的操作步骤用户可以一直回车即可。详细如下：
[sde@localhost ~]$ ./applypatch
##############################################################
ESRI installation tool
##############################################################
At any prompt, press the Return key to take the default option
shown in parenthesis or press 'q' to quit the installation process.
Since you are currently running this installation on Linux, you
will only be able to install Linux setups.
The Current Valid Product-Platform Installation(s)
(1) ArcSDE 9.3.1 Service Pack 2 Service Pack for (ArcSDE 9.3.1 Server for Oracle 11g) on
Linux(32-bit) (June 2010)
Please make a selection from the list above [q] (1):
ArcSDE 9.3.1 Service Pack 2 Service Pack for (ArcSDE 9.3.1 Server for Oracle 11g) on
Linux(32-bit) (June 2010)
Is this the correct selection? [y,n,q] (y):
###################################################################
==============================================================
ArcSDE 9.3.1 Service Pack 2 Service Pack for (ArcSDE 9.3.1 Server for Oracle 11g) on
Linux(32-bit) Install (June 2010)
==============================================================
==============================================================
==============================================================
==============================================================
###################################################################
You must have ArcSDE 9.3.1 Server installed before you can apply this Service Pack.
You should install this Service Pack when no one is using ArcSDE 9.3.1 Server.
This Service Pack is not compatible with other versions of ArcSDE.
Your SDEHOME variable is currently set to:
/home/sde/sdeexe93
If you would like to apply the Service Pack to this version,
just press
the installation you would like to update.
Enter path [q] (/home/sde/sdeexe93):
This Service Pack will replace several files in your ArcSDE 9.3.1
Server installation directory. We highly recommend to backup
the original files in case you decide you would like to
revert to them.
You need 28 MBytes to install the Service Pack with the backup.
`y' to backup original files
`n' to overwrite original files
Enter choice [y,n,q] (y):
By default the original files will be backed up in the ArcSDE 9.3.1
installation location. The suffix '.orig' will be appended to
each file. To save these files in a different location, please
enter the path below:
Enter location to backup original files [q] (/home/sde/sdeexe93):
Confirm Settings
==============================================================
Product to update: ArcSDE 9.3.1 Server
Platform to update: Linux 32-bit
Database to update: Oracle 11g
Location to update: /home/sde/sdeexe93
Backup original files: yes
Backup originals in: /home/sde/sdeexe93
`y' to continue with these settings
`c' to change settings
`q' to exit without applying this Service Pack
Enter choice [y,c,q] (y):
Renaming original files ...
Applying the
Verifying Service Pack installation ...
The Service Pack (ArcSDE 9.3.1 Service Pack 2) has been successfully applied to ArcSDE 9.3.1
Server.
步骤五
该步骤只有Oracle数据库才能使用，赋予SDE用户权限，其他数据库可以忽略该步骤。
步骤六
升级相关数据库
步骤七
该步骤只有Oracle数据库才能使用，撤回SDE用户权限，其他数据库可以忽略该步骤。
步骤八
重新启动SDE服务
步骤九
我们需要查看现在是否升级了SP2补丁
上面我们介绍了有专门的补丁可以查看，我们可以下载Unix版本的PatchFinder，查看安装补丁情况。
详细请参考：
[sde@localhost ~]$ ./PatchFinder
###################################################################
==============================================================
Welcome to the ESRI Patch Finder utility
==============================================================
###################################################################
This utility automatically detects which ESRI product is currently
installed on your system. It also detects all currently installed
Service Packs, Hot Fixes and Patches.
At any prompt, press the Return key to accept the default option
shown in parenthesis or press 'q' to quit and exit this utility.
The following products were found on your system.
Select a Product to Search
==============================================================
(1) ArcSDE
Please make a selection from the list above or [q] to quit (1):
Searching ArcSDE ...
**********************ArcSDE install summary:**********************
ArcSDE Oracle_11g (32-bit) 9.3.1 Install Location:
/home/sde/sdeexe93
Service Pack / Patch / Hot Fix Found:
SP-ID: ArcSDE 9.3.1 Service Pack 2
Date Installed: 09/23/10 11:18:35
*******************************************************************
说明一下：关于ArcGIS的SP补丁，如果需要打补丁，用户可以选择最新的补丁，如果我们升级ArcSDE9.3.1的SP补丁，我们只需打SP2补丁，不用先打SP1补丁再打SP2补丁。
说明
该文档为作者在学习ArcGIS的一些笔记（自己学习、ArcGIS帮助、网络资源、高手请教相结合），难免有一些表达不全面或者理解有出入的，还请各位多多指教！
广告博客
/?uid-121719 ：欢迎访问GIS博客
By Lish
献给永远的门神-GIGI
发布评论