"TNS-03505: unable to resolve the name" Problem Solution case, tns-03505 case

"TNS-03505: unable to resolve the name" Problem Solution case, tns-03505 case

 

1. Problem

A developer adds an ORACLE client in a windows environment and configures "tnsnames. ora, prepare to connect to the ORACLE database Linux environment, with tnsping test reported TNS-03505: unable to resolve the name error, the request is resolved.

2. Configuration content of the "tnsnames. ora" File

# TNSNAMES. ORA Network Configuration File: $ ORACLE_HOME \ NETWORK \ ADMIN \ tnsnames. ora # Generated by Oracle configuration tools.   SINGLE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.150) (PORT = 1521 )) (CONNECT_DATA = (SERVER = DEDICATED) (SID = single) ) )

Check the preceding configuration content. The connection string configuration is correct.

3. analyze the problem

(1) ping 192.168.1.150 first.

(2) telnet 192.168.1.150 1521.

(3) tnsping single on the local server (192.168.1.150 ).

(4) check whether there is a problem with the "tnsnames. ora" file. below is the file icon.

Notepad file of notepad

(5) Confirm that the file is not a tnsnames.ora.txt File

Display the extension name of the file on windows, as shown in the following figure:

4. Solution

Remove the TXT Suffix of the tnsnames.ora.txt file in the format of the display file extension name, and then tnsping single on the client.

 

 

Author: LI Junjie (Network Name: Step-by-Step), engaged in "system architecture, operating system, storage device, database, middleware, application" six levels of systematic performance optimization work

Join the system performance optimization professional group to discuss performance optimization technologies. GROUP: 258187244