Home » RDBMS Server » Server Administration » DB requires restart once in two days
DB requires restart once in two days [message #400098] Sun, 26 April 2009 02:18 Go to next message
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
Re: DB requires restart once in two days [message #400100 is a reply to message #400098] Sun, 26 April 2009 02:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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
Re: DB requires restart once in two days [message #400101 is a reply to message #400100] Sun, 26 April 2009 03:06 Go to previous messageGo to next message
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.
Re: DB requires restart once in two days [message #400105 is a reply to message #400101] Sun, 26 April 2009 03:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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
Re: DB requires restart once in two days [message #400116 is a reply to message #400105] Sun, 26 April 2009 05:00 Go to previous messageGo to next message
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

[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 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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
Re: DB requires restart once in two days [message #400133 is a reply to message #400119] Sun, 26 April 2009 07:12 Go to previous messageGo to next message
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.
Re: DB requires restart once in two days [message #400142 is a reply to message #400133] Sun, 26 April 2009 09:59 Go to previous messageGo to next message
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

[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 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It can happen for about 1 billion reasons.

Regards
Michel
Re: DB requires restart once in two days [message #400144 is a reply to message #400142] Sun, 26 April 2009 10:04 Go to previous messageGo to next message
nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE
Junior Member
No Message Body
Re: DB requires restart once in two days [message #400145 is a reply to message #400144] Sun, 26 April 2009 10:05 Go to previous messageGo to next message
nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE
Junior Member
No Message Body
Re: DB requires restart once in two days [message #400146 is a reply to message #400145] Sun, 26 April 2009 10:05 Go to previous messageGo to next message
nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE
Junior Member
No Message Body
Re: DB requires restart once in two days [message #400147 is a reply to message #400146] Sun, 26 April 2009 10:05 Go to previous messageGo to next message
nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE
Junior Member
No Message Body
Re: DB requires restart once in two days [message #400148 is a reply to message #400147] Sun, 26 April 2009 10:06 Go to previous messageGo to next message
nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE
Junior Member
No Message Body
Re: DB requires restart once in two days [message #400149 is a reply to message #400144] Sun, 26 April 2009 10:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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
Re: DB requires restart once in two days [message #400150 is a reply to message #400148] Sun, 26 April 2009 10:07 Go to previous messageGo to next message
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.
Re: DB requires restart once in two days [message #400151 is a reply to message #400098] Sun, 26 April 2009 10:19 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/84315/74940/
which have you tried & what were the results

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


Current Time: Fri Dec 09 08:05:10 CST 2016

Total time taken to generate the page: 0.13112 seconds