我的监听器出现了一个奇怪的错误，请大家帮忙看看？
我的监听器可能出错了，大家帮忙看看：
自已学习用机，Windows 2000服务器版，Oracle 9iR2，使用DBCA安装助手新建数据库，数据库名为MYONE。
我的操作步骤如下：
1. 在windows服务中启动临听器
2. 在服务中启动myone数据库
3. 打开sqlplus /nolog
4. 联连： connect system/ifclwx@myone
此次连接，可以成功
5. 执行一个测试查询： select * from scott.emp
可以查询出内容
6. 再次联连：connect system/ifclwx@myone
ORA-12541 : TNS 没有监听器
然后我手动在DOS窗口执行监听器的执行文件：
C:\> e:\oracle\ora92\BIN\TNSLSNR
次联接可以成功，当进行第二次联接时，监听器会自动中止，随后，在联接窗口即报告连接失败。
这台机器上的Oracle软件是我才安装上去的，所有有关网络的设置都是默认值，未做任何改变。我在我的笔记本上也重装了一次Oracle试试，一切都正常。
查看listener.log文件，内容为：
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 21-2月 -2000 23:26:34
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
系统参数文件为E:\oracle\ora92\network\admin\listener.ora
写入E:\oracle\ora92\network\log\listener.log的日志信息
写入E:\oracle\ora92\network\trace\listener.trc的跟踪信息
跟踪级别当前为0
以 pid=876 开始
监听：(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
监听：(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jjbobo)(PORT=1521)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
监听：(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jjbobo)(PORT=8080))(Presentation=HTTP)(Session=RAW))
监听：(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jjbobo)(PORT=2100))(Presentation=FTP)(Session=RAW))
21-2月 -2000 23:27:15 * service_register * myone * 0
21-2月 -2000 23:29:04 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=myone)(CID=(PROGRAM=E:\oracle\ora92\bin\sqlplus.exe)(HOST=JJBOBO)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=169.254.8.9)(PORT=1105)) * establish * myone * 0
listener.ora文件内容为：
# LISTENER.ORA Network Configuration File: E:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jjbobo)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = myone)
(ORACLE_HOME = E:\oracle\ora92)
(SID_NAME = myone)
)
)
tnsnames.ora文件内容为：
# TNSNAMES.ORA Network Configuration File: E:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
MYONE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jjbobo)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = myone)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jjbobo)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
相关文章