Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the TNS-12535 error of oracle tnsping report". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how to solve the TNS-12535 error in oracle tnsping report".

The oracle database server is deployed in the linux 7 environment, and the client is on windows 2008R2. When the client performs tnsping, it is found and reported to TNS-12535. The troubleshooting is as follows:

(1) at first, it is suspected that the firewall of the server or the client is turned on. After investigation, this kind of firewall may be excluded.

(2) after careful analysis, it is found that the sqlnet.ora file is missing under $ORACLE_HOME/network/admin on the server. Add the file:

[oracle@ceshi admin] $cat sqlnet.ora

# sqlnet.ora Network Configuration File: / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = / u01/app/oracle

After the addition is completed, and then in the client-side tnsping, it is already successful.

At this point, I believe you have a deeper understanding of "how to solve TNS-12535 errors in oracle tnsping". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.