Home » RDBMS Server » Enterprise Manager » db shutting down while navigating enterprise manager links (Oracle 10g Release 1 (10.1.0.2.0) for Windows)
db shutting down while navigating enterprise manager links [message #399620] Thu, 23 April 2009 02:50 Go to next message
nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE
Junior Member

3 days before I tried to change the parameter value for USE_INDIRECT_DATA_BUFFER from FALSE to TRUE.This resulted in database down.
Then I opened the DB using new pfile.


After that onwards(last 3 days) we are facing a new problem. when ever we try to use Enterprise Manager its opening properly but when we navigate through different links ,DB is getting down even though we didnt make change for any parameters.Do we need to assign manually any seperate memory for using Enterprise Manager ?Y is it happening so... we are not even changing any dynamic values just viewing the performace only by clicking different navigation links...

Please help me to solve this.

Appreciate your valuable suggestion..

Thanks in advance
Re: db shutting down while navigating enterprise manager links [message #399655 is a reply to message #399620] Thu, 23 April 2009 05:43 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams224.htm#REFRN10228

Quote:
USE_INDIRECT_DATA_BUFFERS controls how the system global area (SGA) uses memory. It enables or disables the use of the extended buffer cache mechanism for 32-bit platforms that can support more than 4 GB of physical memory. On platforms that do not support this much physical memory, this parameter is ignored.


Babu
Re: db shutting down while navigating enterprise manager links [message #400016 is a reply to message #399655] Sat, 25 April 2009 00:46 Go to previous messageGo to next message
nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE
Junior Member
Thanks for the response..
I will explain the situtaion once more.

Configuration:
Server : 32bit windows 2003 XP
RAM: 4 GB but upgraded with 20GB more RAM (Total 24 GB)

Since we introduced 20 GB more RAM.we tried to allocate the memory between OS and ORACLE.
For that we introduced /PAE in Boot.ini file
Then updated the registry key AWE_WINDOW_MEMORY =1.2 gb
Then changed the Oracle parameter USE_INDIRECT_DATA_BUFFERS = TRUE.

When we restarted DB,it went down.So we use the pfile to startup DB.Please see the attached current pfile and spfile(both copied in single notepad).

I have started the DB using a new pfile Only.
In that new pfile I didnt see the parameter USE_INDIRECT_DATA_BUFFERS.

but anyhow when I checked the parameter list in enterprise manager after restarting the DB, this parameter is showing as False only(which is the default status)

But my problem is when ever I navigate the enterprise manager by just clicking on different links,suddenly database is getting down...

please let me know if you want to see our parameter list.

Re: db shutting down while navigating enterprise manager links [message #400130 is a reply to message #400016] Sun, 26 April 2009 06:46 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Can you post screen shot (Windows Task Manager -> Performance screen shot)

Babu
Re: db shutting down while navigating enterprise manager links [message #400496 is a reply to message #400130] Tue, 28 April 2009 08:33 Go to previous messageGo to next message
nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE
Junior Member
Do u want the performance screen shot when the Database was down OR the current running performance screen shot?
Re: db shutting down while navigating enterprise manager links [message #400567 is a reply to message #400496] Tue, 28 April 2009 18:15 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


We want to know RAM usage in your OS level.

Post your task manager screen shot.

Babu
Re: db shutting down while navigating enterprise manager links [message #401723 is a reply to message #399620] Wed, 06 May 2009 04:36 Go to previous messageGo to next message
nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE
Junior Member
please see the attached screen shot of RAM usage in OS level
  • Attachment: RAM usage.JPG
    (Size: 96.85KB, Downloaded 1339 times)
Re: db shutting down while navigating enterprise manager links [message #402129 is a reply to message #401723] Thu, 07 May 2009 13:26 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

I think 24G memory available in your OS

Babu
Previous Topic: Grid Control metric collection error
Next Topic: How to Export/Import in Windows-Oracle10g-EnterprisesManager
Goto Forum:
  


Current Time: Thu Mar 28 18:42:38 CDT 2024