Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ORA-03110

Posted on 2009-05-11
7
Medium Priority
?
941 Views
Last Modified: 2013-12-19
I am getting ORA-03110: end-of-file on communication channel error & getting disconneted from the DB while querying some time.

Since 2-3 days am getting this problem.

Oracle Server : 10.2.0.3
Client : 9.2.0.8

Sachin

0
Comment
Question by:sachin_dba
7 Comments
 
LVL 12

Expert Comment

by:rgn2121
ID: 24361687
Not sure if this will help, but this is what I found.
ORA-03110 ORA-03110: oranet: ORACLE does not support this SQL version Cause: The version of Oracle connected to via Net8 does not support the version of the Net8 protocol. Action: Upgrade the older version of Oracle and try again.
 
http://ora-03110.ora-code.com/ 
0
 
LVL 11

Expert Comment

by:Andytw
ID: 24362313
If you get an ORA-07445 or an ORA-0600 (internal error), the server process dies, and often a ORA-0311 is returned back to the session.  This can often be the sign of an Oracle bug.  
Do you have access to the DB alert log?  If so, check the alert log, and any any corresponding dump files.  The core dump often points you do the bit of SQL that was running at the time.  Armed with this you  should be in a position to determine if it's a documented bug.

For example:
[<ORACLE_HOME>\admin\SID\bdump\alert_test.log]
Errors in file e:\oracle\admin\test\udump\test_ora_3100.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [ptmak+420] [PC:0x620E984] [ADDR:0x10] [UNABLE_TO_READ] []

0
 

Author Comment

by:sachin_dba
ID: 24362488
No internal error on alert logs.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24363736
Not that this helps you diagnose the problem, but unless you have a good reason for 9i client, upgrade to 10g at least. 9i is no longer supported by Oracle, since 2007. Do you have a client side tool that cannot make use of 10g client?
0
 
LVL 48

Accepted Solution

by:
schwertner earned 1500 total points
ID: 24367796
Look for timeout in the firewall, some restriction in the profile.
Speak with the admins. Do they make some network changes - DNS, gateway settings, etc.
0
 
LVL 6

Expert Comment

by:tangchunfeng
ID: 24370595
The first investigation you should do is to test connect to the db server with an Oracle 10.2 client and do the same query to verify wheather it's caused by the version difference of oracle client
0
 

Author Closing Comment

by:sachin_dba
ID: 31580421
Problem resolved
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

879 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question