A ORA-01019 error is reported when a client connection to a 64-bit Oracle 11g R2 instance

In the 64-bit Windows 8 Enterprise Edition environment, we connected the oracle11g server for two days. We will share the process for your reference.

Local Environment:

1. SERVER: Oracle 11g R2 64-bit, installation path E:/org12

Download: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

2. Client:

(1) Instant Client, lightweight, installation path E:/oracle11/Client
Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

(2) 32-bit Oracle Data Access Components (odac) with Oracle Developer Tools for Visual Studio, installation path E:/org12/product/11.2.0/Client_1

Http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html? Sssourcesiteid = otncn

 

Use three client tools to connect to the Oracle server. Result:

First: the SQL deveploer tool that comes with Oracle is basically no problem! No client configuration is required.

Http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

The second method is to use PL/SQL 9.0 for connection. Copy the XX \ app \ oracle \ product \ 11.2.0 \ Server \ Network \ admin \ tnsnames of the server. ora file to the network \ ADMIN of client (1) and delete unnecessary parts. The retained content is roughly as follows:

 
Orcl =(Description=(Address_list=(Address= (Protocol = TCP) (host = localhost) (Port = 1521) (CONNECT_DATA=(SID=Orcl )))
 

Start PL/SQL as follows

Set Path= E:/oracle11/ClientRemServer Path: e: \ org12 \ product \ 11.2.0 \ dbhome_1 \ binSetORACLE_HOME = E:/oracle11/ClientSetTns_admin = E:/oracle11/ClientSetNls_lang = american_america.Al32utf8StartE:/oracle11/pl_ SQL/plsqldev.exe
 

Now OK.

Third, use a third-party tool, oraclesqlhandle, which comes with JRE, which is very small and easy to use. search online.

A tool component developed by our company connects to the server. The problem arises. the following error is reported first.

 

It is suspected that it is an environment variable problem. After multiple attempts, add the client path to the path and report the following error:

 

If it is suspected that it is a character set, use bat to change it to the same Encoding As the Oracle server. The error is changed:

I have been searching for this problem online for a long time and tried many solutions, but my final solution is:

1. Delete the Oracle server. You can search for the server online and delete it;

2. Delete odac and all components;

3. Retain the Instant Client and its installation directory, mainly Network \ admin \ tnsnames. ora

4. reinstall the Oracle server;

The connection to all clients is normal now!

Summary:

1. At first, I suspected it was a bug caused by the 64-bit Oracle driver path (x86). The final conclusion is that the same machine should not be installed with two Oracle clients, the server + client is not recommended, which may cause some potential problems for unknown reasons.

2. The 64-bit ORACLE Server + 32-bit Oracle client may have some potential problems, preferably 32-bit to 32-bit.

3. When Oracle 11g R2 ex is installed, "E: \ org12 \ app \ oracle \ product \ 11.2.0 \ Server \ bin" will be added before the environment variable path.;;", Note that there are two semicolons, one must be deleted; this is not known as installationProgramBug?

 

Reference resources:

Http://blogs.msdn.com/ B /apgcdsd/archive/2011/05/25/linked-server-ssis-oracle.aspx

Http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/96048ef5-ef9e-4b1c-b8a3-5d7b91d55adb

Supplement: Later, I tried another solution: download and install the Oracle 32-bit client from the official website.