Oracle eavesdropping Service

Sometimes the database administrator needs to monitor, adjust, view, and test the production database. Production Databases cannot be moved randomly. Even if they are not in disorder, they have to take on a huge amount of pressure. If the accident slows down, the system will crash. How can you learn, improve, test, and test without a real environment?

 

The closer we engage in IT to the real environment, the more reliable we will do. Although we can make an empty ORACLE to learn, we can also build an ORACLE with real data to understand the system, or we can build a DATAGUARD to learn real data in a timely manner, you can also view the SQL application of logical statement urad. The only environment that lacks changes and user requests.

 

Then we can write a program to intercept the network IP packet and check whether it is sent to the production database. If yes, copy the package, modify the package address, change the destination address to a simulated database, and change the source address to the address of the eavesdropping service. Then a real environment is created.

DBAs can monitor and test the simulated database.

Master database 192.168.1.1

Simulate database 192.168.2.3

Eavesdropping Service

IP packet interception

Generate four user request information

The returned data is abandoned by the Service.