How to bypass the password settings of the oracle listener and use oraclelistener

Source: Internet
Author: User

How to bypass the password settings of the oracle listener and use oraclelistener
Zookeeper

How to bypass the password settings for oracle listening:


1. Find the pid of the listening process and kill it.
Ps-ef | grep tns

[Oracle @ lixora admin] $ ps-ef | grep tns
Root 9 2 0 Jul11? 00:00:00 [netns]
Oracle 29668 1 0? 00:00:00/oracle/bin/tnslsnr LISTENER-inherit
Oracle 29677 29487 0 00:00:00 pts/1 grep tns


Kill-9 pid

Kill-9 29668


2. Replace the original listener. ora file.

3. Start the listener.


Oracle listener password and listener Security

Many people know that the Oracle listener has always had a security risk. If security measures are not set, users who can access the listener can close the listener remotely.

Example:

D: \> lsnrctl stop eygle

LSNRCTL for 32-bit Windows: Version 10.2.0.3.0-Production on-2007 10:02:40

Copyright (c) 1991,200 6, Oracle. All rights reserved.

Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.33.11) (PORT = 1521 ))
(CONNECT_DATA = (SERVICE_NAME = eygle )))
Command executed successfully

You can find that the default listener log cannot record the operation address at this time:

No longer listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 172.16.33.11) (PORT = 1521 )))
28-NOV-2007 09:59:20 * (CONNECT_DATA = (CID = (PROGRAM =) (HOST =) (USER = Administrator) (COMMAND = stop)
(ARGUMENTS = 64) (SERVICE = eygle) (VERSION = 169870080) * stop * 0

To ensure the security of the listener, you are advised to set a password for the listener:

[Oracle @ jumper log] $ lsnrctl

Linux: Version 9.2.0.4.0-Production on 28-NOV-2007 10:18:17

Copyright (c) 1991,200 2, Oracle Corporation. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> set current_listener listener
Current Listener is listener
LSNRCTL> change_password
Old password:
New password:
Reenter new password:
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.33.11) (PORT = 1521 )))
Password changed for listener
The command completed successfully
LSNRCTL> set password
Password:
The command completed successfully
LSNRCTL> save_config
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.33.11) (PORT = 1521 )))
Saved LISTENER configuration parameters.
Listener Parameter File/opt/oracle/product/9.2.0/networ ...... the remaining full text>

Oracle does not have a listener, and listener and tnsnames services are configured.

DEMO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.22.12.33) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = demo)
)
)

Change SERVICE_NAME in to the same as the SID in the listener, that is, SERVICE_NAME = ORCL;

If not, tnsping will take a look at the results.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.