Introduction to the built-in database client of ArcGIS10.1

Then, what exactly does the database client provided by ArcGIS look like? This CD has been released today, so that you can check it out in advance! The client provided by the CD also includes the traditional supported Oracle, SQLServer,

Then, what exactly does the database client provided by ArcGIS look like? This CD has been released today, so that you can check it out in advance! The client provided by the CD also includes the traditional supported Oracle, SQLServer,

Bytes ------------------------------------------------------------------------------------------

So what exactly does the database client provided by ArcGIS look like? This CD has been released today, so that you can check it out in advance!

The clients provided by the CD include Oracle, SQLServer, PostgreSQL, IBM DB2, and IBM Informix, which are traditionally supported, but do not support cloud computing (I do not know about cloud computing databases ), in addition, there are also 32-bit and 64-bit differences based on the environment, as well as Windows and Linux operating systems.

Note: ArcSDE10.1 is already a 64-bit software. Why do I need a 32-bit database client?

In ArcGIS10.1, ArcGIS Server10.1 is a 64-bit software, but our commonly used software, such as ArcGIS Desktop10.1 and ArcGIS Engine10.1, is still 32Bit, and ArcGIS10.1 is also directly connected by default, therefore, you need to use the database client with the corresponding number of digits to directly connect to ArcSDE10.1 (except for SQL Server)

Take Oracle as an example:

-------------------------- Install the Oracle client in Windows -----------------------------

Oracle client is actually the same as the client under the link, a little difference: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

Name of the Oracle client provided by ArcGIS: instantclient-basic-windows.x64-11.2.0.2.0

Decompress the ZIP package, which contains the following files:

We can see from the above that the version is 11.2.0.2 and it is worth noting that although the name is instanceClient, it is usually about MB with the Oracle client we download ), the installation also has an option for the Instance Client, but we usually install the administrator Version.

I tested that using this Instance Client is not supported (I don't know if it is my problem or I really don't support it. Leave a tail and wait for a while to solve it)

To put it bluntly, the Oracle package provided by ArcGIS is actually a compressed package, which can be directly decompressed during use.

1: select a fixed path and decompress it to the path, for example, C: \ client

2: add the relevant PATH in the WIndows environment variable PATH

3: Create the C: \ client \ network \ admin folder in this path, and then create a TNSNAME. ora to add

ORCL_165 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.220.165)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = orcl)    )  )

In fact, the above is to add the relevant configuration file, the content is to connect to the Database Server

4: record the relevant network service name (orcl_165 in the preceding example) during direct connection to ArcGIS Desktop.

-------------------------- Install the Oracle client and SQLPLUS --------------- in Windows ---------------

We feel that this package is missing a SQLPLUS and we can solve it ourselves.

First, copy related items from the full Oracle client or server (because I have installed and downloaded the complete version of oracle in an environment, copy the relevant files directly ).

Pay special attention to the number of digits

1: Add ORACLE_HOME in the environment variable. Before comparison, add the relevant PATH in PATH.

2: create a new folder C: \ client \ sqlplus \ mesg

Then Copy four files from the mesg file. The four files can be obtained from the client.

• Sp1us. msb
• Sp1zhs. msb
• Sp2us. msb
• Sp2zhs. msb

3: beibeisqlplus.exe and sqlplus. sym to C: \ client (ORACLE_HOME)

Then run the SQL plus command to query the data. The test has passed.

-------------------------- Install the Oracle client in Linux -----------------------------

In Linux, the Oracle client installation package provided by ArcGIS contains an RPM package and a ZIP package.

Decompress the ZIP file and we can see that only the following files are available:

Run the rpm package at the Root user first.

[oracle@RedHat ~]$ rpm -ivh oracle-instantclient11.2-basic-11.2.0.2.0.i386.rpmerror: can't create transaction lock on /var/lib/rpm/__db.000[root@RedHat oracle]# chmod 777 oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm[root@RedHat oracle]# rpm -ivh oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpmPreparing...                ########################################### [100%]   1:oracle-instantclient11.########################################### [100%]

Decompress the ZIP package and configure the related Sqlplus in synchronization.

You can refer to Windows to configure TNSNAME. ora.

Then create the/BIN and/LIB folders.

Copy the corresponding digits of the existing oracle client Linux

/Bin/sqlplus

/Lib/sqlplus.

/Lib/sqlplus. so

Then, all the extracted so files are synchronized to the/lib path. After the files are sorted out, the directory structure is as follows:

