Home » RDBMS Server » Server Administration » Database Hang (10GR2,Win2003)
Database Hang [message #440742] Tue, 26 January 2010 22:21 Go to next message
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.

Re: Database Hang [message #440743 is a reply to message #440742] Tue, 26 January 2010 22:25 Go to previous messageGo to next message
ramoradba
Messages: 2454
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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/
Re: Database Hang [message #440751 is a reply to message #440743] Tue, 26 January 2010 22:46 Go to previous messageGo to next message
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
Re: Database Hang [message #440753 is a reply to message #440751] Tue, 26 January 2010 22:49 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: Database Hang [message #440754 is a reply to message #440751] Tue, 26 January 2010 22:51 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
'database not connected'

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

sriram Smile
Re: Database Hang [message #440755 is a reply to message #440754] Tue, 26 January 2010 22:55 Go to previous messageGo to next message
rtskrajan
Messages: 43
Registered: March 2007
Member
Yeah I am getting like that errors
Ora-03114,ORA-03113.

Thanks
Re: Database Hang [message #440757 is a reply to message #440755] Tue, 26 January 2010 23:00 Go to previous messageGo to next message
ramoradba
Messages: 2454
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 Go to previous messageGo to next message
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
Re: Database Hang [message #440759 is a reply to message #440758] Tue, 26 January 2010 23:06 Go to previous messageGo to next message
ramoradba
Messages: 2454
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
Re: Database Hang [message #440761 is a reply to message #440759] Tue, 26 January 2010 23:11 Go to previous messageGo to next message
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
Re: Database Hang [message #440763 is a reply to message #440761] Tue, 26 January 2010 23:16 Go to previous messageGo to next message
ramoradba
Messages: 2454
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
Re: Database Hang [message #440764 is a reply to message #440763] Tue, 26 January 2010 23:19 Go to previous messageGo to next message
ramoradba
Messages: 2454
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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?
Re: Database Hang [message #440766 is a reply to message #440765] Tue, 26 January 2010 23:28 Go to previous messageGo to next message
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.
Re: Database Hang [message #440767 is a reply to message #440761] Tue, 26 January 2010 23:28 Go to previous messageGo to next message
ramoradba
Messages: 2454
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.

Embarassed


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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: Database Hang [message #440769 is a reply to message #440768] Tue, 26 January 2010 23:35 Go to previous messageGo to next message
ramoradba
Messages: 2454
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
Re: Database Hang [message #440770 is a reply to message #440768] Tue, 26 January 2010 23:36 Go to previous messageGo to next message
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
Re: Database Hang [message #440775 is a reply to message #440770] Tue, 26 January 2010 23:50 Go to previous messageGo to next message
ramoradba
Messages: 2454
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 Go to previous message
rtskrajan
Messages: 43
Registered: March 2007
Member
OS: Win2003 Server Enterprise Edition R2 and SP2
Previous Topic: Data Base Configuration assistant not working in oracle 8.1.7 in windows server
Next Topic: ASM Confusions
Goto Forum:
  


Current Time: Thu Dec 08 06:24:37 CST 2016

Total time taken to generate the page: 0.08783 seconds