Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ ORA-12545: Connection failed because the target host or object does not exist     - About enhanced Linux / Unix server system security program (Linux)

- Intruder tools Knark Analysis and Prevention Linux environment (Linux)

- SSH security note (Linux)

- Linux System Getting Started Tutorial: Using the Linux common commands (Linux)

- Analysis of common mistakes when compiling MySQL installation (Database)

- Analysis of memory mapping process in Linux x86-64 mode (Linux)

- Android Touch message passing mechanism analysis (Programming)

- Spring classic face questions Share (Programming)

- DRBD Principle and Features Overview (Server)

- Ubuntu 14.04 LTS NTFS partition can not access solution (Linux)

- Parse Server supports iOS and Android push messaging (Programming)

- MySQL use the integer type (Database)

- Let Mac OS X dedicated high-speed mobile hard disk can also be read in Linux (Linux)

- Linux iptables firewall settings whitelist (RHEL 6 and CentOS 7) (Linux)

- Use mysqldump MySQL database backup - Linux Shell Scripting (Database)

- How to manage start-up applications in Ubuntu (Linux)

- Install the latest Eclipse IDE in Ubuntu (Linux)

- To resolve Ubuntu 14.04 Unity Desktop Environment Login freeze problem (Linux)

- How to fix fatal error: security / pam_modules.h: No such file or directory (Linux)

- The most concise explanation of JavaScript closures (Programming)

 
         
  ORA-12545: Connection failed because the target host or object does not exist
     
  Add Date : 2017-08-31      
         
       
         
  1. Problem description

XP system to install the AX1 application and upgrade AX2, the same connection in the local Oracle client configuration example, where AX2 shows the link is successful, and AX1 has failed to link, which Oracle instance configuration must be correct, because the AX2 Already linked successfully. Before AX2 and AX1 are able to connect successfully, the user after using the 360 antivirus, AX1 only problems.

2. Problem analysis

Through the log analysis, AX1 returned the error message is found "ORA-12545: because the target host or object does not exist, the connection failed." Obviously this information is wrong, Oracle wrong to determine the cause of the problem, because we configured the host is there, and has been linked on the AX2 has been successful.

3. Solutions

In order to avoid the AX1 dynamic library impact, we write pure OCI test program TestOCI.exe, the exe only rely on Windows and OCI dynamic library, the test program were placed AX2 Program, AX1 Program and the desktop casually a file Folder, only the AX1 program shows the link failed, the other two folders under the test program are successful. This proves that it is certain that the AX1 Program under what documents affect the connection process.

The use of two-point shielding method of the AX1 Program all files for group testing, the final test program TestoCI.exe and ws2_32.dll in the same folder, the connection will fail, apparently ws2_32.dll is the Windows Socket library, this Library appears in the AX1 Program in the abnormal, it can be concluded that this problem is caused by the ws2_32.dll file.

Then we will why the library will affect our test procedures were analyzed, respectively, on the problem machine test two TestOCI.exe, a group is a folder only test exe, another group contains the test folder exe and Ws2_32.dll, respectively, to print the exe startup runtime loaded dynamic library. The following are two sets of test results, only excerpts of some important information.

Group 1: Only TestOCI.exe in the folder

Starting Directory: G: \ AAA \ Program \

Search Path:

C: \ Program Files \ Intel \ iCLS Client \;

G: \ app \ Administrator \ product \ 11.2.0 \ client_2 \ bin;

C: \ Program Files \ AMD APP \ bin \ x86;

C: \ WINDOWS \ system32;

C: \ WINDOWS;

C: \ WINDOWS \ System32 \ Wbem;

C: \ Program Files \ ATI Technologies \ ATI.ACE \ Core-Static;

C: \ Program Files \ Intel \ Intel (R) Management Engine Components \ DAL;

C: \ Program Files \ Intel \ Intel (R) Management Engine Components \ IPT;

C: \ Program Files \ Common Files \ Autodesk Shared \;

G: \ AAA \ program;

G: \ AAA \ program

Loaded "c: \ windows \ system32 \ WS2_32.DLL" at address 0x71A20000.Successfully hooked module.

Group 2: The folder contains both TestOCI.exe and ws2_32.dll

Starting Directory: G: \ AAA \ Program \

Search Path:

C: \ Program Files \ Intel \ iCLS Client \;

G: \ app \ Administrator \ product \ 11.2.0 \ client_2 \ bin;

C: \ Program Files \ AMD APP \ bin \ x86;

C: \ WINDOWS \ system32;

C: \ WINDOWS;

C: \ WINDOWS \ System32 \ Wbem;

C: \ Program Files \ ATI Technologies \ ATI.ACE \ Core-Static;

C: \ Program Files \ Intel \ Intel (R) Management Engine Components \ DAL;

C: \ Program Files \ Intel \ Intel (R) Management Engine Components \ IPT;

C: \ Program Files \ Common Files \ Autodesk Shared \;

G: \ AAA \ program;

G: \ AAA \ program

Loaded "g: \ aaa \ program \ WS2_32.DLL" at address 0x71A20000.Successfully hooked module.

From the above two test results we can see that the two test program to load the dynamic library search path is the same, but loaded ws2_32.dll dynamic library is different, run successfully is to load c: \ windows \ system32 the following ws2_32 .dll, and run the failure is loaded g: \ aaa \ program under ws2_32.dll. G: \ aaa \ program \ ws2_32.dll is only 85K, and c: \ windows \ system32 \ WS2_32.DLL there are 291K, obviously g: aaa programws2_32.dll is a wrong library, while the Windows Socket is A set of only this one library is loaded, the other Socket library is not loaded will be a problem.

This problem only occurs in XP, but does not appear in Win7, one possible reason is XP and Win7 search path priority level is not the same bar, or something changed the dynamic library loading environment, but can not determine.

4. Solutions

Delete AX1 / Program under the ws2_32.dll, you can restore the connection Oracle database.
     
         
       
         
  More:      
 
- To teach you a trick to find the real IP address (Linux)
- Kubernetes cluster deployment (Server)
- Use GNU / Linux broadcasting of television programs (Linux)
- Ubuntu installed Gimp 2.6.11 (stable version) with PPA (Linux)
- Java integrated development environment common set of operations (Linux)
- Oracle table space is too large processing time (Database)
- Sublime Text 3 best features, plug-ins and settings (Linux)
- About Git (Linux)
- Use mdadm tool to create software RAID 0 (Linux)
- Ubuntu install video conversion tool Selene (Linux)
- Linux Operating System Security Study (Linux)
- To deploy MySQL database with separate read and write OneProxy (Database)
- Ubuntu the ARP (arptables) (Linux)
- How to use the character in C ++ without pressing the Enter key to enter the Show (Programming)
- Lua and C ++ (Programming)
- Android Studio quick overview of Gradle (Programming)
- PostgreSQL use pgpool achieve high availability (Database)
- Gentoo: startx problem appears Failed to load module (Linux)
- How to configure chroot environment in Ubuntu 14.04 (Linux)
- MongoDB fragmentation (Cluster) (Database)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.