ORA-12154: TNS:could not resolve service name的解决方法
今天测试人员在部署新的应用时，应用服务器连接不到数据库
[oracle@localhost admin]$ sqlplus hangan/hangan@hatest
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Apr 26 16:24:35 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve service name
错误指出客户不能查找到tnsnames.ora文件中所列举的服务。
查错误码显示:
ORA-12154: TNS:could not resolve service name
Cause: Oracle Net could not locate the net service name specified in the tnsnames.ora configuration file.
Action: Perform these steps:
1. Verify that a tnsnames.ora file exists.
|
See Also:
for configuration file location information |
2. Verify that there are not multiple copies of the tnsnames.ora file.
3. In the tnsnames.ora file, verify that the net service name specified in your connect string is mapped to a connect descriptor.
4. Verify that there are no duplicate copies of the sqlnet.ora file.
5. If you are using domain names, verify that your sqlnet.ora file contains a NAMES.DEFAULT_DOMAIN parameter. If this parameter does not exist, you must specify the domain name in your connect string.
6. If you are not using domain names, and this parameter exists, delete it or disable it by commenting it out.
7. If you are connecting from a login dialog box, verify that you are not placing an "@" symbol before your connect net service name.
8. Activate client tracing and repeat the operation.
Cause: Oracle Net could not locate the database service name or net service name specified in the directory server.
Action: Perform these steps:
1. Verify that the database service or net service name entry exists in the directory that this computer was configured to use.
|
See Also:
for directory setup instructions |
2. Verify that the sqlnet.ora file includes the following entry: NAMES.DIRECTORY_PATH=(ldap, other_naming_methods)
根据文档中的提示第三步3.（1.2没问题了）检查tnsnames.ora文件中的服务名称是否正确的配置，经过检查(SERVICE_NAME = hatest)没有问题（更没有语法错误）
然后按照文档做第4.5步，到第6步时发现问题，sqlnet.ora文件中引用了domain域(注:我们这边没使用域)
[oracle@localhost admin]$ cat sqlnet.ora
# SQLNET.ORA Network Configuration File: /home/oracle/OraHome1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = localdomain
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)--这个没问题啦
好了那还等什么编辑该文件把domain干掉。编辑完后赶快tnsping hatest
[oracle@localhost admin]$ tnsping hatest
TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 26-APR-2007 16:33:39
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/home/oracle/OraHome1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.248.155)(PORT = 1521))) (CONNECT_DATA = (SID = hatest) (SERVER = DEDICATED)))
OK (30 msec)
没问题通了。在连接数据库
[oracle@localhost admin]$ sqlplus hangan/hangan@hatest
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Apr 26 16:33:49 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> exit