Configure related environment variables

PATH=$PATH:$HOME/binexport PATHexport ORACLE_HOME=/home/oracle/instantclient-basic-linux32-11.2.0.2.0/instantclient_11_2PATH=$PATH:$HOME/bin:$ORACLE_HOME/binexport PATHLD_LIBRARY_PATH=/usr/lib:/lib:$ORACLE_HOME/libexport LD_LIBRARY_PATH

After the environment variables take effect, you can use the test.

[oracle@RedHat ~]$ sqlplus sde/sde@orclSQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 18 14:10:38 2012Copyright (c) 1982, 2009, Oracle.  All rights reserved.Connected 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 version;     MAJOR      MINOR     BUGFIX---------- ---------- ----------DESCRIPTION--------------------------------------------------------------------------------   RELEASE SDESVR_REL_LOW---------- --------------        10          0          0 for Oracle11g Build 1937 Tue Aug 16 16:08:18  2011    100001          93001

No problem. The configuration is correct!

If you feel the above is very troublesome, you can download a Complete Oracle Linux client to install

Http://blog.csdn.net/linghe301/article/details/7766472

---------------------------- SQL Server Client -----------------------------

There is nothing to do with SQLServer databases, because ArcGIS Desktop comes with related packages after the Server is installed.

ArcGIS Desktop 10 comes with the Native Client component of SQLServer

However, you still need to install ArcGIS lightning top10.1. If you install ArcGIS lightning top10.1 in a new operating system and directly connect to the SQLServer database, the following error is reported:

Therefore, you still need to install the SQL Server client, and 64-bit clients must be installed on Windows 2008R2. The following problems may occur when installing 32-bit clients.

It can be seen that the difference between SQL Server and Oracle databases is large.

---------------------------- PostgreSQL client -----------------------------

For PostgreSQL, 64-bit database-end installation program (9.0.5) is provided, and related clients are also provided. This client is better, that is, several DLL files. You can copy these DLL files

C: \ Program Files (x86) \ ArcGIS \ topics top10.1 \ bin.

PostgreSQL Windows reference

Please unzip the file and place the libraries in the bin folder of the client application that you would like to use to connect to PostgreSQL 9.0.5.Windows 32-bit PostgreSQL 9.0.5 Client Libraries:Libpq.dllLibiconv-2.dllLibeay32.dllLibintl-8.dllSsleay32.dllPlace these files in the bin folders of the following Windows 32-bit Esri client applications:ArcGIS for Desktop: C:\Program Files\ArcGIS\Desktop10.1\binArcGIS Engine: C:\Program Files\ArcGIS\Engine10.1\binWindows 64-bit PostgreSQL 9.0.5 Client Libraries:Libpq.dllLibeay32.dllLibintl.dllSsleay32.dllPlace these files in the bin folders of the following Windows 64-bit Esri client applications:ArcGIS for Server: C:\Program Files\ArcGIS\Server\bin

PostgreSQL Linux reference

The following RPM packages install PostgreSQL client libraries and checks for dependencies.The client libraries are used when an ArcGIS for Server, ArcGIS Engine or ArcGIS Runtime client is installed on Linux and needs to connect directly to an enterprise geodatabase on PostgreSQLor PostgreSQL database. Install the rpm appropriate to your operating system, and be sure the ArcGIS for Server, ArcGIS Engine and ArcGIS Runtime client's bin directories have access to this library.RHEL 5 32bit PostgreSQL 9.0.5 Client Libraries:postgresql90-libs-9.0.5-1PGDG.rhel5.i386.rpmRHEL 5 64bit PostgreSQL 9.0.5 Client Libraries:postgresql90-libs-9.0.5-1PGDG.rhel5.x86_64.rpmRHEL 6 32bit PostgreSQL 9.0.5 Client Libraries:postgresql90-libs-9.0.5-1PGDG.rhel6.i686.rpmRHEL 6 64bit PostgreSQL 9.0.5 Client Libraries:postgresql90-libs-9.0.5-1PGDG.rhel6.x86_64.rpmThe rpm will install: Libpq.so and check for all necessary dependencies. Have the library be accessible to the bin directory of the following Linux 32-bit Esri client application:ArcGIS Engine: <...>/arcgis/engine10.1/bin 

---------------------------- IBM Client -----------------------------

I will not introduce any other two databases from IBM.

Bytes -------------------------------------------------------------------------------------------------------

Bytes ------------------------------------------------------------------------------------------------------