Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle snooping finishing

2025-04-01 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Next, let's talk about the configuration of ORACLE snooping: a static snooping is required, and dynamic snooping is required.

Static monitoring: the default port (1521)

Dynamic snooping is a non-default port

The monitored document is in the 10g document

Find the following in Net Services Reference in NET:

Sqlnet.ora, tnsname and listener are right below him.

Static monitoring is to get the whole file down:

What needs to be changed is Host. It is best not to use ip here because it may be troublesome to restart the ip change. Write it as the host name.

And then GLobal_DBNAME.

And ORACLE_HOME.

LISTENER= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=tcp) (HOST=oracel) (PORT=1521)) (ADDRESS= (PROTOCOL=ipc) (KEY=extproc) SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=jesn) (ORACLE_HOME=/u01/app/oracle/data) (SID_NAME=jesn)) (SID_DESC= (SID_NAME=plsextproc) (ORACLE_HOME=/u01/app/oracle) (PROGRAM=extproc)

What about dynamic monitoring:

Just the one above will be fine.

Port has changed.

Then you have to change the value of KEY or you won't be able to start it successfully.

Next up is $lsnrctl start LSN2.

LSN2= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=tcp) (HOST=oracel) (PORT=1526)) (ADDRESS= (PROTOCOL=ipc) (KEY=extprocjesn)

Then it's time to configure a tnsname:

For static registration

JESN= (DESCRIPTION= (ADDRESS= ((PROTOCOL=tcp) (HOST=oracle) (PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=jesn)

Then no matter what the SERVICE_NAME here is, as long as it is the same as the GLOBAL_DBNAME in listener, you might as well call it an abc. The purpose of this is to make it possible to hide the database name SID_DESC= (GLOBAL_DBNAME=jesn) and then conn system/oracle@JESN to test it.

For dynamic registration:

JESN= (DESCRIPTION= (ADDRESS= ((PROTOCOL=tcp) (HOST=oracle) (PORT=1526)) (CONNECT_DATA= (SERVICE_NAME=h2) the SERVICE_NAME here should be the same as the service_name in $show parameter name in the database. Service_name can be changed, but don't overwrite the original one:

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.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report