除了enterprise console manager以外,sqlplus system/qazwsx@linux ,PLSQL developer ,TOAD仍然不能访问数据库,报12154 TNS could not resolve the connect identifier specified 错误,大虾帮忙啊!!!
局域网内sqlplus连接server 2003上的oracle10g服务器,报ORA-12154 TNS could not resolve the connect identifier specified 错误 两天了,尝试了网上的所有方案,仍然不行,请大家帮忙1 系统信息 :
ORACLE 10.2.0.1.0 WINDOWS SERVER 2003
数据库信息
全局数据库名:binladen.server606
系统标识符 binladen
# sqlnet.ora Network Configuration File: d:\oracle\product\10.2.0\client_2\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.TRACE_FILENO_CLIENT = 3# The following parameters were set by TOAD# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
#SQLNET.AUTHENTICATION_SERVICES= (NONE)
#NAMES.DIRECTORY_PATH= (TNSNAMES, NIS)
#NAMES.NIS.META_MAP = bingwang
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NONE)TRACE_LEVEL_CLIENT = ONTRACE_UNIQUE_CLIENT = ONNAMES.DIRECTORY_PATH= (TNSNAMES)TRACE_DIRECTORY_CLIENT = d:\oracle\product\10.2.0\client_2\Network\TraceTRACE_FILE_CLIENT = sqlnet_trcLOG_FILE_CLIENT = sqlnet_logLOG_DIRECTORY_CLIENT = d:\oracle\product\10.2.0\client_2\Network\LogTRACE_FILELEN_CLIENT = 100TRACE_TIMESTAMP_CLIENT = ONSQLNET.EXPIRE_TIME = 0USE_DEDICATED_SERVER = OFF
# tnsnames.ora Network Configuration File: d:\oracle\product\10.2.0\client_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.LINUX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server606)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = binladen.server606)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
局域网内sqlplus连接server 2003上的oracle10g服务器,报ORA-12154 TNS could not resolve the connect identifier specified 错误 两天了,尝试了网上的所有方案,仍然不行,请大家帮忙1 系统信息 :
ORACLE 10.2.0.1.0 WINDOWS SERVER 2003
数据库信息
全局数据库名:binladen.server606
系统标识符 binladen
# sqlnet.ora Network Configuration File: d:\oracle\product\10.2.0\client_2\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.TRACE_FILENO_CLIENT = 3# The following parameters were set by TOAD# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
#SQLNET.AUTHENTICATION_SERVICES= (NONE)
#NAMES.DIRECTORY_PATH= (TNSNAMES, NIS)
#NAMES.NIS.META_MAP = bingwang
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NONE)TRACE_LEVEL_CLIENT = ONTRACE_UNIQUE_CLIENT = ONNAMES.DIRECTORY_PATH= (TNSNAMES)TRACE_DIRECTORY_CLIENT = d:\oracle\product\10.2.0\client_2\Network\TraceTRACE_FILE_CLIENT = sqlnet_trcLOG_FILE_CLIENT = sqlnet_logLOG_DIRECTORY_CLIENT = d:\oracle\product\10.2.0\client_2\Network\LogTRACE_FILELEN_CLIENT = 100TRACE_TIMESTAMP_CLIENT = ONSQLNET.EXPIRE_TIME = 0USE_DEDICATED_SERVER = OFF
# tnsnames.ora Network Configuration File: d:\oracle\product\10.2.0\client_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.LINUX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server606)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = binladen.server606)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
解决方案 »
- sysdba登录 ORA-01017:用户名密码出错 故障排查实例
- Oracle安装中的问题,救急啊
- 还是oreacle中的查询语句 会的来看看
- Oracle如何导入导出XML格式的文件,谢谢
- 如何取得过程和函数
- 【请问】相同值取其一,distinct与least/greatest哪个效率高?数据100w左右.
- 我在安装ORACLE 9i 3CD的那张碟中,出现了一个这种错误。我无法解决
- trigger table or view does not exists问题!!!
- 能不能介绍点查询优化的文章和站点啊
- 请问哪儿有p4用的symcjit.dll 下载?谢谢
- 关于对同一个表使用游标嵌套的问题
- 查看ORACLE程序包中函数内容(急)
==>
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))
例如
ORACLE_HOME = d:\oracle\product\10.2.0\client_1