Please note this query is resulting an output in Oracle 10G but the same is not working with Oracle 9i

SELECT ProviderName, ProviderID, Count(ProviderID) AS NumOfReferrals,  MAX(SubmitDate) AS MaxDate
FROM ReferralView
GROUP BY ProviderName, ProviderID;
I am given the below error trying to execute this query from the sql prompt and the session gets terminated.
ERROR at line 1:
ORA-03113: end-of-file on communication channel

Please update

Thank you

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SujithData ArchitectCommented:
Try these two alternatives.

SELECT ProviderName, ProviderID, Count(*) AS NumOfReferrals,  MAX(SubmitDate) AS MaxDate
FROM ReferralView
GROUP BY ProviderName, ProviderID;
SELECT ProviderName, ProviderID, Count(*) AS NumOfReferrals,  MAX(SubmitDate) AS MaxDate
SELECT ProviderName, ProviderID, SubmitDate, rownum r
FROM ReferralView
GROUP BY ProviderName, ProviderID;

Open in new window


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Apparently the error message is nothing to do with the given multiple aggregate functions in the SQL.
The error ORA-03113 occurs when an unexpected end-of-file occurred during the communication channel. There should be something else that is causing a communication failure between the server and your oracle client.

Are you using Unix or Linux environments where the environment variable TWO_TASK is set specifying that you are connecting to a remote server?

This error could also occur if the shadow two-task process associated with the connection terminated abnormally.

Let me check if there is any reference could be found on ORACLE and get back to you.

Good luck :)

Here it is, per the ORACLE documentation and description given for ORA-03113

ORA-03113 end-of-file on communication channel
Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8 two-task software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.

In addition, this message could occur when any of the following statements/commands have been issued:

Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of Oracle Support Services.

Hope this helps.
Good luck :)
SujithData ArchitectCommented:
>> ORA-03113: end-of-file on communication channel

Yes you are right.
It is a very vague error, which could be resulted from N number of reasons.

Most of the times, it could be becuase of a bug and it may require patching.
The best resolution is - to contact Oracle support. They can dig your trace files and log files to locate the actual problem.
Naveen KumarProduction Manager / Application Support ManagerCommented:
suryapinna: it would be good if you contact your DBA first for this error and then they can decide whether they need to go for oracle support or they can resolve it by themselves.

As updated already, query is fine and it has to work fine even in 9i. So request DBA's to have a look as to why you are getting ora-03113
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.