When we install ArcSDE, we first need to check the system requirements. Only in this way can we ensure that our server environment runs stably. The following describes how to view the corresponding installation versions in different databases, and related installation supplements
When we install ArcSDE, we first need to check the system requirements. Only in this way can we ensure that our server environment runs stably. The following describes how to view the corresponding installation versions in different databases, and related installation supplements
When we install ArcSDE, we first need to check the system requirements. Only in this way can we ensure that our server environment runs stably. The following describes how to view the corresponding installation versions in different databases, and related installation patches.
Oracle
It is very easy to view the Oracle version
C: \ Users \ gis> sqlplus sde/sde @ orclSQL * Plus: Release 11.2.0.1.0 Production on Tuesday August 30 13:36:20 2011 Copyright (c) 1982,201 0, Oracle. all rights reserved. connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select * from v $ version; BANNER implements Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionPL/SQL Release 11.2.0.1.0-ProductionCORE 11.2.0.1.0 ProductionTNS for 64-bit Windows: Version 11.2.0.1.0-ProductionNLSRTL Version 11.2.0.1.0-Production
With this statement, we can know the current version, bit, Enterprise Edition or Standard Edition of the Oracle database. In fact, it is more convenient to directly enter Sqlplus and press Enter.
For Oracle, see XX. XX. X. X (11.2.0.1) without patching)
The first two are marked as Oracle's major version 11 GB.
The third digit indicates the R2 version.
The fourth digit is the patch number (for example, 10.2.0.1, 10.2.0.3, 11.1.0.6, 11.1.0.7, 10.2.0.4, 10.2.0.5, and 11.2.0.2)
SQL Server
In SQL Server, the version is similar.
C:\Documents and Settings\Administrator>sqlcmd -U sa -P esrichina1> select @@version2> go--------------------------------------------------------------------------------Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2
(Build 3790: ServicePack 2) (Hypervisor)
The SQL Server version is similar to that of Oracle. You can use Sqlcmd to view the SQL Server 2008 R2 SP2 64Bit.
Let's take a look at this version: 10.50.1600.1
10: Indicates version 2008, 9 indicates version 2005, and 8 indicates version 2000.
50: indicates the R2 version, and 00 indicates the non-R2 version.
1: indicates that no patch is installed. If 2 is used, the Sp1 Patch is applied. If 3 is used, the Sp2 patch is applied, and so on.
600: indicates the relevant hotfix version. We must check this version for upgrade, backup, and recovery, only data of the same version can be recovered (backup files of the same version.
The following table lists the major versions of SQL Server 2008 R2.
Release |
Product Version |
Service Pack 1 of SQL Server 2008 R2 |
10.50.2500.0 |
SQL Server 2008 R2 RTM |
10.50.1600.1 |
The following table lists the major versions of SQL Server 2008.
Release |
Product Version |
SQL Server 2008 service package 2 |
10.00.4000.00 |
SQL Server 2008 Service Package 1 |
10.00.2531.00 |
SQL Server 2008 RTM |
10.00.1600.22 |
The following table lists the major versions of SQL Server 2005.
Release |
Product Version |
Service Pack 4 of SQL Server 2005 |
9.00.5000.00 |
In Service Pack 3 of SQL Server 2005 |
9.00.4035 |
SQL Server 2005 service package 2 |
9.00.3042 |
SQL Server 2005 Service Package 1 |
9.00.2047 |
SQL Server 2005 RTM |
9.00.1399 |
The version number of the sqlservr.exe file is listed in the lower table of SQL Server 2000.
Release |
Product Version |
SQL Server 2000 Service Pack 4 |
8.00.2039 |
ServicePack 3A of SQL Server 2000 |
8.00.760 |
In Service Pack 3 of SQL Server 2000 |
8.00.760 |
SQL Server 2000 Service Package 2 |
8.00.534 |
SQL Server 2000 Service Package 1 |
8.00.384 |
SQL Server 2000 RTM |
8.00.194 |
ArcSDE
C:\Users\gis>sdesetup -o list -d oracle11g -s lish -p sdeESRI ArcSDE Server Setup Utility Tue Aug 30 13:42:27 2011----------------------------------------------------------------SDE Server at Rev: 10.0.0. for Oracle11g Build 1343 Thu Feb 17 11:45:42 2011
For the major version of ArcSDE, we can use the Sde command to query. We all know that we can use the PatchFind tool to check whether our ArcSDE has been patched with SP, if you didn't have the software at the time and the service was not connected to the Internet, you can use the registry in Windows to check whether our ArcSDE has been patched, you can view all the specific patches. :
Bytes -------------------------------------------------------------------------------------------------------
QQ: 78773981
Blog: http://blog.csdn.net/linghe301
WEAVER: http://www.weibo.com/linghe301
Bytes -------------------------------------------------------------------------------------------------------