今天配置非默认监听,直接从默认监听段拷贝过来,修改了端口号,如下:
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=testdb1)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
LSNR2=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=testdb1)(PORT=1526))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
结果在用sqlplus连接时,提示监听已启动。现象如下:
[ORCL1@testdb1 /u01/app/oracle/product/10.2.0/db_1/network/admin]$lsnrctl start LSNR2
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 15-AUG-2011 18:27:08
Copyright (c) 1991, 2005, Oracle. All rights reserved.
TNS-01106: Listener using listener name
LISTENER has already been started
解决方法:
1、注意上面提示LISTENER监听已经启动,明明启动的非默认监听LSNR2,为什么提示默认监听已经启动?
2、将listener.ora文件中非默认监听LSNR2节中红色字体部分去掉后,启动非默认监听正常。
原因不详,有空再研究。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12355989/viewspace-704921/,如需转载,请注明出处,否则将追究法律责任。