ction
启动日期 20-9月 -2008 11:24:33 正常运行时间 0 天 0 小时 2 分 8 秒 跟踪级别 off
安全性 ON: Local OS Authentication SNMP OFF 监听程序参数文件 D:\\oracle\\product\\10.2.0\\db_1\\network\\admin\\listener.o ra 监听程序日志文件 D:\\oracle\\product\\10.2.0\\db_1\\network\\log\\listener.log 监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\\\.\\pipe\\EXTPROC1ipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) 服务摘要..
服务 \包含 1 个例程。
例程 \状态 UNKNOWN, 包含此服务的 1 个处理程序... 命令执行成功
C:\\Documents and Settings\\mengzhaoliang>tnsping orcl
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-9月 -
2008 11:27:43
Copyright (c) 1997, 2005, Oracle. All rights reserved. 已使用的参数文件:
D:\\oracle\\product\\10.2.0\\db_1\\network\\admin\\sqlnet.ora TNS-03505: 无法解析名称
9、查看sqlnet.ora内容： # sqlnet.ora Network Configuration D:\\oracle\\product\\10.2.0\\db_1\\network\\admin\\sqlnet.ora # Generated by Oracle configuration tools.
File:
# This file is actually generated by netca. But if customers choose to # install \# authentication, they will not be able to connect to the database on NT. SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
10.把listener.ora的内容： # listener.ora Network Configuration D:\\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 = D:\\oracle\\product\\10.2.0\\db_1) (PROGRAM = extproc) ) )
File:
LISTENER =
(DESCRIPTION_LIST = (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) )
改成下面的内容：
# listener.ora Network Configuration D:\\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 = orcl)
(ORACLE_HOME = D:\\oracle\\product\\10.2.0\\db_1) # (PROGRAM = extproc) ) )
LISTENER =
(DESCRIPTION_LIST = (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = orcl))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) )
File:
11、然后关闭、再启动listener
在cmd中执行“lsnrctl stop” 和“lsnrctl stop”命令，再次登陆正常！ C:\\Documents and Settings\\mengzhaoliang>sqlplus scott/mzl@orcl SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 9月 20 11:55:47 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL>
再次用PL/SQL Peveloper登陆就没有问题了。 完毕!
我通过以上步骤我的问题还没解决，然后重启了一下OracleOraDb10g_home1TNSListener服务就行了