TNS-01106: Listener using listener name LISTENER has already been started

在弄监听的时候碰到“ TNS-01106: Listener using listener name  LISTENER  has already been started ”错误。

点击(此处)折叠或打开

1. [oracle@e1 ~]$ lsnrctl start listener
3. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 21-OCT-2014 17:02:06
5. Copyright (c) 1991, 2011, Oracle. All rights reserved.
7. Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
9. TNSLSNR for Linux: Version 11.2.0.3.0 - Production
10. System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
11. Log messages written to /u01/app/oracle/diag/tnslsnr/e1/listener/alert/log.xml
12. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=e1)(PORT=1521)))
13. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
15. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=e1)(PORT=1521)))
16. STATUS of the LISTENER
17. ------------------------
18. Alias listener
19. Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
20. Start Date 21-OCT-2014 17:02:07
21. Uptime 0 days 0 hr. 0 min. 10 sec
22. Trace Level off
23. Security ON: Local OS Authentication
24. SNMP OFF
25. Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
26. Listener Log File /u01/app/oracle/diag/tnslsnr/e1/listener/alert/log.xml
27. Listening Endpoints Summary...
28. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=e1)(PORT=1521)))
29. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
30. Services Summary...
31. Service \"PROD1\" has 1 instance(s).
32. Instance \"PROD1\", status UNKNOWN, has 1 handler(s) for this service...
33. The command completed successfully
34. [oracle@e1 ~]$ lsnrctl start lsnr2
36. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 21-OCT-2014 17:02:31
38. Copyright (c) 1991, 2011, Oracle. All rights reserved.
40. TNS-01106: Listener using listener name listener has already been started
43. 检查LISTENER.ORA文件
44. [oracle@e1 admin]$ cat listener.ora
45. LISTENER=
46. (DESCRIPTION=
47. (ADDRESS_LIST=
48. (ADDRESS=(PROTOCOL=tcp)(HOST=e1)(PORT=1521))
49. (ADDRESS=(PROTOCOL=ipc)(KEY=extproc) )))
50. SID_LIST_LISTENER=
51. (SID_LIST=
52. (SID_DESC=
53. (SID_NAME=PROD1)
54. (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
55. (PROGRAM=extproc)))
58. LSNR2=
59. (DESCRIPTION=
60. (ADDRESS_LIST=
61. (ADDRESS=(PROTOCOL=tcp)(HOST=e1)(PORT=1526))
62. (ADDRESS=(PROTOCOL=ipc)(KEY=extproc)
63. )))
65. [oracle@e1 admin]$

其实原因很简单两个不同监听的 (ADDRESS=(PROTOCOL=ipc)(KEY=extproc)一样了，把KEY的值改成不一样的即可解决问题。

点击(此处)折叠或打开

1. LSNRCTL> start listener
2. Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
4. TNSLSNR for Linux: Version 11.2.0.3.0 - Production
5. System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
6. Log messages written to /u01/app/oracle/diag/tnslsnr/e1/listener/alert/log.xml
7. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=e1)(PORT=1521)))
8. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1521)))
10. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=e1)(PORT=1521)))
11. STATUS of the LISTENER
12. ------------------------
13. Alias listener
14. Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
15. Start Date 21-OCT-2014 17:21:35
16. Uptime 0 days 0 hr. 0 min. 10 sec
17. Trace Level off
18. Security ON: Local OS Authentication
19. SNMP OFF
20. Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
21. Listener Log File /u01/app/oracle/diag/tnslsnr/e1/listener/alert/log.xml
22. Listening Endpoints Summary...
23. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=e1)(PORT=1521)))
24. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1521)))
25. Services Summary...
26. Service \"PROD1\" has 1 instance(s).
27. Instance \"PROD1\", status UNKNOWN, has 1 handler(s) for this service...
28. The command completed successfully
29. LSNRCTL> status lsnr2
30. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=e1)(PORT=1526)))
31. STATUS of the LISTENER
32. ------------------------
33. Alias lsnr2
34. Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
35. Start Date 21-OCT-2014 17:21:00
36. Uptime 0 days 0 hr. 0 min. 54 sec
37. Trace Level off
38. Security ON: Local OS Authentication
39. SNMP OFF
40. Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
41. Listener Log File /u01/app/oracle/diag/tnslsnr/e1/lsnr2/alert/log.xml
42. Listening Endpoints Summary...
43. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=e1)(PORT=1526)))
44. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1526)))
45. Services Summary...
46. Service \"PROD1\" has 1 instance(s).
47. Instance \"PROD1\", status READY, has 1 handler(s) for this service...
48. Service \"PROD1XDB\" has 1 instance(s).
49. Instance \"PROD1\", status READY, has 1 handler(s) for this service...
50. The command completed successfully
51. LSNRCTL>

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

转载于:http://blog.itpub.net/29505646/viewspace-1463404/