当前位置: 代码迷 >> Oracle管理 >> 除了enterprise console manager以外,sqlplus system/qazwsx@linux ,PLSQLdeveloper ,TOAD都不能访问数据库解决思路
  详细解决方案

除了enterprise console manager以外,sqlplus system/qazwsx@linux ,PLSQLdeveloper ,TOAD都不能访问数据库解决思路

热度:269   发布时间:2016-04-24 05:39:10.0
除了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   =
            (SERVICE_NAME   =   binladen.server606)
        )
    )

EXTPROC_CONNECTION_DATA   =
    (DESCRIPTION   =
  相关解决方案