OraFAQ Forum: Server Administration » DB requires restart once in two days

Home » RDBMS Server » Server Administration » DB requires restart once in two days

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

DB requires restart once in two days [message #400098]

Sun, 26 April 2009 02:18

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

Hi

We are restarting our server once in two days. otherwise DB is getting down.Please guide me how to resolve this.we dont want to restart it frequently(Requires restart once or twice in a month)

Server Configuration
----------------------------

32 bit windows server 2003 XP
4 GB RAM
Users connected : Around 150
Application using : JDEdwards
Database : Oracle

Total RAM=4gb (Oracle+OS)
Oracle => SGA+PGA=500+100=600MB

Also please guide me how can I utilize the remaining memory in a proper way.

Providing some of the parameters and values assigned.

Initialization parameters:
==================================
__db_cache_size 100663296
__java_pool_size 155189248
__large_pool_size 4194304
__shared_pool_size 255852544
db_block_size 8192
shared_pool_reserved_size 12792627
PGA 100 MB

Total System Global Area 524288000 bytes (500 MB)
Fixed Size 789692 bytes
Variable Size 442757956 bytes
Database Buffers 79691776 bytes
Redo Buffers 1048576 bytes

we are using SPFile

Thanks in Advance

Report message to a moderator

Re: DB requires restart once in two days [message #400100 is a reply to message #400098]

Sun, 26 April 2009 02:54

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What does mean:

Quote:

otherwise DB is getting down.

Explain in details with error code, extract of alert.log, trace files, application error, application log...

Regards
Michel

Report message to a moderator

Re: DB requires restart once in two days [message #400101 is a reply to message #400100]

Sun, 26 April 2009 03:06

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

No error..
When i try to connect to DB it shows Listner error.
but if i restart I will be able to access DB with our any issues.

Just wanted to know whether i should increase any buffer cache or some thing else.

Report message to a moderator

Re: DB requires restart once in two days [message #400105 is a reply to message #400101]

Sun, 26 April 2009 03:58

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

When i try to connect to DB it shows Listner error.

Are you expecting we know which error you have?
If it is a listener error then maybe the database is not down. How could we know from what you posted?

Quote:

Just wanted to know whether i should increase any buffer cache or some thing else.

Why are you thinking that buffer cache or something else is the root of your problem?

Regards
Michel

Report message to a moderator

Re: DB requires restart once in two days [message #400116 is a reply to message #400105]

Sun, 26 April 2009 05:00

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

We are restarting DB because users are not able to connect to application (JDEdwards) or some times they are not getting datas from database.

So as an Admin I tried to check the enterprise manager, or Toad in server. It is showing Listner error which means that connection to database is lost.

So I will do a restart.
After that all the problem will be solved. Even I can access toad and enterprise manager.But this will continue for two or three days. Again same problem will affect and I need to restart again.Thats Y I doubted whether it can be the problem of any buffer cache or some other setting.

Please let me know whether u need the entire parameter list to check any values

Attachment: Current Parameters1.pdf
(Size: 7.88KB, Downloaded 1120 times)

[Updated on: Sun, 26 April 2009 06:14]

Report message to a moderator

Re: DB requires restart once in two days [message #400119 is a reply to message #400116]

Sun, 26 April 2009 05:29

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I have an error
I can't access
...
All these things can help in any way to help you.
Do you call you call your doctor and say I'm sick and expect he will find what's wrong?

Copy and paste what have.

Regards
Michel

Report message to a moderator

Re: DB requires restart once in two days [message #400133 is a reply to message #400119]

Sun, 26 April 2009 07:12

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

Currently its working fine.. I can take a print out when it occurs next time. Even Im not sure whats happening on the backend.Thats y im asking whether it relates to any performance tuning.

Report message to a moderator

Re: DB requires restart once in two days [message #400142 is a reply to message #400133]

Sun, 26 April 2009 09:59

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

hi

could you please help me to tune oracle based on the below information . Also please let me know what all parameters needs to tune with the existing configuration.Attached word document with all parameters and their values.Please let me know I am wrong in assigning values anywhere.

Server Configuration
----------------------------

32 bit windows server 2003 XP
4 GB RAM
Users connected : Around 150
Application using : JDEdwards
Database : Oracle

Total RAM=4gb (Oracle+OS)
Oracle => SGA+PGA=500+100=600MB

Attachment: Current Parameters1.pdf
(Size: 7.88KB, Downloaded 1212 times)

[Updated on: Sun, 26 April 2009 10:03]

Report message to a moderator

Re: DB requires restart once in two days [message #400143 is a reply to message #400133]

Sun, 26 April 2009 09:59

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It can happen for about 1 billion reasons.

Regards
Michel

Report message to a moderator

Re: DB requires restart once in two days [message #400144 is a reply to message #400142]

Sun, 26 April 2009 10:04

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

No Message Body

Attachment: Current Parameters2.pdf
(Size: 6.99KB, Downloaded 1141 times)

Report message to a moderator

Re: DB requires restart once in two days [message #400145 is a reply to message #400144]

Sun, 26 April 2009 10:05

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

No Message Body

Attachment: Current Parameters3.pdf
(Size: 6.80KB, Downloaded 1225 times)

Report message to a moderator

Re: DB requires restart once in two days [message #400146 is a reply to message #400145]

Sun, 26 April 2009 10:05

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

No Message Body

Attachment: Current Parameters4.pdf
(Size: 7.03KB, Downloaded 1237 times)

Report message to a moderator

Re: DB requires restart once in two days [message #400147 is a reply to message #400146]

Sun, 26 April 2009 10:05

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

No Message Body

Attachment: Current Parameters5.pdf
(Size: 7.73KB, Downloaded 1215 times)

Report message to a moderator

Re: DB requires restart once in two days [message #400148 is a reply to message #400147]

Sun, 26 April 2009 10:06

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

No Message Body

Attachment: Current Parameters6.pdf
(Size: 4.35KB, Downloaded 1357 times)

Report message to a moderator

Re: DB requires restart once in two days [message #400149 is a reply to message #400144]

Sun, 26 April 2009 10:06

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

* Hey doc, I can't see; is this because of my glasses? Here are their parameters...
* Did you switch the light on?

Regards
Michel

Report message to a moderator

Re: DB requires restart once in two days [message #400150 is a reply to message #400148]

Sun, 26 April 2009 10:07

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

Please see the current parameter values . I have attached in 6 different pdf folder.

Please guide me how can I improve the database performance.

Report message to a moderator

Re: DB requires restart once in two days [message #400151 is a reply to message #400098]

Sun, 26 April 2009 10:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/84315/74940/
which have you tried & what were the results

Report message to a moderator

Previous Topic:	ORA-01033: ORACLE initialization or shutdown in progress
Next Topic:	upgrading from 8i to 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 00:10:55 CDT 2024