Solved

Memory issue?

Posted on 2008-10-31
6
1,764 Views
Last Modified: 2013-11-10
We have a Dell PowerEdge 1950 running Windows Server 2003 Enterprise. It has dual quad core 3 Ghz intel porcessors with 32 GB RAM. It is running VMWare Virtual Center Server using Oracle as the database. Every morning between 4 AM and 4:15 AM the DBA has RMAN backup running and will receive the following error:
Errors in file c:\oracle\product\10.2.0\admin\vmw\udump\vmw_ora_5912.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0xE93E370] [ADDR:0xE93E370] [UNABLE_TO_WRITE] []

Oracle says this is due to memory issues where either the memory is bad or there is not enough.

The system properties recognizes that there is 32 GB of RAM but task manager tells me that there is 30 GB of physical memory available but WinMSD says there is only 1.75 GB of available physical memory. The boot.ini files is as follows:

[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003, Enterprise" /NoExecute=OptOut /fastdetect /PAE

I added the /PAE switch even though the system recognized the memory without it.
I have downloaded Process Explorer to see if I could account for for the the slightly 1 + GB of physical memory that is seen in task Manager being in use but could not.

If anyone has any ideas as to what I can look at to try to solve the issue, I would appreciate it.
Thanks
0
Comment
Question by:rledoux
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 14

Expert Comment

by:dfxdeimos
ID: 22852606
I am not familiar with Oracle or your specific issue, but if it is feasable to bring the server down for a short while you could run a memory test.

http://www.memtest.org/#downiso

Also, you shouldn't need to enable the PAE switch, it wouldn't do anything if you had a 64 bit OS anyways.
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 22852665
You have "Windows Server 2003 Enterprise" but is that 32-bit or 64-bit?  I think it is 32-bit, right?  32-bit OSes do not use 32GB of RAM directly or easily.

You could try adding the /3GB switch to the boot.ini file (on the line where you have the /PAE switch).  We used both of those switches when we ran Oracle on Windows Server 2003 Enterprise on a server with 8GB of RAM.  The /3GB switch allows individual programs (or processes) to use up to 3GB of RAM instead of the default limit of 2GB.

Just FYI, our boot.ini file looked like this:

[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /3GB /PAE /NoExecute=OptOut
0
 

Author Comment

by:rledoux
ID: 22867426
I have a 32 bit version of Server 2003 Enterprise. My boot.ini file did not have the /3GB switch but when I added it the system went from recognizing 32 GB of RAM down to 16 GB. I removed it and it once again saw 32 GB. WinMSD sees 32 GB physical RAM but only has 2.72 GB free. Task Manager says 30 GB available.
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 22867560
What's the main problem you are trying to solve?  Is it the amount of memory that various utilities report or indicate?  Or, is it the "core dump" error that is happening in your Oracle RMAN process?
Remember, 32-bit OSes *DO NOT* efficiently, directly or easily use memory above 4GB.  Whatever values 32-bit utlities report in a system that has more than 4GB of RAM are somewhat suspect anyway.
0
 

Author Comment

by:rledoux
ID: 22867671
The main issue to resolve is the Oracle RMAN problem. I thought by trying to figure out where the rest of the memory is vaporizing then the RMAN issue would be solved.
0
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 250 total points
ID: 22868172
If you want to use 32GB of RAM directly and easily, you need a 64-bit OS.  Another problem could be the combination of: VMWare Virtual Center Server, Oracle, and a 32-bit OS on a machine with lots of RAM.  Are you sure that combination is supported by Oracle?  Do you have a test server available with 4GB of RAM (or less) that does not have VMWare Virtual Center Server where you could test an Oracle database and RMAN?
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
oracle forms question 22 61
Oracle Mulit-site configuration 28 73
Oracle Date 6 42
ORA-01843: not a valid month - use NVL 14 19
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Or at least that’s the word according to a new blog from Tech Target on AWS’s new Managed Services (MS) offering. According to the blog, AWS is launching their AWS MS program to expedite the adoption of cloud by Fortune 1000 and Global 2000 companie…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question