Home » RDBMS Server » Server Administration » Why does my DB Server shut down frequently?
Why does my DB Server shut down frequently? [message #56594] Thu, 10 April 2003 08:16 Go to next message
ahboer
Messages: 4
Registered: April 2003
Junior Member
My DB Server just has a HardDisk and 1024MB ram,OS is W2K,RDBMS is Oracle 8i.But it is shutted automatically.It doesn't work unless restart the service or restart the computer.My initORCL.ora file configed following,could you point where the failure is ?
open_cursurs=600
db_buffer=32000
share_pool_size=256M
large_pool_size=100M
java_pool_size=50M
log_buffer=16M
db_block_size=8192
processes=500

Thanks a lot!

Report message to a moderator

Re: Why does my DB Server shut down frequently? [message #56595 is a reply to message #56594] Thu, 10 April 2003 08:24 Go to previous messageGo to next message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Did you get any message in the alert<SID>.log ???

Report message to a moderator

Re: Why does my DB Server shut down frequently? [message #56617 is a reply to message #56595] Fri, 11 April 2003 18:51 Go to previous messageGo to next message
ahboer
Messages: 4
Registered: April 2003
Junior Member
Sorry,I cannot find the file alert.log.But In the Event log,there is no related information of the DB.The most information are approximately like such "DeviceHardDisk1DR1 has not been ready yet".Would you like to tell me what is the possible cause?And thanks.

Report message to a moderator

Re: Why does my DB Server shut down frequently? [message #56627 is a reply to message #56594] Sat, 12 April 2003 07:38 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
hi,
for me open_cursors looks like a problem.. 600 ? are u sure u need so much ? Ofocuse this is not the reason for Frequent database shutdowns...
open u r alert.log and see if there are any errors..
Paste them here if u find any...

sai

Report message to a moderator

Re: Why does my DB Server shut down frequently? [message #56634 is a reply to message #56627] Sun, 13 April 2003 18:44 Go to previous message
ahboer
Messages: 4
Registered: April 2003
Junior Member
I've reduce the "PROCESS" to "300",then the OS is not shutted,but appears the message like "the session is not enough...",I can't connect to the DB.Now I tuned the parameter:PROCESS is 1000,OPEN_CURSORS is 100.And I am waiting the result...

Report message to a moderator

Previous Topic: http service error
Next Topic: Problem on client disconnects randomly on terminal services
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:32:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.