Home » RDBMS Server » Security » Issue in setting listener password
Issue in setting listener password [message #147344] Thu, 17 November 2005 05:05 Go to next message
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 Go to previous message
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.
Previous Topic: User Rights
Next Topic: Want DMP help
Goto Forum:
  


Current Time: Fri Mar 29 00:57:36 CDT 2024