Issue in setting listener password [message #147344] |
Thu, 17 November 2005 05:05 |
girish.rohini
Messages: 744 Registered: April 2005 Location: Delhi (India)
|
Senior Member |
|
|
[EDIT: Comment]: Sorry color display is not working inside the code.[/EDIT]
Oracle: oracle 9.2.0.7
OS: WinXP
Scenario:
When I am setting listener password, at the lsnrctl prompt, commands like status,stop,start give error.
The sequence of event that I got is mentioned below, alongwith my comments in RED:
C:\Documents and Settings\grohini\Desktop>lsnrctl
LSNRCTL for 32-bit Windows: Version 9.2.0.7.0 - Production on 17-NOV-2005 13:28:35
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> stop [COLOR=red]---Stopped currently running listener[/COLOR]
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
The command completed successfully
LSNRCTL> show current_listener
Current Listener is LISTENER
LSNRCTL> start [COLOR=red]-- Started listener LISTENER[/COLOR]
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 9.2.0.7.0 - Production
System parameter file is E:\oracle\ora92\network\admin\listener.ora
Log messages written to E:\oracle\ora92\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Girish.stin.websti.com)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.7.0 - Production
Start Date 17-NOV-2005 13:28:44
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File E:\oracle\ora92\network\admin\listener.ora
Listener Log File E:\oracle\ora92\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Girish.stin.websti.com)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl9i" has 1 instance(s).
Instance "orcl9i", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> change_password [COLOR=red]--Changing password[/COLOR]
Old password:
New password:
Reenter new password:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Password changed for LISTENER
The command completed successfully
LSNRCTL> set password
Password:
The command completed successfully
LSNRCTL> save_config
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Saved LISTENER configuration parameters.
Listener Parameter File E:\oracle\ora92\network\admin\listener.ora
Old Parameter File E:\oracle\ora92\network\admin\listener.bak
The command completed successfully
[COLOR=red]-------------------------------------
AT this point checked listener.ora file. Entry for parameter PASSWORDS_LISTENER got configured there.
-------------------------------------[/COLOR]
LSNRCTL> stop [COLOR=red]--Stopped the listener again.[/COLOR]
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
The command completed successfully
LSNRCTL> start [COLOR=red]--Started the listener.[/COLOR]
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 9.2.0.7.0 - Production
System parameter file is E:\oracle\ora92\network\admin\listener.ora
Log messages written to E:\oracle\ora92\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Girish.stin.websti.com)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-01169: The listener has not recognized the password [COLOR=red]---Got first message here, but the listener got started & I didn't get any confirmation about it. Checked the service in Windows Services.[/COLOR]
LSNRCTL> status [COLOR=red]--Status command giving message.[/COLOR]
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-01169: The listener has not recognized the password
LSNRCTL> stop [COLOR=red]--Stop command giving message.[/COLOR]
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-01169: The listener has not recognized the password
LSNRCTL> start
Starting tnslsnr: please wait...
Service OracleOraHome92TNSListener already running.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
LSNRCTL>
[COLOR=red]------------------------------------------------------------------------
When I set the password value to the one I set while changing the password
I still get the message TNS-01669
------------------------------------------------------------------------[/COLOR]
LSNRCTL> set password 1
The command completed successfully
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-01169: The listener has not recognized the password
[COLOR=red]------------------------------------------------------------------------
But when I set the password value to the one stored in listener.ora file in encrypted format
it worts fine
------------------------------------------------------------------------[/COLOR]
LSNRCTL> set password 7AAA926EC45D3A02
The command completed successfully
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.7.0 - Production
Start Date 17-NOV-2005 13:29:11
Uptime 0 days 1 hr. 52 min. 37 sec
Trace Level off
Security ON
SNMP OFF
Listener Parameter File E:\oracle\ora92\network\admin\listener.ora
Listener Log File E:\oracle\ora92\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Girish.stin.websti.com)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl9i" has 1 instance(s).
Instance "orcl9i", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
My issue is why I am getting this error TNS-01169 even after setting the password correctly and why it works when I set the password as the encrypted value as stored in listener.ora file.
Is it some bug with Oracle9207?
Thanks in advance for help
--Girish
[EDIT]: Sorry color display is not working inside the code.
[Updated on: Thu, 17 November 2005 05:07] Report message to a moderator
|
|
|
Re: Issue in setting listener password [message #147643 is a reply to message #147344] |
Fri, 18 November 2005 13:41 |
pwl
Messages: 22 Registered: May 2000
|
Junior Member |
|
|
Oracle 8i ( and I guess 9i) listeners have a 'nice' foible'
If teh password is a Clear Text password then
set password <password>
works
BUT if it is an encrypted passwords, then you must use :-
set password
wait for the prompt
now enter the password.
None of this is documented, I just had to work it out by experiment.
|
|
|