| End of file at communication channel [message #111678] |
Fri, 18 March 2005 10:19  |
milind_sri
Messages: 70
Registered: February 2005
Location: Pune
|
Member |
|
|
Hello experts,
I have two same databases on two servers with same data.
Infact, I imported the same data in both the two servers.
The problem is there is a query which when executed on one server works fine but on another server it gives error:-
ORA-03113:end of file at communication channel
ORA-03114:not connected to oracle
The query is like this:-
select /* [[[SOPRejectionLetters.RejectionLettersContext]]] */
W.ATTORNEY_NAME AttorneyName,
W.ATTORNEY_LAWFIRM LawFirmName,
W.DOCUMENT_TYPE DocumentType,
W.DEFENDANT_NAME Defendant,
decode(W.BUS_NAME_ID, null, to_char(W.BUS_NAME_ID), W.BUS_NAME) ActualDefendant,
decode(W.BUS_NAME, null, E.TRUE_NAME, W.BUS_NAME) EntityName,
W.REP_ID RepId,
W.REP_JURIS_ID RepJurisId,
W.AGENT_INFO PresentAgent,
I.ADDRESS_LINE_1 AddressLine1,
I.ADDRESS_LINE_2 AddressLine2,
I.ADDRESS_LINE_3 AddressLine3,
I.ADDRESS_LINE_4 AddressLine4,
I.CITY CITY,
I.STATE State,
I.ZIP_CODE ZipCode,
M.FIRST_NAME || ' ' || M.LAST_NAME AS AssignedTo,
M.JOB_TITLE JobTitle,
(select max(decode(H.STATUS_CD, 6003, H.EFFECTIVE_DATE, ''))
from ARV_REP_HISTORY H
where H.REP_ID = W.REP_ID) ResignationDate,
W.WORKSHEET_ID WorksheetId,
W.REJECT_REASON_CD RejectionReason,
(select max(decode(H.STATUS_CD, 6002, H.EFFECTIVE_DATE, ''))
from ARV_REP_HISTORY H
where H.REP_ID = W.REP_ID) DiscontinuanceDate
from ARV_SOP_WORKSHEET W,
ARV_SOP_CONTACT_INFO I,
AV_SERVICE_TEAM_MEMBER M,
ARV_ENTITY E,
ARV_BUSINESS_NAME B
where W.WORKSHEET_ID = 510000156 and
W.ASSIGNED_TO = M.SERVICE_TEAM_MEMBER_ID and
W.BUS_NAME_ID = B.BUS_NAME_ID(+) and
B.ENTITY_ID = E.ENTITY_ID(+) and
W.WORKSHEET_ID = I.WORKSHEET_ID (+) and
I.CONTACT_INFO_TYPE(+) = 'A'
The error doesnt disconnect the session but the query fires the same error everytime. I dont understand when the two servers are having the same data,same indexes, same constraints why the query is running on one not on another.
Anybody has any idea why this is happening. I have come across this situation for the first time.
Any help is appreciated.
Thanks in advance.
Milind.
|
|
|
|
|
|
| Re: End of file at communication channel [message #111686 is a reply to message #111681] |
Fri, 18 March 2005 10:49  |
milind_sri
Messages: 70
Registered: February 2005
Location: Pune
|
Member |
|
|
Hello Mahesh,
Thanks for your quick response.
I have checked Alert.log and sqlnet.log files and couldnt find anything specific. I am sending you the sqlnet.log for your reference. can you pleas comment something by looking at it.
Thanks in advance
Milind.
|
|
|
|
|
|
| Re: End of file at communication channel [message #111691 is a reply to message #111690] |
Fri, 18 March 2005 10:57 |
milind_sri
Messages: 70
Registered: February 2005
Location: Pune
|
Member |
|
|
I can see this error in my sqlnet.log recurring:-
Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.5.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.5.0 - Production
Time: 13-MAR-2005 03:25:45
Tracing not turned on.
TNS-12638: Credential retrieval failed
nr err code: 0
ns secondary err code: 0
ns main err code: 12638
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
TNS-12638: Credential retrieval failed
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Milind.
|
|
|
|
|
|
| Re: End of file at communication channel [message #111698 is a reply to message #111697] |
Fri, 18 March 2005 12:16 |
milind_sri
Messages: 70
Registered: February 2005
Location: Pune
|
Member |
|
|
Hi Mahesh,
These are the contents of my SQLNET.ora file:-
# SQLNET.ORA Network Configuration File: D:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
NAMES.DIRECTORY_PATH= (TNSNAMES)
names.default_domain = THEDIGITALGROUP.COM
I dont know where is the problem. But, one more thing which I observed in the query is that whenever i remove the two subqueries related to ARV_REP_HISTORY view the query executes. And whenever I remover the outer joins on Worksheet_id and Contact_info in the where clause the query executes without giving any error. Can you pls. throw a light on this that why it is getting executed in this scenario.
Thanks
Milind.
|
|
|
|
|
|
| Re: End of file at communication channel [message #111701 is a reply to message #111699] |
Fri, 18 March 2005 12:39 |
milind_sri
Messages: 70
Registered: February 2005
Location: Pune
|
Member |
|
|
Hi Mahesh,
I have commented out all the lines as you said. But, the error is still there.
I dont understand what is the problem, when outer joins and sub-queries are removed the query executes and when they are there it gives error. But, executes on other server.
Regards
Milind.
|
|
|
|
|
|
| Re: End of file at communication channel [message #111820 is a reply to message #111705] |
Mon, 21 March 2005 02:40 |
_simma_dba
Messages: 34
Registered: November 2003
|
Member |
|
|
|
I had a similar error with my query. I had select from two views, basicly you have the same thing here because of subquery. But the real problem was that the tables in query was created with PARALLEL option. So when I include /*+ NOPARALEL*/ hint in my query I solve the problem. Try this, maybe it will help.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
