- 论坛徽章:
- 0
|
在程序中访问数据库,该程序和oracle数据库在同一台主机(服务器)上,但是,运行程序时,报错:ORA-12154: TNS:could not resolve the connect identifier specified
oracle数据库服务器端:
# listener.ora Network Configuration File: /opt/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
-------
# tnsnames.ora Network Configuration File: /opt/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
~ = ~
FLOWRT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = AAA)
)
)
-------
1,确定监听器已经起来
2,
[oracle@localhost admin]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 15 10:37:03 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
...
-------
此外,将这一个访问数据库的程序放到另外一台主机中,该程序能正常的执行,并完成对数据库的操作
-------
本人刚刚接触oracle,对这方面不是很懂,希望大家指导,谢谢 |
|