首页 > Linux操作系统 > Linux操作系统 > listener.ora
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/ ,如需转载,请注明出处,否则将追究法律责任。