• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:


What is this error about

[oracle@server2 admin]$ lsnrctl start

LSNRCTL for Linux: Version - Production on 25-SEP-2013 20:09:01

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

TNS-01106: Listener using listener name LISTENER has already been started
[oracle@server2 admin]$ lsnrctl stop

LSNRCTL for Linux: Version - Production on 25-SEP-2013 20:09:06

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-01190: The user is not authorized to execute the requested listener command
[oracle@server2 admin]$

this is my listener.ora

# listener.ora Network Configuration File: /oracle/app/oracle/product/11.2.0/db2/network/admin/listener.ora
# Generated by Oracle configuration tools.

      (ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521)

ADR_BASE_LISTENER_DB = /oracle/app/oracle
1 Solution
The Oracle Listener is already started. You are trying to start it once again and the system returns you an error.
Consider making this test without users accessing Oracle's DBs: stop the Listener and run the command that starts it (the one that returns the error). It should run fine.
Run "lsnrctl stop" and then "lsnrctl start" command with the same OS user credentials as the running listener, or as a local administrator.
if this doesn`t work check / set listener password:

LSNRCTL> set password
Password: <secret>
The command completed successfully

then issue lsnrctl stop or start
slightwv (䄆 Netminder) Commented:
Looks like you are configuring a non-default listener name: LISTENER_DB

The default is just LISTENER.

Try this:
lsnrctl stop LISTENER_DB
lsnrctl start LISTENER_DB
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now