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)(HO ST=)(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/db 2/network/ admin/list ener.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
[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)(HO
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
# Generated by Oracle configuration tools.
LISTENER_DB =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521)
)
)
ADR_BASE_LISTENER_DB = /oracle/app/oracle
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
LSNRCTL> set password
Password: <secret>
The command completed successfully
then issue lsnrctl stop or start
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
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.