In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
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.