How to view versions and patches for Oracle, sqlserver, and ArcSDE

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 <X64> (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.

SQL Server 2008 R2 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

Version Information of SQL Server 2008

The following table lists the major SQL Server 2008 versions.

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

Version Information of SQL Server 2005

The following table lists the major SQL Server 2005 versions.

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

Version Information of SQL Server 2000

The version number of the sqlservr.exe file is listed in the following table.

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 -------------------------------------------------------------------------------------------------------
All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!
QQ: 78773981
Blog: http://blog.csdn.net/linghe301
WEAVER: http://www.weibo.com/linghe301
Bytes -------------------------------------------------------------------------------------------------------