Oracle 10G手工添加listener.ora文件(Helloblock写作)
1、修改/etc/hosts文件添加主机名和IP地址的映射:
vi /etc/hosts
在文件内添加下面内容,192.168.0.99是服务器IP地址,rdbms是服务器主机名
192.168.0.99 rdbms
2、创建listener.ora文件:
cd /u01/app/oracle/product/10.2.0/db_1/network/admin/
vi listener.ora
在文件内添加以下内容:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rdbms)(PORT = 1521))
)
)
注意:括号要对应。
3、启动监听器:
lsnrctl start
4、查看监听器状态:
lsnrctl status
lsnrctl service
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28408358/viewspace-764225/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28408358/viewspace-764225/