Home » Other » General » ora 03113
ora 03113 [message #220776] Thu, 22 February 2007 01:51 Go to next message
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
Re: ora 03113 [message #220779 is a reply to message #220776] Thu, 22 February 2007 02:01 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: ora 03113 [message #220785 is a reply to message #220783] Thu, 22 February 2007 02:18 Go to previous messageGo to next message
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
Re: ora 03113 [message #220788 is a reply to message #220785] Thu, 22 February 2007 02:29 Go to previous messageGo to next message
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
Re: ora 03113 [message #220789 is a reply to message #220788] Thu, 22 February 2007 02:33 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: ora 03113 [message #220796 is a reply to message #220791] Thu, 22 February 2007 03:08 Go to previous message
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
Previous Topic: Basics of Oracle Financials Implementation
Next Topic: YAHOO GROUPS - ORACLE WORLD - PLEASE JOIN
Goto Forum:
  


Current Time: Sat Dec 10 07:15:06 CST 2016

Total time taken to generate the page: 0.15554 seconds