OraFAQ Forum: General

Home » Other » General » ora 03113

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

ora 03113 [message #220776]

Thu, 22 February 2007 01:51

rsenthil.aag
Messages: 5
Registered: February 2007
Location: bangalore

Junior Member

Hello all,
Here we have 200 machines connected to the server.
I have a problem on the client machine (NT/XP machines), when i try to connect using oracle client sqlplus 3.1/9.2 or any other applications, i get the error ora-03113.
If the connection is successful also, some time between the transaction the connection breaks.
The issue is very serious as it is a production database, and because of the the production is getting halted.

The memory configuration is as follows
shared pool - 356
buffer cache - 254
large pool - 80
pga - 500

If the service is restarted then it works fine for a day or such and later the problems repeats.

Any suggestion on this is appreciated.

thanks in advance
rsenthil

Report message to a moderator

Re: ora 03113 [message #220779 is a reply to message #220776]

Thu, 22 February 2007 02:01

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
ORA-03113
First place to see ALERT<SID>.LOG file.
and problem still happen CALL ORACLE SUPPORT.
and go http://METALINK.ORACLE.COM

BTW post here your ALERT<SID>.LOG file part when ora-03113 error raised.

regards
Taj

[Updated on: Thu, 22 February 2007 02:01]

Report message to a moderator

Re: ora 03113 [message #220783 is a reply to message #220779]

Thu, 22 February 2007 02:06

rsenthil.aag
Messages: 5
Registered: February 2007
Location: bangalore

Junior Member

Hello all,
Actually nothing is recorded in the alert log regarding this.
Do u want me to upload the alert< >.log file?

regards
rsenthil

Report message to a moderator

Re: ora 03113 [message #220785 is a reply to message #220783]

Thu, 22 February 2007 02:18

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Check UDUMP, CDUMP for any trace file generated related ora-03113 error.

If you have metalink access then just check out >>>
Note: 1020463.6

regards
Taj

Report message to a moderator

Re: ora 03113 [message #220788 is a reply to message #220785]

Thu, 22 February 2007 02:29

rsenthil.aag
Messages: 5
Registered: February 2007
Location: bangalore

Junior Member

Hai Taj,
thanks for the reply.
Hey my oracle license has expired, at present i cannot contact oracle for help. Regarding the trace file, tracing is on but i dont know why i am getting any info regarding this. Any other suggestion.

Hey once this problem was there before 3 weeks, at that time i created new listener log file and update the large pool size to 80mb, which made things work but only uptill now.
Now, do u want me to do the same.

My question is i am running 2 other database which is linked with on the same machine, which is not generating any problem.

regards
rsenthil

Report message to a moderator

Re: ora 03113 [message #220789 is a reply to message #220788]

Thu, 22 February 2007 02:33

rsenthil.aag
Messages: 5
Registered: February 2007
Location: bangalore

Junior Member

sorry that was,

tracing is on but i dont know why i am not getting any info regarding ora 03113

please bear with me.

regards
rsenthil

[Updated on: Thu, 22 February 2007 02:33]

Report message to a moderator

Re: ora 03113 [message #220791 is a reply to message #220788]

Thu, 22 February 2007 02:36

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
My question is i am running 2 other database which is linked with on the same machine, which is not generating any problem.

No, There is no problem you can have more than one database in single machine or more than one ORACLE_HOME also.

also take a look below link
http://www.dba-oracle.com/m_ora_03113_end_of_file_on_communications_channel.htm

and location of dump file you can find out through below query.

sql>show parameter dump

regards
Taj

Report message to a moderator

Re: ora 03113 [message #220796 is a reply to message #220791]

Thu, 22 February 2007 03:08

rsenthil.aag
Messages: 5
Registered: February 2007
Location: bangalore

Junior Member

Hey Taj,
that is what Taj, i get the error message every second, for instance when i try to log using sqlplus normally you have 3 tries, i try for 2 times and get this error some time later i try for the 3rd time it gets connected. some time, even after few minutes it generates this error, and more importantly, no other ora error messages such as ora 02608 ora ora 03114 with it.

i am completely fed up with this Taj.

regards
rsenthil

Report message to a moderator

Previous Topic:	Basics of Oracle Financials Implementation
Next Topic:	YAHOO GROUPS - ORACLE WORLD - PLEASE JOIN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 11:56:11 CDT 2024