Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ ORA-12545: Connection failed because the target host or object does not exist     - Linux / Raspberry Pi using the following command-line based web browser (Linux)

- To create a full command line Android Build System (Linux)

- RCU lock in the evolution of the Linux kernel (Linux)

- Android memory optimization of the disk cache (Linux)

- Oracle VirtualBox Problem Solving Case (Linux)

- Performance issues under CentOS 6.5 VLAN devices (Linux)

- Python calls the API interface in several ways (Programming)

- Nginx Performance Tuning Guidelines (Server)

- Debian 8.2.0 (Jessie) fast clean installation tutorial (Linux)

- ogg start being given libnnz11.so: can not open shared object file (Database)

- Nginx concerning the location and rewrite applications proxy_pass (Server)

- Ubuntu 64-bit installation Adobe Reader 9.5.5 (Linux)

- How to install Zephyr Test Management Tools on CentOS 7.x (Server)

- C + + secondary pointer memory model (pointer array) (Programming)

- Linux virtual machine how to access the Internet in a virtual machine when using NAT mode (Linux)

- Detailed Linux network security policies and protection measures (Linux)

- Killall five options you might not know (Linux)

- To configure parameter configuration and software installation and uninstallation under Linux (Linux)

- Python KNN algorithm of actual realization (Programming)

- Docker container plaintext password problem-solving way (Server)

 
         
  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:      
 
- Java memory analysis tool uses detailed MAT (Programming)
- Ubuntu Slingscold (Linux)
- BackTrack (BT3, BT4) Linux installation tutorial (Linux)
- Formatted output printf command (Programming)
- Installation through the network Debian 7 (Wheezy) (Linux)
- Linux file and directory management - ls, cp, mv (Linux)
- Easily create RPM packages using the FPM (Linux)
- How to install Perl modules from CPAN (Linux)
- Access.log Apache access log analysis and how to import it into MySQL (Server)
- HashMap in Android and Java different implementations (Programming)
- Dynamic programming Android (Programming)
- Linux Network Programming - raw socket can do (Programming)
- Disk storage structure and file recovery experiment (FAT file system) (Linux)
- Linux command line ten magic usage (Linux)
- How SSHfs mount a remote file system on Linux (Linux)
- extundelete: the Linux-based open source data recovery tools (Linux)
- Android Application Development: an argument between Activity (Programming)
- HTTPS Encryption Algorithm (Linux)
- SecureCRT connect virtual machine Linux system (Ubuntu) (Linux)
- Cooling solutions Ubuntu system (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.