plsql 连接mysql数据库连接_plsql连接本地数据库服务TNS-12560问题

各位好，本地数据库服务一直使用正常，但是突然间pl sql服务连接数据库。

tnsnames.ora配置如下：

# tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = LXD)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

listener.ora配置

# listener.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = orcl)

(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)

(SID_NAME = orcl)

)

)

LISTENER =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = LXD)(PORT = 1521))

)

tnsping返回信息：

C:\Documents and Settings\Administrator>tnsping orcl

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 24-8月 -

2012 11:00:30

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

已使用的参数文件:

F:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

已使用 TNSNAMES 适配器来解析别名

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = LXD)(POR

T = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))

OK (70 毫秒)

sqlnet.log信息如下：

***********************************************************************

Fatal NI connect error 12560, connecting to:

(LOCAL=NO)

VERSION INFORMATION:

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

Time: 24-8月 -2012 10:53:44

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: TNS: 协议适配器错误

ns secondary err code: 0

nt main err code: 0

nt secondary err code: 0

nt OS err code: 0

----------------

数据库服务和监听已经启动，环境变量中oracoe_home,oracle_sid也已经添加，仍然无法连接，请各位大侠帮忙看下。