ORA-12541: TNS:no listener

今天启用Rman 连接数据库报错 ORA-12541: TNS:no listener，开始怀疑监听没有开启于是 lsnrctl  status  查看

[oracle@linux ~]$ lsnrctl status listener

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-JUL-2010 12:55:27

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.109)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                04-JUL-2010 11:52:45
Uptime                    0 days 1 hr. 2 min. 41 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.109)(PORT=1521)))
Services Summary...
Service "orcl" has 2 instance(s).
  Instance "orcl", status UNKNOWN, has 2 handler(s) for this service...
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

但是再次连接 依然报错

[oracle@linux ~]$ rman  target system/oracle@orcl

Recovery Manager: Release 10.2.0.1.0 - Production on Sun Jul 4 12:32:52 2010

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

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12541: TNS:no listener

于是查看 $ORACLE_HOME/network/admin/listner.ora

 

# listener.ora Network Configuration File: /u01/app/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 = /u01/app/oracle/product/10.2.0/db_1)

        (PROGRAM = extproc)

   )
   (SID_DESC =

         (GLOBAL_DBNAME = orcl)

         (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)

         (SID_NAME = orcl)

   )

)

LISTENER =

   (DESCRIPTION_LIST =

      (DESCRIPTION =

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

查看 tnsname.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = linux)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

经仔细查看没有错误 于是想到netca的配置问题，进入Linux 开启图形界面

选中本地net服务名配置，重新配置net服务名 orcl --&gttcp协议--&gt主机名--是，进行测试--&gt以system用户连接--&gt配置完成

再次以 rman target sys/oracle@orcl登录

[oracle@linux ~]$ rman  target  sys/oracle@orcl 

Recovery Manager: Release 10.2.0.1.0 - Production on Sun Jul 4 13:05:06 2010

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

connected to target database: ORCL (DBID=1250979061)

 

登录成功

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23184238/viewspace-667145/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23184238/viewspace-667145/