ArcGIS 10.2 Link 64-bit Oracle Database

From: 59544858#21-so far, 32 clients have been installed.

• Introduction
• Installing ORACLE32-bit clients
  • 1 So far, the 32-bit client has been installed.
• ArcGIS Connects to Oracle database

1. Introduction

In some cases we need to put the spatial data into the database, the use of databases in the company Oracle or more, but when people want to use ArcGIS linked Oracle databases encounter a variety of problems, for beginners, the use of ArcGIS linked Oracle database is simply a nightmare, In this blog, we will explain how to use the ArcGIS linked Oracle database.

ArcGISclients are basically 32-bit, so when we link the database need to ensure that the database client is 32-bit, but in the company database server is generally 64-bit, if our database is 64-bit, then we need to install 32-bit client (Just install the 32-bit client, and our database is still 64-bit, if your database is 32-bit, you do not need to install), how to install 64-bit Oracle database, you can view this blog: 64-bit Oracle Database installation
Next we'll install the 32-bit client and then use ArcGIS to link our Oracle database

2. Install the ORACLE32-bit client

• First we download the 32-bit client, then unzip the compressed packet (note: 32-bit client: ORACLE32-bit client)

• Click setup Install 32-bit client, select the installation type

• Select the installation address of the client (note: The default address is installed and the software automatically finds the address of the Oracle Server installation)

• Click Next to complete the installation

• Locate the client installation address that came with Oracle (my: D:\app\wpx\product\11.2.0\dbhome_1 )
• Copy the configuration from the client (64-bit client) to the 32-bit client (note: The address of the client and the 32-bit client)

2.1 So far 32 clients have installed 3. ArcGIS Connects to Oracle database

• Open arcmap-> Open Arctoolbox

• Create an enterprise-level database

• Set parameters for the database (note: The license file is: ECP file)

• Click OK to create the success

• Link Oracle Database (click Create DATABASE link)

• Fill in the connection information

• Link successful

ArcGIS 10.2 Link 64-bit Oracle Database