OraFAQ Forum: Enterprise Manager » db shutting down while navigating enterprise manager links

Home » RDBMS Server » Enterprise Manager » db shutting down while navigating enterprise manager links (Oracle 10g Release 1 (10.1.0.2.0) for Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

db shutting down while navigating enterprise manager links [message #399620]

Thu, 23 April 2009 02:50

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

Report message to a moderator

Re: db shutting down while navigating enterprise manager links [message #399655 is a reply to message #399620]

Thu, 23 April 2009 05:43

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

Report message to a moderator

Re: db shutting down while navigating enterprise manager links [message #400016 is a reply to message #399655]

Sat, 25 April 2009 00:46

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.