Link to home
Start Free TrialLog in
Avatar of jcob_l
jcob_l

asked on

listener

What is this error about


[oracle@server2 admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - 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 11.2.0.1.0 - 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.

LISTENER_DB =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521)
    )
  )

ADR_BASE_LISTENER_DB = /oracle/app/oracle
Avatar of strivoli
strivoli
Flag of Italy image

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.
Avatar of SimpleJ
SimpleJ

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
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.