Oracle listening Memory leakage

Q: When I use plsql to connect to the server's database, I find that Oracle cannot ask questions, and I cannot remember any prompts. Remotely observe the Oracle listening process and find that the listening process reaches

Q: When I use plsql to connect to the server's database, I find that Oracle cannot ask questions, and I cannot remember any prompts. Remotely observe the Oracle listening process and find that the listening process reaches

Q: When I use plsql to connect to the server's database, I find that Oracle cannot ask questions, and I cannot remember any prompts.

Remotely observing the Oracle listening process found that the listening process was about 2 GB. After the listener is restarted or the server is restarted, the listener memory is increased from about 6 MB to about 2 GB in about half an hour.

Log prompt error:

2010 10:55:45*12546

TNS-12546: TNS: License denied

TNS-12560: TNS: protocol adapter error.

TNS-00516: License denied

TNS-01168: memory not allocated

2010 10:56:26*1168

Solution:

I have set an ip address limitation for Oracle. This is the case if the IP address in the untrusted list is used for crazy access.

Upgrade Oracle to 9.2.0.3 after version 9.2.0.1.

I tested it on the local machine. If it is upgraded to 9.2.0.8, this problem will not occur!

,