一大早来上班，就有同事告诉我某省的数据库监听有问题。赶快检查了一下，发现其实是前端主机重启后没有启动完全应用造成了一些错误和数据库监听没有关系的。
至于为什么同事会怀疑到数据库监听我也感到很怪异。
检查没有问题后，还是不放心，于是就利用tnsping进行测试：
显然sqlnet.ora文件中的连接控制参数有些问题，检查下：
参数NAMES.DIRECTORY_PATH只有一个TNSNAMES，看看官方文档的介绍：
应该有六个参数的，于是增加一个hostname参数。再次进行连接即告成功。
BTW:
其实这个参数的default值Default
NAMES.DIRECTORY_PATH=(tnsnames, onames, hostname)
应经可以满足基本的要求了。-:)
至于为什么同事会怀疑到数据库监听我也感到很怪异。
检查没有问题后，还是不放心，于是就利用tnsping进行测试：
[oracle@localhost ~]$ tnsping 211.1XX.XX.XX
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 10-DEC-2008 09:45:50
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/home/oracle/product/10.2/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 10-DEC-2008 09:45:50
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/home/oracle/product/10.2/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name
显然sqlnet.ora文件中的连接控制参数有些问题，检查下：
[oracle@localhost ~]$ more /home/oracle/product/10.2/network/admin/sqlnet.ora
# sqlnet.ora Network Configuration File: /home/oracle/product/10.2/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES)
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
#NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
# sqlnet.ora Network Configuration File: /home/oracle/product/10.2/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES)
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
#NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
参数NAMES.DIRECTORY_PATH只有一个TNSNAMES，看看官方文档的介绍：
tnsnames:local naming naming method
Set to resolve a net service name through the tnsnames.ora file on the client.
ldap:directory naming naming method
Set to resolve a database service name, net service name, or net service alias through a directory server.
onames:Oracle Names method
Set to resolve database objects through a Oracle Names server.
hostname:host naming method
Set to resolve a host name alias through an existing names resolution service or a centrally-maintained set of /etc/hosts files.
cds:Cell Directory Services (CDS) external naming method
Set to resolve an Oracle database name in a Distributed Computing Environment (DCE) environment.
nis:Network Information Service (NIS) external naming method
Set to resolve service information through an existing NIS.
Set to resolve a net service name through the tnsnames.ora file on the client.
ldap:directory naming naming method
Set to resolve a database service name, net service name, or net service alias through a directory server.
onames:Oracle Names method
Set to resolve database objects through a Oracle Names server.
hostname:host naming method
Set to resolve a host name alias through an existing names resolution service or a centrally-maintained set of /etc/hosts files.
cds:Cell Directory Services (CDS) external naming method
Set to resolve an Oracle database name in a Distributed Computing Environment (DCE) environment.
nis:Network Information Service (NIS) external naming method
Set to resolve service information through an existing NIS.
应该有六个参数的，于是增加一个hostname参数。再次进行连接即告成功。
[oracle@localhost ~]$ tnsping 2XX.1XX.2XX.XX
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 10-DEC-2008 09:56:52
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/home/oracle/product/10.2/network/admin/sqlnet.ora
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=211.139.222.155))(ADDRESS=(PROTOCOL=TCP)(HOST=211.139.222.155)(PORT=1521)))
OK (70 msec)
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 10-DEC-2008 09:56:52
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/home/oracle/product/10.2/network/admin/sqlnet.ora
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=211.139.222.155))(ADDRESS=(PROTOCOL=TCP)(HOST=211.139.222.155)(PORT=1521)))
OK (70 msec)
BTW:
其实这个参数的default值Default
NAMES.DIRECTORY_PATH=(tnsnames, onames, hostname)
应经可以满足基本的要求了。-:)
我只是加了一个hostname，没有加onames
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/2317695/viewspace-759004/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- Windows Server 2016 安装 远程桌面服务 角色后，写磁盘变慢的问题
- Linux 操作系统配置互信认证后，登录仍然需要输入用户密码的解决办法
- oracle_16进制与10进制转换小示例
- 修改表名时遇到ORA-14047错误
- sshd_config 中文手册
- 关于pmon、smon、mman、mmon、mmnl后台进程的解释
- 查看Linux网卡UUID和MAC地址---Linux命令
- gc buffer busy
- [kernel]----理解kswapd的低水位min_free_kbytes
- 安装Oracle 11G RAC 遇到的2个问题——Failed to run "oifcfg" 和 找不到集群节点
