TNS-12546 TNS-12560 TNS-00516

最新推荐文章于 2023-02-17 19:35:40 发布

wonder_2012

最新推荐文章于 2023-02-17 19:35:40 发布

阅读量6.7k

点赞数 1

分类专栏： Troubleshooting

本文链接：https://blog.csdn.net/wonder_2012/article/details/25033907

版权

本文记录了在Oracle 11.2.0.1环境下，配置sqlnet.ora文件限制只允许特定IP登录数据库服务器的过程中遇到的问题及解决方法。在配置TCP.VALIDNODE_CHECKING和TCP.INVITED_NODES后，遇到TNS-12546和TNS-12560错误，原因是主机名未正确设置。修复主机名后，通过重新启动监听器解决了权限被拒绝的问题。

摘要由CSDN通过智能技术生成

目的：在server 21上增加只允许指定IP登录

步骤：cp server23上的sqlnet.ora配置文件到server21上，由于疏忽导致的一些问题

oracle：11.2.0.1 os：rhel5.3

[oracle@mlydserver21 admin]$ pwd

/app/soft/oracle/product/11.2.0/dbhome_1/network/admin
[oracle@mlydserver21 admin]$ vim sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/app/11.2.0/grid/network/admin/sqlnet.ora:q
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
TRACE_LEVEL_CLIENT = OFF
SQLNET.INBOUND_CONNECT_TIMEOUT = 0
ADR_BASE = /app/soft/oracle

TCP.VALIDNODE_CHECKING=yes
TCP.INVITED_NODES=(192.168.8.*,10.13.12.*,10.12.36.74,10.23.36.19,mlydserver23.yyy.com,10.13.28.*,192.168.1.*)

[oracle@mlydserver21 admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-MAY-2014 10:31:16

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Starting /app/soft/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /app/soft/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /app/soft/oracle/diag/tnslsnr/mlydserver21/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mlydserver21.yyy.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mlydserver21.yyy.com)(PORT=1521)))
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed

[oracle@mlydserver21 admin]$ tail -100f /app/soft/oracle/diag/tnslsnr/mlydserver21/listener/trace/listener.log

Mon May 05 10:29:34 2014
System parameter file is /app/soft/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /app/soft/oracle/diag/tnslsnr/mlydserv