ITPub博客

首页 > Linux操作系统 > Linux操作系统 > listener.ora

listener.ora

原创 Linux操作系统 作者:sswgej 时间:2008-07-30 16:30:01 0 删除 编辑

LISTENER.ORA对文件内写法比较敏感,改动这个文件的时候最好有个备份.

 

 


# listener.ora Network Configuration File: /home/oracle/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 = /home/oracle/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521))
    )
)

 

 

[oracle@ly admin]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-JUL-2008 06:44:57

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

Starting /home/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
TNS-01150: The address of the specified listener name is incorrect

Listener failed to start. See the error message(s) above...

[oracle@ly admin]$ ls
listener.ora  samples  shrept.lst  sqlnet.ora  tnsnames.ora
[oracle@ly admin]$ vi listener.ora
[oracle@ly admin]$ lsnrctl reload

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-JUL-2008 06:46:44

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.100)(PORT=1521)))
The command completed successfully

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

下一篇: awr学习
请登录后发表评论 登录
全部评论

注册时间:2008-07-28

  • 博文量
    62
  • 访问量
    81191