OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Database Hang (10GR2,Win2003)

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

Database Hang [message #440742]

Tue, 26 January 2010 22:21

rtskrajan
Messages: 43
Registered: March 2007

Member

Hi experts,
My server RAM is 12GB. i installed 10gr2 and implemented /3GB also. Eventhough my database is giving problem. Could you please give some valuable advice.

Thanks.

Report message to a moderator

Re: Database Hang [message #440743 is a reply to message #440742]

Tue, 26 January 2010 22:25

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

i am unable to see the problem here?

Do you?what/which kind of problem?

sriram Smile

[Updated on: Tue, 26 January 2010 22:25]

Report message to a moderator

Re: Database Hang [message #440749 is a reply to message #440742]

Tue, 26 January 2010 22:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Without additional details, no advice is possible.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Database Hang [message #440751 is a reply to message #440743]

Tue, 26 January 2010 22:46

rtskrajan
Messages: 43
Registered: March 2007

Member

Thanks for your reply...
Whenever our application is working, in between we are getting message like that 'database not connected'. total users are connected 60 to 70.

Thanks

Report message to a moderator

Re: Database Hang [message #440753 is a reply to message #440751]

Tue, 26 January 2010 22:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Enjoy your mystery.

Report message to a moderator

Re: Database Hang [message #440754 is a reply to message #440751]

Tue, 26 January 2010 22:51

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

'database not connected'

Is that like ...ORA-03114: not connected to ORACLE

sriram Smile

Report message to a moderator

Re: Database Hang [message #440755 is a reply to message #440754]

Tue, 26 January 2010 22:55

rtskrajan
Messages: 43
Registered: March 2007

Member

Yeah I am getting like that errors
Ora-03114,ORA-03113.

Thanks

Report message to a moderator

Re: Database Hang [message #440757 is a reply to message #440755]

Tue, 26 January 2010 23:00

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

ORA-03114
ORA-03114: not connected to ORACLE
Cause: A call to Oracle was attempted when no connection was established. Usually this happens because a user-written program has not logged on. It may happen if communication trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.
Action: Try again. If the message recurs and the program is user written, check the program.

Quote:

ORA-03113: end-of-file on communication channel
Cause: The connection between Client and Server process was broken.

Action: There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.

More over check you network connections.And consult you dba.
sriram Smile

[Updated on: Tue, 26 January 2010 23:02]

Report message to a moderator

Re: Database Hang [message #440758 is a reply to message #440757]

Tue, 26 January 2010 23:03

rtskrajan
Messages: 43
Registered: March 2007

Member

Thanks for your reply.
I thought this is may be server memory issue. Whenever i am getting problems, i am restarting the oracle services. Then it will ok for some more times.

Thanks

Report message to a moderator

Re: Database Hang [message #440759 is a reply to message #440758]

Tue, 26 January 2010 23:06

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

If it is a production environment then what will you do ?
do you restart the entire service?

RE read the cause and action in My post as they were produced by BY ORACLE.

sriram Smile

Report message to a moderator

Re: Database Hang [message #440761 is a reply to message #440759]

Tue, 26 January 2010 23:11

rtskrajan
Messages: 43
Registered: March 2007

Member

It is a Live Server. In this issues i am getting lots of pressure from end users. Thats why i am restarting the entire service.

Embarassed

Report message to a moderator

Re: Database Hang [message #440763 is a reply to message #440761]

Tue, 26 January 2010 23:16

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

check your alertlog file for the errors.And check your network connections more importantly consult your DBA as we dont know your network settings/sql net settings.

Trace out the cause and resolve.
Good luck
sriram Smile

Report message to a moderator

Re: Database Hang [message #440764 is a reply to message #440763]

Tue, 26 January 2010 23:19

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

And re read the cause here Answers for your Questions

sriram Smile

[Updated on: Tue, 26 January 2010 23:20]

Report message to a moderator

Re: Database Hang [message #440765 is a reply to message #440761]

Tue, 26 January 2010 23:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version

For how long have these errors been happening?

Report message to a moderator

Re: Database Hang [message #440766 is a reply to message #440765]

Tue, 26 January 2010 23:28

rtskrajan
Messages: 43
Registered: March 2007

Member

Thanks for your reply sir,
I am getting this error recently. Becoz we are started our application also recently. This is my oracle version.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

Thanks in advance.

Report message to a moderator

Re: Database Hang [message #440767 is a reply to message #440761]

Tue, 26 January 2010 23:28

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

rtskrajan wrote on Wed, 27 January 2010 10:41

It is a Live Server. In this issues i am getting lots of pressure from end users. Thats why i am restarting the entire service.

As mention it is 10gr2 and the server is windows 2003.
(Blackswan asked about 4 digit version number BY executing the Query posted please do so)

Quote:

Action: There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.

please contact support when you get you 3113 in production environment.

sriram Smile

[Updated on: Tue, 26 January 2010 23:31]

Report message to a moderator

Re: Database Hang [message #440768 is a reply to message #440766]

Tue, 26 January 2010 23:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> Becoz we are started our application also recently
2 or 3 tier application?

I suspect problem is root cause is external to DB.

Report message to a moderator

Re: Database Hang [message #440769 is a reply to message #440768]

Tue, 26 January 2010 23:35

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

It is a Live Server. In this issues i am getting lots of pressure from end users. Thats why i am restarting the entire service.

is that(restarting the entire service.) worked for you without any error?

sriram Smile

Report message to a moderator

Re: Database Hang [message #440770 is a reply to message #440768]

Tue, 26 January 2010 23:36

rtskrajan
Messages: 43
Registered: March 2007

Member

2 tier Application only.

I called one DBA from outside. He was telling may be a server or database memory issue.

Thanks

Report message to a moderator

Re: Database Hang [message #440775 is a reply to message #440770]

Tue, 26 January 2010 23:50

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

Post Operating System (OS) name & version for DB server system

which version of windows 2003 you are using?(R1,R2?)service pack ?
same problem for import operation..see this..

sriram Smile

[Updated on: Tue, 26 January 2010 23:52]

Report message to a moderator

Re: Database Hang [message #440776 is a reply to message #440775]

Tue, 26 January 2010 23:52

rtskrajan
Messages: 43
Registered: March 2007

Member

OS: Win2003 Server Enterprise Edition R2 and SP2

Report message to a moderator

Previous Topic:	Data Base Configuration assistant not working in oracle 8.1.7 in windows server
Next Topic:	ASM Confusions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 11:32:40 CST 2024