Direct Connection configuration of ArcSDE10.x for Oracle client

With the release of ArcGIS10.1, more users gradually accept the use of ArcSDE for direct connection, not only because direct connection is a trend (service connections will be discarded later ), more importantly, the direct connection performance is more efficient.

Note: Anyone says their 10. the x environment requires service connection as an excuse. Either they feel that the current environment is still in use, they do not want to make a mess, they are afraid of problems, or the developers are too lazy to give it to you, currently, the only service connection that I know must be used is that ArcGIS9.x cannot use a direct connection to create a User Schema. Therefore, we recommend that you use direct connections, especially in ArcGIS10.x.

Tip: if you use a direct connection to create a User Schema of version 9.3, the following error is prompted: "Install/Upgrade/Delete has to be saved med by instance schema owner"

ArcGIS9.3.x help: Be sure you specify the schema. if it is not specified and only a port number is provided, the SDE schema is used by default. since the geodatabase in the SDE schema already exists, executing the sdesetup-o install command will upgrade the SDE geodatabase.

The database client is required to use direct connection, and many Oracle databases are used by users. So let's talk about direct connection to the Oracle database environment today.

For more information, see:

ArcGIS10.1 built-in database client Introduction: http://blog.csdn.net/linghe301/article/details/8081688

----------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

Blog: http://blog.csdn.net/linghe301

----------------------------------------------------------------------------------

1: When the Oracle10g client is used

Note the following before using the Oracle10g client:If your ArcGIS Desktop software is installed on a 64-bit operating system, it is installed on C: \ Program Files (x86) by default because the Desktop is 32Bit) \ ArcGIS \ Desktop10.2 path, then this "()" may have a big problem, the user can use PL/SQL or Sqlplus can be connected normally, however, if you directly connect to the desktop with the same input parametersOra-12154Error. This is because of the brackets.

Solution:

A: The desktop is installed in a path ().

B: select a client of Oracle11g or a later version.

----------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

Blog: http://blog.csdn.net/linghe301

----------------------------------------------------------------------------------

2: When the Oracle11g client is used

In ArcGIS10.1, the desktop is 32Bit and the Server is 64Bit. Many users install these two software on one Server, therefore, the problem that 32-bit and 64-bit Oracle clients need to be installed simultaneously occurs.

More references: ArcGIS10.1 story: http://blog.csdn.net/linghe301/article/details/8139346

This will undoubtedly add a lot of burden, so Esri recommends that you use the InstanceClient of Oracle. In fact, if you are a genuine user, Esri will also attach the relevant installation CD, which contains this software.

Http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html

You only need to download and decompress the 32Bit and 64Bit software to any place.

Then add the path to the environment variable.

In this way, users no longer need to worry about finding Oci. dll of Oracle with different digits, avoiding some inexplicable errors.

----------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

Blog: http://blog.csdn.net/linghe301

----------------------------------------------------------------------------------

If you download the most simplified InstantClient, Netservicename cannot be configured by default. You can use the EZConnect Statement of Oracle to replace the network service name.

EZConnect requires you to know the IP address and Instance name of the remote database server.

Writing rules: Server IP: Oracle port number/Instance name, for example, 192.168.1.1: 1521/orcl. Generally, the default port number of Oracle 1521 is accepted. If it is not modified, you can leave it blank.

Of course, EZCONNECT cannot be disabled in the Sqlnet. ora file of E: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN on the Oracle server.

# sqlnet.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

----------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

Blog: http://blog.csdn.net/linghe301

----------------------------------------------------------------------------------

Other notes: Oracle software has many problems. If you cannot solve the problem, check whether the problem exists in Windows.

1: The Oracle software is not uninstalled completely, causing the Registry Information and environment variable information to be not completely deleted.

2: multiple versions of Oracle software are installed and may contain different digits.

In fact, Oracle databases are divided into server and client. If 64Bit is installed on the server, you do not need to install 64Bit clients when accessing the same machine. In addition, clients of different versions can connect to the server.

3: note that the Oracle Instance name, service name, and database name are the same in general. Users with high security requirements cannot be modified. Select the correct name When configuring some information.

4: The default InstantClient does not contain Sqlplus. You can download the InstantClient version that contains sqlplus.

Http://www.oracle.com/technetwork/cn/topics/winsoft-095945-zhs.html

----------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

Blog: http://blog.csdn.net/linghe301

----------------------------------------------------------------------------------