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.