jamesBond008
asked on
oracle 10g servers looses network connection and the error in event log The server was unable to allocate from the system nonpaged pool because the pool was empty.
We started having this error on a server and once this happens the network connectivity of server was lost; No process can access database A and only resolution was reboot. I will call this server A. We reinstalled OS and database and same issue happened.
Then we moved the database to another server server B where there was no problem before. It had Oracle 10g installed with 2 database already running before. Once this database db A was icreated and started on the server this problem cropped up. It is running on windows 2003 server sp2. Please note the server runs ok for 3 days before it raises this error. Last time we rebooted on Tuesday and then it ran ok till Saturday. Today we rebooted it and it will run ok for couple of days.
Thanks
Then we moved the database to another server server B where there was no problem before. It had Oracle 10g installed with 2 database already running before. Once this database db A was icreated and started on the server this problem cropped up. It is running on windows 2003 server sp2. Please note the server runs ok for 3 days before it raises this error. Last time we rebooted on Tuesday and then it ran ok till Saturday. Today we rebooted it and it will run ok for couple of days.
Thanks
Event Type: Error
Event Source: Srv
Event Category: None
Event ID: 2019
Date: 1/3/2009
Time: 8:26:21 PM
User: N/A
Computer: XXXXXX
Description:
The server was unable to allocate from the system nonpaged pool because the pool was empty.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 00 00 04 00 01 00 54 00 ......T.
0008: 00 00 00 00 e3 07 00 c0 ....ã..À
0010: 00 00 00 00 9a 00 00 c0 ....?..À
0018: 00 00 00 00 00 00 00 00 ........
0020: 00 00 00 00 00 00 00 00 ........
0028: 01 00 00 00 ....
I found 1 case where it seems like a twin brother of Your problem,here ,at ee:
https://www.experts-exchange.com/questions/23100592/The-server-was-unable-to-allocate-from-the-system-nonpaged-pool-because-the-pool-was-empty.html
https://www.experts-exchange.com/questions/23100592/The-server-was-unable-to-allocate-from-the-system-nonpaged-pool-because-the-pool-was-empty.html
quating for You:
"ID:20717638Author:Placebo C6Date:01. 22.2008 at 02:53PM ESTAccepted Solution
Rank: Guru
Was this solution helpful? Yes No
PlaceboC6:
I think I know what your problem is. Your afdb tag is getting big. If you have printers shared on this server that are using a HP TCP/IP port, there is a leak. See the following KB. You need to switch to using Standard TCP/IP Port per this KB.
http://support.microsoft.com/kb/933999/en-us"
"ID:20717638Author:Placebo
Rank: Guru
Was this solution helpful? Yes No
PlaceboC6:
I think I know what your problem is. Your afdb tag is getting big. If you have printers shared on this server that are using a HP TCP/IP port, there is a leak. See the following KB. You need to switch to using Standard TCP/IP Port per this KB.
http://support.microsoft.com/kb/933999/en-us"
i will suggest to investigate the following issues that hapen very often:
1. Check for active firewalls on the servers
2. Check if the instances are registered by the Listener (and it is running!):
C:\>lsnrctl services
If not - do static registration.
1. Check for active firewalls on the servers
2. Check if the instances are registered by the Listener (and it is running!):
C:\>lsnrctl services
If not - do static registration.
ASKER
I did memsnap /a and found that Oracle.exe is leaking memory
Name Probability Object Change Start End Percent Rate/hour
oracle.exe Definite Handles 4535 133404 137939 3 3474
Any idea how to troubleshoot with oracle? We have 3 database on this server, Before we had 2 and there was no error. When we added the 3rd database for example c it started giving error.
Name Probability Object Change Start End Percent Rate/hour
oracle.exe Definite Handles 4535 133404 137939 3 3474
Any idea how to troubleshoot with oracle? We have 3 database on this server, Before we had 2 and there was no error. When we added the 3rd database for example c it started giving error.
Estimate the memory usage of each server:
SQL>show sga
Try to figure out how the memory is used by 2 instances and what is the
size of SGA of the third instance.
Server OS often use the free memory as temporary disk cache
and free it on demand.
I run up to 16 Oracle 10g test instances on 8 GB RAM under Linux
and experience only small HDD problems ....
SQL>show sga
Try to figure out how the memory is used by 2 instances and what is the
size of SGA of the third instance.
Server OS often use the free memory as temporary disk cache
and free it on demand.
I run up to 16 Oracle 10g test instances on 8 GB RAM under Linux
and experience only small HDD problems ....
ASKER
Is it possible to find if there is any query or cursor which is causing the memeory leak? If yes, then how. Thanks
I do not know such.
But try to find a OS tool for 2003 that can show
precisely the really used RAM and the free part used as
temporary cache.
Three years ago our company experiences the same panic
but on Linux. After 3 months investigations I found that
the server OS simply caches disk blocks in the free memory.
But try to find a OS tool for 2003 that can show
precisely the really used RAM and the free part used as
temporary cache.
Three years ago our company experiences the same panic
but on Linux. After 3 months investigations I found that
the server OS simply caches disk blocks in the free memory.
ASKER
We have applied a patch to 10g oracle. I will moniter for couple of days and see if that fixes the leak.
ASKER
Applying Oracle patch fixed the issue no more memory leak now.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It's interesting problem but seem to have to do much more with Microsoft then Oracle,here some links:
http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/w2000msgs/4746.mspx
http://faq.webcrossing.com/webx?eFAQprintFAQ@@.4a8c695d