Oracle10g 监听器未启动错误

0x00报错代码

IMP-00058: ORACLE error 12541 encountered ORA-12541: TNS:no listener

0x01解决方案

su -oracle

netmgr

先把分支的Listeners分支下的监听器删掉

然后新建类型为 Listening locations 的监听器
再创建Database Services的监听器

监听器名字随便起 例如 Library
创建新的监听器 orcl
端口改为1570

0x02监听器启动

lsnrctl start Library

0x03检查结果

[oracle@linux5 Library]$ more /oracle/product/10.2/db_1/network/admin/listener.ora 
# listener.ora Network Configuration File: /oracle/product/10.2/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.188.139)(PORT = 1570))
)
SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
  (GLOBAL_DBNAME = orcl)
  (ORACLE_HOME = /oracle/product/10.2/db_1)
  (SID_NAME = ORCL)
)
)

[oracle@linux5 Library]$ lsnrctl status  LISTENER1

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 04-APR-2015 07:52:11

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.188.139)(PORT=1570)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER1
Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date                04-APR-2015 05:51:30
Uptime                    0 days 2 hr. 0 min. 40 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/product/10.2/db_1/network/admin/listener.ora
Listener Log File         /oracle/product/10.2/db_1/network/log/listener1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.188.139)(PORT=1570)))
Services Summary...
Service "orcl" has 1 instance(`s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

0x04其他方法

想不用图形界面新建监听器的同学可以直接敲代码新建 案例目录为

more /oracle/product/10.2/db_1/network/admin/samples/
oracle

Comments