Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to set Oracle listener passwords. Many people may not know much. In order to let everyone know more, Xiaobian summarizes the following contents for everyone. I hope you can gain something according to this article.

Set Oracle Listeners Password (LISTENER)

A bug is safe? Sure! By default, any user does not need to use any passwords-i. e., to operate or shut down Oracle Listeners via the lsnrctl tool, from

Any new session will fail to establish a connection. Oracle Listeners in Oracle 9i allow anyone to remotely initiate listener management using lsnrctl. It is also easy to count.

The vault was damaged.

1. Stop listening without password

[oracle@test ~]$ lsnrctl stop listener_demo92

--> Stop listening, you can see that you don't need any password to stop

LSNRCTL for Linux: Version 9.2.0.8.0 - Production on 26-JUN-2011 08:22:26

Copyright (c) 1991, 2006, Oracle Corporation.

All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))

The command completed successfully

2. Restart listening and set password

[oracle@test ~]$ lsnrctl

LSNRCTL for Linux: Version 9.2.0.8.0 - Production on 26-JUN-2011 08:24:09

Copyright (c) 1991, 2006, Oracle Corporation.

All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> set current_listener listener_demo92

--> Set current listener

Current Listener is listener_demo92

LSNRCTL> start

--> The startup process does not require any password, and the startup details are omitted.

LSNRCTL> change_password

--> Use change_password to set password

Old password:

New password:

Reenter new password:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))

Password changed for listener_demo92

The command completed successfully

LSNRCTL> save_config

--> Note that save_config failed here

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))

TNS-01169: The listener has not recognized the password

LSNRCTL> set password

--> Enter the new password to verify

Password:

The command completed successfully

LSNRCTL> save_config

--> save_config again succeeded

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))

Saved listener_demo92 configuration parameters.

Listener Parameter File

/oracle/92/network/admin/listener.ora

Old Parameter File

/oracle/92/network/admin/listener.bak

The command completed successfully

--> After adding the password, you can see that there is a new record in the listener.ora file, that is, the password option (Note: Although the password management mode is used, you can still start listening without password)

[oracle@test admin]$ more listener.ora

#----ADDED BY TNSLSNR 26-JUN-2011 05:12:48---

PASSWORDS_listener_demo92 =

#--------------------------------------------

3. Try to stop listening without using a password

[oracle@test ~]$ lsnrctl stop listener_demo92

LSNRCTL for Linux: Version 9.2.0.8.0 - Production on 26-JUN-2011 06:09:51

Copyright (c) 1991, 2006, Oracle Corporation.

All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))

TNS-01169: The listener has not recognized the password

--> Error message received, password authentication required

4. Use password to stop listening

[oracle@test ~]$ lsnrctl

LSNRCTL> set current_listener listener_demo92

Current Listener is listener_demo92

LSNRCTL> stop

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))

TNS-01169: The listener has not recognized the password

LSNRCTL> set password

Password:

The command completed successfully

LSNRCTL> stop

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))

The command completed successfully

5. Save_config failed

--> In Oracle 9i, using the save_config command will fail

LSNRCTL> save_config

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)))

TNS-01169: The listener has not recognized the password

--> Set password should be used before save_config, then save configuration successfully.

LSNRCTL> set password

Password:

The command completed successfully

6.

Configure the ADMIN_RESTRICTIONS parameter in listener.ora

Parameter function:

When the ADMIN_RESTRICTIONS parameter is set in the listener.ora file, no administrative commands are allowed while the listener is running, and the set command is unavailable

It does not work either locally or remotely on the server. At this point, the settings for listening can only be manually modified by modifying the listener.ora file. For the modification to take effect, only

Reload the listener configuration information once using the lsnrctl reload command or the lsnrctl stop/start command.

Modification method:

Manually add the following line to the listener.ora file

ADMIN_RESTRICTIONS_ = ON

After reading the above, do you have any further information on how to set the Oracle listener password? If you still want to know more knowledge or related content, please pay attention to the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.