Oracle snooping finishing
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:
