TNS-12560: TNS:protocol adapter error

最新推荐文章于 2019-06-17 05:56:28 发布

原创最新推荐文章于 2019-06-17 05:56:28 发布 · 1.9k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#permissions #oracle #variables #database #include #network

Oracle 专栏收录该内容

101 篇文章

订阅专栏

本文探讨了TNS-12560:TNS:protocoladaptererror这一常见Oracle数据库连接错误的原因及解决办法。该错误通常与监听器配置有关，文章提供了详细的排查步骤和可能的解决方案，包括更新SQL*Net客户端软件、检查环境变量及文件权限等。

导读：

The error "TNS-12560: TNS: protocol adapter error" is usually related to a configuration issue with the listener:

TNS-12560 TNS:protocol adapter error

Cause: A generic protocol adapter error occurred.

Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors. For further details, turn on tracing and re-execute the operation. Turn off tracing when the operation is complete.

The "TNS-12560: TNS:protocol adapter error" sometimes a transient error on a SQL*Net (Oracle*Net) client, happening sporadically. To turn-on tracing for the ORA-12560, use these settings. Also check /var/log/messages (Linux) for errors:

TRACE_LEVEL_< > = admin
TRACE_DIRECTORY_< > = < >
TRACE_TIMESTAMP_< > = true

Possible fixes for the TNS-12560 include:

1 - Get the latest patches for the SQL*Net client software.

2 - Check your $ORACLE_HOME and $PATH variables

3 - Check file permissions on the PC client

4 - Ensure that TNS_ADMIN is set properly

5 - Check for network firewall issues

6 - In Windows, Verify that the database service is started. ?Verify that the ORACLE_SID parameter is correctly set in the registry.