In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-07 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
Editor to share with you how to create Oracle non-1521 port monitoring, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's learn about it!
Existing listening file configuration
Click (here) to collapse or open
[oracle@test-db admin] $cat listener.ora
# listener.ora Network Configuration File: / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = test-db) (PORT = 1521))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = / u01/app/oracle
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=orcl)
(ORACLE_HOME = / u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = orcl)
)
)
Current monitoring status
Click (here) to collapse or open
[oracle@test-db admin] $lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0-Production on 04-APR-2018 00:09:29
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=test-db) (PORT=1521)
STATUS of the LISTENER
-
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0-Production
Start Date 03-APR-2018 23:30:31
Uptime 0 days 0 hr. 38 min. 57 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File / u01/app/oracle/diag/tnslsnr/test-db/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=test-db) (PORT=1521))
(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC1521)
Services Summary...
Service "orcl" has 1 instance (s).
Instance "orcl", status UNKNOWN, has 1 handler (s) for this service...
Service "orclXDB" has 1 instance (s).
Instance "orcl", status READY, has 1 handler (s) for this service...
Service "primary_orcl" has 1 instance (s).
Instance "orcl", status READY, has 1 handler (s) for this service...
The command completed successfully
-- separation line--
Add the listening of port 1522 to the listener.ora file, and the contents of the added file are as follows
Click (here) to collapse or open
[oracle@test-db admin] $cat listener.ora
# listener.ora Network Configuration File: / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = test-db) (PORT = 1521))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = / u01/app/oracle
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=orcl)
(ORACLE_HOME = / u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = orcl)
)
)
# 1522
MY_LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = test-db) (PORT = 1522))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1522))
)
)
# for registering services on port 1522
SID_LIST_MY_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=orcl)
(ORACLE_HOME = / u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = orcl)
)
)
Start port 1522 snooping
Click (here) to collapse or open
[oracle@test-db admin] $lsnrctl start my_listener
LSNRCTL for Linux: Version 11.2.0.3.0-Production on 04-APR-2018 00:16:18
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting / u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0-Production
System parameter file is / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to / u01/app/oracle/diag/tnslsnr/test-db/my_listener/alert/log.xml
Listening on: (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=test-db) (PORT=1522)
Listening on: (DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC1522)
Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=test-db) (PORT=1522)
STATUS of the LISTENER
-
Alias my_listener
Version TNSLSNR for Linux: Version 11.2.0.3.0-Production
Start Date 04-APR-2018 00:16:18
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File / u01/app/oracle/diag/tnslsnr/test-db/my_listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=test-db) (PORT=1522))
(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC1522)
Services Summary...
Service "orcl" has 1 instance (s).
Instance "orcl", status UNKNOWN, has 1 handler (s) for this service...
The command completed successfully
Use the PLSQL Developer tool to test that you can connect properly.
-Segmentation line-
Another way to register a server on port 1522 is to use a tnsnames.ora file
After removing the code for SID_LIST_MY_LISTENER static registration in listener.ora, restarting my_listener snooping found that there was no service registration.
Click (here) to collapse or open
[oracle@test-db admin] $lsnrctl start my_listener
LSNRCTL for Linux: Version 11.2.0.3.0-Production on 04-APR-2018 00:18:08
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting / u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0-Production
System parameter file is / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to / u01/app/oracle/diag/tnslsnr/test-db/my_listener/alert/log.xml
Listening on: (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=test-db) (PORT=1522)
Listening on: (DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC1522)
Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=test-db) (PORT=1522)
STATUS of the LISTENER
-
Alias my_listener
Version TNSLSNR for Linux: Version 11.2.0.3.0-Production
Start Date 04-APR-2018 00:18:08
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File / u01/app/oracle/diag/tnslsnr/test-db/my_listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=test-db) (PORT=1522))
(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC1522)
The listener supports no services
The command completed successfully
Add the following code to the tnsnames.ora file
Click (here) to collapse or open
My_orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = test-db) (PORT = 1522))
(ADDRESS = (PROTOCOL = TCP) (HOST = test-db) (PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
Note: if you do not add the paragraph (ADDRESS = (PROTOCOL = TCP) (HOST = test-db) (PORT = 1521)), there will be no service registration in the default 1521 port
Log in to the database to set local_listener parameters
Click (here) to collapse or open
Alter system set local_listener='my_orcl' scope=both
Use the command to check the monitoring status separately
Click (here) to collapse or open
[oracle@test-db admin] $lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0-Production on 04-APR-2018 00:32:38
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=test-db) (PORT=1521)
STATUS of the LISTENER
-
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0-Production
Start Date 03-APR-2018 23:30:31
Uptime 0 days 1 hr. 2 min. 6 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File / u01/app/oracle/diag/tnslsnr/test-db/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=test-db) (PORT=1521))
(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC1521)
Services Summary...
Service "orcl" has 1 instance (s).
Instance "orcl", status UNKNOWN, has 1 handler (s) for this service...
Service "orclXDB" has 1 instance (s).
Instance "orcl", status READY, has 1 handler (s) for this service...
Service "primary_orcl" has 1 instance (s).
Instance "orcl", status READY, has 1 handler (s) for this service...
The command completed successfully
[oracle@test-db admin] $lsnrctl status my_listener
LSNRCTL for Linux: Version 11.2.0.3.0-Production on 04-APR-2018 00:32:45
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=test-db) (PORT=1522)
STATUS of the LISTENER
-
Alias my_listener
Version TNSLSNR for Linux: Version 11.2.0.3.0-Production
Start Date 04-APR-2018 00:18:08
Uptime 0 days 0 hr. 14 min. 37 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File / u01/app/oracle/diag/tnslsnr/test-db/my_listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=test-db) (PORT=1522))
(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC1522)
Services Summary...
Service "orclXDB" has 1 instance (s).
Instance "orcl", status READY, has 1 handler (s) for this service...
Service "primary_orcl" has 1 instance (s).
Instance "orcl", status READY, has 1 handler (s) for this service...
The command completed successfully
Use the PLSQL Developer tool to test that you can connect properly.
The above is all the content of the article "how Oracle creates non-1521 port snooping". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.