除了enterprise console manager以外,sqlplus system/qazwsx@linux ,PLSQLdeveloper ,TOAD都不能访问数据库
除了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 = ON
TRACE_UNIQUE_CLIENT = ON
NAMES.DIRECTORY_PATH= (TNSNAMES)
TRACE_DIRECTORY_CLIENT = d:\oracle\product\10.2.0\client_2\Network\Trace
TRACE_FILE_CLIENT = sqlnet_trc
LOG_FILE_CLIENT = sqlnet_log
LOG_DIRECTORY_CLIENT = d:\oracle\product\10.2.0\client_2\Network\Log
TRACE_FILELEN_CLIENT = 100
TRACE_TIMESTAMP_CLIENT = ON
SQLNET.EXPIRE_TIME = 0
USE_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 =
&nbs