• RELEVANCY SCORE 5.01

    DB:5.01:Re: Ora-03113: End-Of-File On Communication Channel ck





    nope. nothing on the oracle side.... :(((

    DB:5.01:Re: Ora-03113: End-Of-File On Communication Channel ck

    I encountered once that a query caused a core dump on Oracle server. Then, the error poped up afterwards.

  • RELEVANCY SCORE 5.01

    DB:5.01:Re: "Ora-03113: End-Of-File On Communication Channel" m7





    Thx for reply Oracle version is "11.1.0.7.0"

    DB:5.01:Re: "Ora-03113: End-Of-File On Communication Channel" m7

    Sure, Do let us know if you receive any further feedback.Regards,Suntrupth

  • RELEVANCY SCORE 5.01

    DB:5.01:Ora-03113/Ora-06512: At "Sys.Utl_File" 3k





    I am able to write to file using UTL_FILE, and some times getting this error. ORA-03113: end-of-file on communication channel No change is PKG and every time it will generate new file,when re-execute again its getting this errorORA-29283: invalid file operationORA-06512: at "SYS.UTL_FILE", line 536ORA-29283: invalid file operation any clue?

    DB:5.01:Ora-03113/Ora-06512: At "Sys.Utl_File" 3k


    marias wrote:

    I am able to write to file using UTL_FILE, and some times getting this error. ORA-03113: end-of-file on communication channel

    No change is PKG and every time it will generate new file,when re-execute again its getting this error

    ORA-29283: invalid file operation
    ORA-06512: at "SYS.UTL_FILE", line 536
    ORA-29283: invalid file operation

    any clue?
    Can you debug code that you cannot see?Neither can anyone else.What does "ORA-29283: invalid file operation" suggest to you? What did you discover when you googled it?

  • RELEVANCY SCORE 4.96

    DB:4.96:Re: Cannot Startup Oracle Database m1


    ERROR at line 1:
    ORA-03113: end-of-file on communication channel
    Process ID: 10633
    Session ID: 1 Serial number: 5Please do check alert trace files for possible reasons.

    DB:4.96:Re: Cannot Startup Oracle Database m1

    784585 wrote:
    Have you installed team viewer?
    is so send your login and password to smart4u_143@yahoo.co.inNow, working place is not allowed to use kind of team viewer.

    I will come back to u again, when I setup my own personal environments.

    Thank you so much in advance.

  • RELEVANCY SCORE 4.63

    DB:4.63:Help Help Ora-00600 ad


    I have found this message in the File of ALERT

    Errors in file /global/eng/admin/udump/pag_ora_2477.trc:
    ORA-00600: internal error code, arguments: [729], [144], [space leak], [], [], [], [], []
    ORA-02068: following severe error from TO_PIPPO
    ORA-03113: end-of-file on communication channel
    ORA-02068: following severe error from TO_PLUTO
    ORA-03113: end-of-file on communication channel
    Thu Jan 12 13:39:52 2006
    Errors in file /global/eng/admin/udump/pag_ora_2477.trc:
    ORA-00600: internal error code, arguments: [ncodeffsheap], [], [], [], [], [], [], []
    ORA-00600: internal error code, arguments: [729], [144], [space leak], [], [], [], [], []

    you can help me

    thanks

    DB:4.63:Help Help Ora-00600 ad

    Metalink says "Do not use session_cached_cursors" if it can help...

    But you must open a SR (TAR) to be sure !

  • RELEVANCY SCORE 4.59

    DB:4.59:Re: Ora-03113: End-Of-File On Communication Channel cc


    861100 wrote:
    HI , i have oracle 11g ASM RAC under OEL 5.6 i do a cloning to cento 5.6 single node file system No Oracle version is certified on Centos

  • RELEVANCY SCORE 4.57

    DB:4.57:Re: Ora-16055: Fal Request Rejected k9


    ARC4: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
    Errors in file D:\ORACLE11G\diag\rdbms\namp\namp\trace\namp_arc4_5288.trc:
    ORA-03113: end-of-file on communication channel
    FAL[server, ARC4]: FAL archive failed, see trace file.
    Errors in file D:\ORACLE11G\diag\rdbms\namp\namp\trace\namp_arc4_5288.trc:
    ORA-16055: FAL request rejected

    so what clues exist in trace file?

    DB:4.57:Re: Ora-16055: Fal Request Rejected k9

    Did you solve this issue?
    If yes, can you please let me know.

    Thank you

  • RELEVANCY SCORE 4.57

    DB:4.57:Ora-02068,Ora-03113 ff


    Hi ,

    APPLn users are getting the below 2 errors when executing a job

    ORA-02068: following severe error from CONNECT_TO_ERJ
    ORA-03113: end-of-file on communication channelUser-Defined Exception

    Any idea what could be the reason for this

    Thanks,
    Kr

    DB:4.57:Ora-02068,Ora-03113 ff

    kurien wrote:
    Hi ,

    APPLn users are getting the below 2 errors when executing a job

    ORA-02068: following severe error from CONNECT_TO_ERJ
    ORA-03113: end-of-file on communication channelUser-Defined Exception

    Any idea what could be the reason for this

    Thanks,
    Kr--------------

    This is an issue with db-link or remote connection between the source and target, most likely due to communications failures between the two sites.

  • RELEVANCY SCORE 4.57

    DB:4.57:Ora-03113 End-Of-File On Communication Channel mc


    Hi All,
    While starting instance Oracle 8.16 for NT , I am struck up with error "ORA-03113 end-of-file on communication channel". This error is thrown while opening the datafile.

    Can anyone suggest me in this regard...

    thanks regards.

    DB:4.57:Ora-03113 End-Of-File On Communication Channel mc

    This error usually occurs when you force the session to close and terminate the connection (Eg: ctl-alt-del in windows env) while a process is running.

    This error is thrown while opening the datafile
    What you meant is not clear.

  • RELEVANCY SCORE 4.27

    DB:4.27:Ora 03113 End Of File On Communication Channel &Amp; Ora 03114 Not Connected 3m


    Hi,

    I am working on application using oracle, I get ORA-03113 followed by ORA-03114 .

    Could you please advise ?

    Where I can look, is there any oracle file can help me to investigate this issue.

    Thanks,

  • RELEVANCY SCORE 4.25

    DB:4.25:Ora-03113 End Of Communicatiob Channel s7


    Hello,

    what can I do, to solfe the problem ORA-03113?

    DB:4.25:Ora-03113 End Of Communicatiob Channel s7

    Hello,

    what can I do, to solfe the problem ORA-03113?

  • RELEVANCY SCORE 4.18

    DB:4.18:Ora-03113: End Of File On Communication Channel 3k


    hi
    I'm using Oracle8.1.7 on UnixWare7.1.1. When I tried startup database After databse mount and during open database is have ORA-03113: End of file on communication channel.

    thanks.

    Dung

    DB:4.18:Ora-03113: End Of File On Communication Channel 3k

    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:

    ALTER SYSTEM KILL SESSION ... IMMEDIATE
    ALTER SYSTEM DISCONNECT SESSION ... IMMEDIATE
    SHUTDOWN ABORT/IMMEDIATE/TRANSACTIONAL
    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.

    Joel Prez

  • RELEVANCY SCORE 4.14

    DB:4.14:Ora-03113: End-Of-File On Communication Channel dx


    Hi,
    I'm having the following error :

    ORA-03113: end-of-file on communication channel

    when trying to create a database. I have W2k with Oracle 8.1.7, I already try to re-install the product and the problem persists and I don't really what it could be.

    Any help would be greatly appreciated.

    Thanks,
    Juan

    null

  • RELEVANCY SCORE 4.14

    DB:4.14:Re: Ora-03113 End Of Comm. Channel When Using Order By 3d


    can you please post the query and table definition

    DB:4.14:Re: Ora-03113 End Of Comm. Channel When Using Order By 3d

    Hi All,

    The query was working in one schema but not another.
    After I analyzed the all the tables in the schema, it started working.
    When the tables weren't analyzed, I was getting ORA-03113.

    I did not do anything except for analyzing the tables.
    Can anyone explain why the qurey failed earlier?

    Aniket

  • RELEVANCY SCORE 4.14

    DB:4.14:Ora-03113 ak


    Hello all,

    I get the Error Message ORA-03113: end-of-file on communication channel
    when i issue SQL show parameter log in SQL*PLUS.

    Has anyone experienced the same error and how did you solve it ?

    Thanks in advance

    Ken

    DB:4.14:Ora-03113 ak

    Hello all,

    I get the Error Message ORA-03113: end-of-file on communication channel
    when i issue SQL show parameter log in SQL*PLUS.

    Has anyone experienced the same error and how did you solve it ?

    Thanks in advance

    Ken

  • RELEVANCY SCORE 4.14

    DB:4.14:Statspack xc


    hi

    while executing execute statspack.snap (i_snap_level=7, i_modify_parameter='true');

    am getting this error
    ORA-03113: end-of-file on communication channel

    SQL conn perfstat/perfstat
    Connected.
    SQL EXECUTE statspack.snap;

    BEGIN statspack.snap; END;

    *
    ERROR at line 1:
    ORA-03113: end-of-file on communication channel

    please help

    DB:4.14:Statspack xc

    Hi,

    Let me help you a bit :)

    ora-7445 you seen in trace file

    Please paste the call stack of the trace files

    Kind Regards,
    Rakesh Jayappa

  • RELEVANCY SCORE 4.12

    DB:4.12:Database Config Assistant Gets Ora-03113 End Of File Communication Channel mx


    Trying to run the database configuration assistant on Oracle v8i on NT to create a new database, but get Re: ORA - 03113 End of File communication channel when it tries to create the database files.

    SO I tried to create the database manually using srvmgrl, but when connecting internal I get prompted for a password.

    Has anybody seen this problem and is there a solution?

    DB:4.12:Database Config Assistant Gets Ora-03113 End Of File Communication Channel mx

    Trying to run the database configuration assistant on Oracle v8i on NT to create a new database, but get Re: ORA - 03113 End of File communication channel when it tries to create the database files.

    SO I tried to create the database manually using srvmgrl, but when connecting internal I get prompted for a password.

    Has anybody seen this problem and is there a solution?

  • RELEVANCY SCORE 4.12

    DB:4.12:Solving Ora-03113: End-Of-File On Communication Channel ff


    Hi All,

    We are getting the error below in the alert log file ,Let us know how we can solve this.

    Wed Feb 4 01:24:17 2009
    Incremental checkpoint up to RBA [0x1bcc4.46e3.0], current log tail at R
    cc4.68f6.0]
    Wed Feb 4 01:38:09 2009
    Errors in file /appl/APPSP01/u00/bdump/appsp011_reco_10516.trc:
    ORA-03113: end-of-file on communication channel
    Wed Feb 4 01:38:11 2009
    Errors in file /appl/APPSP01/u00/bdump/appsp011_reco_10516.trc:
    ORA-03113: end-of-file on communication channel
    Wed Feb 4 01:38:34 2009
    Errors in file /appl/APPSP01/u00/bdump/appsp011_reco_10516.trc:
    ORA-03113: end-of-file on communication channel
    Wed Feb 4 01:40:19 2009

    Tracefile ouput.

    Redo thread mounted by this instance: 1
    Oracle process number: 12
    Unix process pid: 10516, image: oracle@av1l546p (RECO)

    *** SERVICE NAME:(SYS$BACKGROUND) 2009-02-03 22:03:49.651
    *** SESSION ID:(1590.1) 2009-02-03 22:03:49.651
    *** 2009-02-03 22:03:49.651
    ERROR, tran=32.35.305496, session#=1, ose=0:
    ORA-03113: end-of-file on communication channel
    *** 2009-02-03 22:03:49.824
    ERROR, tran=11.17.336470, session#=1, ose=0:
    ORA-03113: end-of-file on communication channel
    *** 2009-02-03 22:03:49.996
    ERROR, tran=57.15.3862, session#=1, ose=0:
    ORA-03113: end-of-file on communication channel
    *** 2009-02-03 22:03:50.177
    ERROR, tran=20.40.317301, session#=1, ose=0:
    ORA-03113: end-of-file on communication channel

    DB:4.12:Solving Ora-03113: End-Of-File On Communication Channel ff

    Alert log of remote database............ is that what u mean??

  • RELEVANCY SCORE 4.12

    DB:4.12:Ora-03113: End-Of-File On Communication Channel Fnd_Web_Sec.Urlencrypt 3c


    Hi Team,We have EBS 11.5.|0.2 with DB 11.1.0.7 ON HPUX 11.23 .SQL select fnd_web_sec.URLEncrypt('hello', 'world') from dual;select fnd_web_sec.URLEncrypt('hello', 'world') from dual*ERROR at line 1:ORA-03113: end-of-file on communication channelProcess ID: 10119Session ID: 978 Serial number: 7Guido

    DB:4.12:Ora-03113: End-Of-File On Communication Channel Fnd_Web_Sec.Urlencrypt 3c

    Guido,I think this discussion will be locked for the same reason your other thread was locked -- https://forums.oracle.com/thread/2597639Please update your original post instead of creating a new one.Thanks,Hussein

  • RELEVANCY SCORE 4.12

    DB:4.12:Ora-03113 9x


    Hi,
    While running a pl/sql package i am getting an error like:
    ERROR at line 1:
    ORA-03113: end-of-file on communication channel.

    Does anyone have an idea and can help me out.

    thanks in advance.............

    DB:4.12:Ora-03113 9x

    ORA-03113 is a nasty error, which sometimes is hard to resolve. If you have access to metalink, follow the guidelines in this note:
    ORA-03113 on Unix - What Information to Collect
    Note:17613.1

    Werner

  • RELEVANCY SCORE 4.12

    DB:4.12:Ora-03113 Error When Using Loadjava dc


    I am trying to create a Java Stored Procedure and when I attempt to load the resource file into Oracle using the loadjava utility, I receive the following message:

    ORA-03113: end-of-file on communication channel

    I receive this message consistently.

    Any ideas?
    null

    DB:4.12:Ora-03113 Error When Using Loadjava dc

    There would be a trace file generated on the server where the database is installed, try to look in those trace files for additional messages and causes this might be happening, off hand I could also suggest increasing the processes init file parameter

  • RELEVANCY SCORE 4.12

    DB:4.12:Getting Ora-03113 Error While Creating Databse p7


    dear all

    i've successfully installed oracle 11g r2 on oel

    now while using dbca I'm getting ORA-03113 "end-of-file" on communication channel" error and I checked alert.log file, its written that:

    *ORA-00600: internal error code, arguments: [16305], [], [], [], [], [], [], [], [], [], [], []*

    Why I'm getting this error sudenly?

    thanks

    john

    DB:4.12:Getting Ora-03113 Error While Creating Databse p7

    Hi;

    Its a internal oracle error, which mean you may need to work wiht oracle support.First check below note,if its not help i suggest log a Sr

    Troubleshoot an ORA-600 or ORA-7445 Error Using the Error Lookup Tool [ID 153788.1]

    Regard
    Helios

  • RELEVANCY SCORE 4.12

    DB:4.12:Re: Ora-03113 End-Of-File On Communication Channel 9d


    Hi

    Check if sql*net Drivers are correctly installed and check for any trace files in Udump.

    DB:4.12:Re: Ora-03113 End-Of-File On Communication Channel 9d

    check for the time when you got the error message
    and check if some thing is written aganist connection.

  • RELEVANCY SCORE 4.04

    DB:4.04:Gather Schema Statistics Request Fails With Ora-03113 1a


    Hi All,

    We are run Oracle 9i R2 database 11i APPS.

    when we are run the Gather Schema Statistics concurrent request it's come with following error massege.

    Gather Schema Statistics concurrent request fails with following error:
    FDPSTP failed due to ORA-03113: end-of-file on communication channel

    Please help.

    DB:4.04:Gather Schema Statistics Request Fails With Ora-03113 1a

    Is this the only program that gives this error ? After how long does this error get generated ? Is the database being shut down when this concurrent is running ?

    Pl see MOS Docs

    1020463.6 - DIAGNOSING ORA-3113 ERRORS
    17613.1 - ORA-03113 on Unix - What Information to Collect

    You will most likely get a better/faster response by posting EBS questions on the EBS Forums at http://forums.oracle.com/forums/category.jspa?categoryID=3

    HTH
    Srini

  • RELEVANCY SCORE 4.04

    DB:4.04:Ora-03113 cx


    install ORACLE8.1.7 in REDHAT8

    when creat database occur ora-03113,end-of-file on communication channel

    what can I do?

    DB:4.04:Ora-03113 cx

    install ORACLE8.1.7 in REDHAT8

    when creat database occur ora-03113,end-of-file on communication channel

    what can I do?

  • RELEVANCY SCORE 3.99

    DB:3.99:Re: Ora-03113: End-Of-File On Communication Channel 9z


    post also

    rmanlist backup;

    Edited by: Niket Kumar on Oct 31, 2012 6:26 PM

    DB:3.99:Re: Ora-03113: End-Of-File On Communication Channel 9z

    968599 wrote:
    Dear Shivanand,

    delete expired archivelog all; this will delete my database.

    and you said to take backup of database.

    Please may i know how to do it.?No only the expired Archivelog .

  • RELEVANCY SCORE 3.99

    DB:3.99:Ora-3113 Happens,When I Use Dbms_Streams_Adm.Set_Up_Queue. j8


    I get the error ORA-03113: end-of-file on communication channel.

    BEGIN
    DBMS_STREAMS_ADM.SET_UP_QUEUE(
    queue_table = 'instream_queue_table',
    queue_name = 'instream_queue',
    queue_user = 'strmadm');
    EXCEPTION WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('Error happens when trying to setup input stream queue');
    END;
    /

    the error is :
    ORA-03113 : end-of-file on communication channel.

    DB:3.99:Ora-3113 Happens,When I Use Dbms_Streams_Adm.Set_Up_Queue. j8

    hi,Mohammad Taj

    you suggest that I shoule look for some informations in the alert_sid file.
    But I can not find any ora error or warning.
    thank you.
    Later,I can not access the metalink for I have not ID.

  • RELEVANCY SCORE 3.97

    DB:3.97:I Figure Out Ora-03113 j1


    Hi,everyone:
    I figure out the ORA-03113 end-of-file
    ..communication channel which arise from
    the creatation of DB,The following is the key

    SQLNET.AUTHENTICATION_SERVICES= (BEQ, NONE)

    modify that string into the upper one in sqlnet.ora.
    I Hope Help You!
    null

    DB:3.97:I Figure Out Ora-03113 j1

    Hi,

    Either comment out the SQLNET.Auth.. line in sqlnet.ora or set it as below,

    SQLNET.AUTHENTICATION_SERVICES= (NONE)

    Hope this helps,
    null

  • RELEVANCY SCORE 3.95

    DB:3.95:Ora - 03113 End Of File Communication Channel pa


    After I started up the database , I can able to log on to
    scott user. there I can able to do all the DML operations,
    But It was showing this error...
    ORA - 03113 End of file Communication channel...
    when I describe any table....

    what should I do...

    Please let me know....

    thank u

    DB:3.95:Ora - 03113 End Of File Communication Channel pa

    it quiet hard to troubleshoot. Alway as sys-dba we just drop an email to application team to handle it..

    Need to find a better way to resovle this problems

  • RELEVANCY SCORE 3.94

    DB:3.94:Re: Frm-40735: On_Error Trigger Raised Unhandled Exception Ora-01001 jj


    FRM-40735: ON_ERROR trigger raised unhandled exception ORA-01001SQL select fnd_web_sec.URLEncrypt('hello', 'world') from dual;select fnd_web_sec.URLEncrypt('hello', 'world') from dual*ERROR at line 1:ORA-03113: end-of-file on communication channelProcess ID: 10119Session ID: 978 Serial number: 7

    DB:3.94:Re: Frm-40735: On_Error Trigger Raised Unhandled Exception Ora-01001 jj


    938302 wrote:

    Hi, I applied the action plan, but the error persist.

    Guido
    This is what I was expecting Please log a SR, and Oracle support should be able to help -- Be prepared to collect log files and obtain trace files!Thanks,Hussein

  • RELEVANCY SCORE 3.94

    DB:3.94:Ora-03113 End-Of-File On Communication Channel jd


    hi,

    i am using oracle 11g R1 in windows service pack 2 32 bit processor .I get the ora-03113 end-of-file on communication channel error. Is there any proper solution for this error????

    thanks in advance

    DB:3.94:Ora-03113 End-Of-File On Communication Channel jd

    793097 wrote:

    i have searched about thses errors and i got a lot of information but i am trying to stimulate the same error in my test database. plz suggest me some ideas to stimulate the same error in my test database.Use the v$session and v$process views to find the Oracle server process that services the client session. Determine that server process's process ID (column spid if I recall correctly). Then kill that server process - using the kill (Linux/Unix) command, or something that I believe is called orakill on Windows.

    A real ORA-3113 is usually caused by something like an ORA-600 in the server process - which includes error messages in the alert log and at least a trace file. A physical process kill will not result in that. However, it will duplicate the sudden disappearance of the server process from the client process's perspective.

  • RELEVANCY SCORE 3.93

    DB:3.93:Re: Ora-03113: End-Of-File On Communication Channel: Delivered Oracle Sql 3c


    .

    Edited by: N. Gasparotto (metalink3) on Aug 12, 2009 7:57 PM

    DB:3.93:Re: Ora-03113: End-Of-File On Communication Channel: Delivered Oracle Sql 3c

    I'm pretty sure (but we never know), first Oracle support advice will be an upgrade.
    Then it is maybe time for an upgrade to the latest patchset, 10.2.0.4, 1) to get it work 2) to come back on supported configuration with Peopletools/Oracle version

    Good luck,

    Nicolas.

  • RELEVANCY SCORE 3.93

    DB:3.93:Ora-03113: End-Of-File On Communication Channel cj


    hi,
    I am using database 10g rel 10.1.0.2.0 with developer 6i.When i am trying to create connect string it is giving error
    ORA-03113: end-of-file on communication channel
    help me please.

    DB:3.93:Ora-03113: End-Of-File On Communication Channel cj

    ORA-03113: end-of-file on communication channel
    Cause: The connection between Client and Server process was broken.
    Action: There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.
    Normally the error is seen when the database is going for a bunce and you were connected with it.In that process the link between the client and server is gone and hence you recieve the error.
    PLease check what is mentionedin the description and also that the db is up.
    Aman....

  • RELEVANCY SCORE 3.91

    DB:3.91:Re: Ora-03113 Urgent Help Required sa


    i m really sorry to say that i m not able to find the alert.log file, got an empty bdump folder other provided solutions are also useless.......

    i have learnt that this problem can be caused because of lack of resources. if u could help in this way please help........

    i have searched over net using "ora-03113 : end-of-file at communication channel"

    DB:3.91:Re: Ora-03113 Urgent Help Required sa

    ORACLE_SID is OK as the application and database were running well earlierIm sorry, actually i m able to enter sql prompt using /nolog option however i cant do anything out there without the privileges.It is good idea to Contact the Oracle support team so i think we need to close this issue here...

  • RELEVANCY SCORE 3.90

    DB:3.90:Re: The Page Cannot Be Found | End-Of-File On Communication Channel mk


    Hi Alex,

    For an ORA-03113 you will definitely want to file that with Oracle Support if you haven't already.

    John.
    --------------------------------------------
    http://jes.blogs.shellprompt.net
    http://www.apex-evangelists.com

    DB:3.90:Re: The Page Cannot Be Found | End-Of-File On Communication Channel mk

    Alex,

    Now, can I say it's networking problem?No..the ORA-03113 means that it's definitely something the DB is hitting, rather than a networking problem.

    Oracle support is definitely best positioned to help you right now.

    John.
    --------------------------------------------
    Blog: http://jes.blogs.shellprompt.net
    Work: http://www.apex-evangelists.com
    Author of Pro Application Express: http://tinyurl.com/3gu7cd

  • RELEVANCY SCORE 3.90

    DB:3.90:Re: Ora-03113: End-Of-File On Communication Channel pd


    Santosh,

    How come I know that backup is healthy ?

    DB:3.90:Re: Ora-03113: End-Of-File On Communication Channel pd

    Hi Santosh.

    1. I don't have any exp in database. But I have read somewhere that if your database is running in Archive mode then you can take the corrupted datafile offline during mount stage(if system and undo is intact) and open the database.

    2. if you resize your datafile it will discard the inaccessiable block(corrupted block) definately there will be data loss).

    This is only a guess. I am not very sure. Please advice. Is not it work that way?

  • RELEVANCY SCORE 3.86

    DB:3.86:Re: Ora-03113: End-Of-File On Communication Channel c9


    while running utlrp.sql getting the error message:

    DOC 1. Query showing jobs created by UTL_RECOMP
    DOC SELECT job_name FROM dba_scheduler_jobs
    DOC WHERE job_name like 'UTL_RECOMP_SLAVE_%';
    DOC
    DOC 2. Query showing UTL_RECOMP jobs that are running
    DOC SELECT job_name FROM dba_scheduler_running_jobs
    DOC WHERE job_name like 'UTL_RECOMP_SLAVE_%';
    DOC#
    DECLARE
    *
    ERROR at line 1:
    ORA-03113: end-of-file on communication channel

    ERROR:
    ORA-03114: not connected to ORACLE

    --------------------------------------------------------------

    DB:3.86:Re: Ora-03113: End-Of-File On Communication Channel c9

    Hi Team,

    The issue resolved after bouncing the database.

    Thanks,
    Mukarram

  • RELEVANCY SCORE 3.86

    DB:3.86:Oracle Installation Error Ora-03113 cp


    Hi!

    I am trying to installa Oracle 9.2 on Windows XP OS. I get an error when try to create a database . 'ORA-03113'

    ORA-03113: end-of-file on communication channel
    Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.7.0 - Production

    Is there easy wat to fix this?

    Ramesh

    DB:3.86:Oracle Installation Error Ora-03113 cp

    Hi! Sreedhar,

    I have successfuly installed on Windows XP before. It is strange now I am getting this error.

    Ramesh

  • RELEVANCY SCORE 3.86

    DB:3.86:Dbca Ora-03113: End-Of-File On Communication Channel 7p


    Hi, after installing 9.2.0.1.0 on a Debian box, I cannot success creating database with dbca, allways getting the most ennoying:

    ORA-03113: end-of-file on communication channel

    kernel 2.4.20
    system is a Celeron with 512 Ram
    swap is 1GB
    kernel.sem = 250 32000 100 128
    kernel.shmmax = 263647232

    what should I dooooooooooo ?

    DB:3.86:Dbca Ora-03113: End-Of-File On Communication Channel 7p

    I struggled with the install for quite a while, with lots of odd errors. I finally tracked it down (thru google etc) to a problem with NS_LANG support. I had not set it up properly.
    Check to see if you have it setup.

    You should have something like LANG=en_GB set in your environment, but will need to check tools too.

    This is just a suggestion, but fixed my problems.
    Now it runs sweet :)

    /Anthony/

  • RELEVANCY SCORE 3.84

    DB:3.84:Ora-03113 xd


    ORA-03113 end-of-file on communication channel

    PLS I NEED A RECOVERY FOR THIS PROBLEM

    I DON'T FIND A TRACE FILE WHEN THE ERROR ACCURE

    PLS DO YOU KNOW ANY SOLVING PROBLEMS

    DB:3.84:Ora-03113 xd

    I have data base connection between 2 servers:
    First one is for Database.
    Second one is for web server(web sphere) and e-banking application
    these servers are connected through pix.
    we installed oracle 10g as database server, and oracle 9i as database client where the web server is located.
    i can make connection to the database, but after a while (more then 30 minuets) the connection to oracle will close
    and if i try to make any query by using SQL+ i ll get this error:
    ORA-03113:end-of-file on communication channel.

    and to have a connection i have to restart the application.

  • RELEVANCY SCORE 3.83

    DB:3.83:Ora-03113 On 10.1.0.4 Rac sc


    We are testing TAF Oracle 10g RAC 10.1.0.4. Our cluster consists of two computers. On client system we start several sqlplus windows with select statement. All sqlplus sessions are logged in one instance, then we take out ethetnet cable from this instanse. In some windows we get ORA-03113:end-of-file on communication channel, in other windows we se that our query comlets successfull. Can you help to fix ORA-03113 error?

    DB:3.83:Ora-03113 On 10.1.0.4 Rac sc

    We are testing TAF Oracle 10g RAC 10.1.0.4. Our cluster consists of two computers. On client system we start several sqlplus windows with select statement. All sqlplus sessions are logged in one instance, then we take out ethetnet cable from this instanse. In some windows we get ORA-03113:end-of-file on communication channel, in other windows we se that our query comlets successfull. Can you help to fix ORA-03113 error?

  • RELEVANCY SCORE 3.83

    DB:3.83:Rcount Causes Ora-03113 Error m8


    Hi gurus,

    We have a strange situation here. We have couple of dashboards running successfully for the past one year or so. Couple of reports with RCOUNT started causing ORA-03113 end-of-file communication error.

    Has anybody experiended this error?

    Regards
    Mahesh

    DB:3.83:Rcount Causes Ora-03113 Error m8

    See the below link,it may help you.

    http://dbaspot.com/ora-03113-end-of-file-on-communication-channel.html

    Thanks,
    Balaa...

  • RELEVANCY SCORE 3.82

    DB:3.82:Re: Jaro_Winkler_Similarity Vs Edit_Distance_Similarity For String Comparison 3f


    Hi Justin,

    I still received the error on Sql * Plus

    ORA-03113: end-of-file on communication channel

    Can you suggest something for me.

    Thanks

    DB:3.82:Re: Jaro_Winkler_Similarity Vs Edit_Distance_Similarity For String Comparison 3f

    Thanks Justin for all the advice and support . For the time being we have used the Edit_Distance Similarity function , by the next release after few patches update and client upgradation we will be using that JaroWinkler_Similarity.
    Once again I thank you for the support.

    Venu

  • RELEVANCY SCORE 3.82

    DB:3.82:Ora-03113: End-Of-File On Communication Channel c9


    I get this error when trying to install Oracle 9.2 on RH ADV 2.1 ORA-03113: end-of-file on communication channel.

    DB:3.82:Ora-03113: End-Of-File On Communication Channel c9

    I have the same problem.According to the previous page,somebody suggest that the installed machine should have at least 256 MB RAM.But I have 512 MB RAM,I still encounter this problem.Anyone can help me.Thank a lot!

  • RELEVANCY SCORE 3.82

    DB:3.82:Ora-03113: End-Of-File On Communication Channel fc


    Hi

    I'm building a Portal Report with the following line in the where clause

    portal.wwsto_api_session.load_session
    ('iPortal','SENIAT').get_attribute_as_number
    ('a_id_tramite_hist')

    if I leave the line and press ok to compile the report is throws

    ORA-03113: end-of-file on communication channel

    if I take it out it works fine

    DB:3.82:Ora-03113: End-Of-File On Communication Channel fc

    Hi,

    You can use this only as part of a plsql block and cannot include it in a SQL statement.

    Here is an example of how to use it.

    declare
    l_user_obj portal30.wwsto_api_session;
    begin
    l_user_obj := portal30.wwsto_api_session.load_session
    (
    p_domain = 'PORTAL',
    p_sub_domain = 'TEST'
    );
    l_last_accessed := l_user_obj.get_attribute_as_date
    (
    p_name = 'LAST_ACCESSED'
    );
    end;

    Thanks,
    Sharmila

  • RELEVANCY SCORE 3.81

    DB:3.81:Ora-03113: End-Of-File On..... After Normal Database Shutdown 1p


    OS : Windows 2003 server
    DB: 10 r2

    Oracle Service ORCL -Configured with autostart

    After shutting down the database
    the instance is also automatically shuts down
    followed by
    ORA-03113: end-of-file on communication channel

    hence i need to restart the ORACLE INSTANCE MANUALLY by issuing the following command
    ORADIM -STARTUP -SID ORCL -STARTTYPE SRVC -SPFILE

    Now I have to re-connect to oracle instance [Idle Instance ] then start the database as normal

    Any suggestions and solutions are welcomed !

    DB:3.81:Ora-03113: End-Of-File On..... After Normal Database Shutdown 1p

    What do you mean with 'instance' here,the Windows service? A shutdown command in sqlplus always shuts down the Oracle instance,i.e. background processes and SGA allocation, existing sessions throw ORA-03113. . If you shutdown the service (in services panel or by 'net stop OracleServiceORCL), all goes down.

    Werner

  • RELEVANCY SCORE 3.81

    DB:3.81:Ora-03113 j7


    Hello,

    I get an error "ORA-03113: end-of-file on communication channel"
    when I try to acces to my database (8.1.6)
    What can I do to correct it ? (I can't even restart the database
    to clean it...)

    DB:3.81:Ora-03113 j7

    errr.... I'm confused, Did you manage to login to the database via Bequeath protocol? If yes, then what's stopping you shutting down the database???

  • RELEVANCY SCORE 3.81

    DB:3.81:Re: Ora-03113: End-Of-File On Communication Channel 9z


    You can go to this link.

    [http://www.expertsharing.com/2008/05/15/ora-03113-end-of-file-on-communication-channel/]

    Regards
    Asif Kabir

    DB:3.81:Re: Ora-03113: End-Of-File On Communication Channel 9z

    Hi OrionNet,
    I do not have access to Metalink. Would you be kind enough to post the solution. I really appreciate your time.

  • RELEVANCY SCORE 3.80

    DB:3.80:Ora-03113 x9


    On Solaris 8, I installed Oracle8i, Release 3 (8.1.7).
    When I try to start database from svrmgrl I've got this message:
    "ORA-03113: end-of-file on communication channel"

    What I do wrong?

    Thanks
    Leandro

    DB:3.80:Ora-03113 x9

    On Solaris 8, I installed Oracle8i, Release 3 (8.1.7).
    When I try to start database from svrmgrl I've got this message:
    "ORA-03113: end-of-file on communication channel"

    What I do wrong?

    Thanks
    Leandro

  • RELEVANCY SCORE 3.80

    DB:3.80:Ora-03113 End-Of-File On Communication Channel 81


    Hi,

    I've created a RAC 10.2.0.1 on VmWare, Linux with 2 nodes. After rebooting both nodes, I can't start instances. All other services are started but instances and db don't start.
    Used sqlplus to start instance. It mounted but didn't open and got ora-03113 error.
    Any suggestions?

    DB:3.80:Ora-03113 End-Of-File On Communication Channel 81

    Hi,

    this problem description is a bit too general, I would think. Besides the fact that you use 10.2.0.1 (in VMware), which has potential for a number of patches for existing BUGs, you would need to investigate on the error.

    Since sqlplus issues an error as well, you may assume that it is a DB-related error (Clusterware does not cause it in the first place). Thus, please, start with checking the Alert.logs (all instances) and let us know whether or not you find something.

    Just a first idea. Thanks.

  • RELEVANCY SCORE 3.80

    DB:3.80:Ora-03113: End-Of-File On Communication Channel dz


    Hello,

    When I tried to log into sqlplus, I received the error: ORA-03113: end-of-file on communication channel.

    How can I resolve this ?

    (Oracle 8; Windows 2000)

    Thanks !

    DB:3.80:Ora-03113: End-Of-File On Communication Channel dz

    Hi,
    Make sure you do not have SQLNET.AUTHENTICATION_SERVICES=(NTS) in the sqlnet.ora if you're connected to the machine as a domain user but there is currently no network connection.

    Also , check the connection to the domain controller

    Yogi
    yogendra.saini@iflexsolutions.com

  • RELEVANCY SCORE 3.80

    DB:3.80:Re: Ora-03113: End-Of-File On Communication Channel fs


    Have you checked with AlertSID.log file for database ?

    Cheers, Bhupinder

    DB:3.80:Re: Ora-03113: End-Of-File On Communication Channel fs

    Hi,

    Instead of create a database directly (GUI mode), I think you will need generate the scripts database creation using the DBCA and after this execute the script manually in order to see what statement is generating this error.

    Cheers

  • RELEVANCY SCORE 3.80

    DB:3.80:Loadjava Utitlity Gives Error Ora-03113 m8


    hello ,
    While executing loadjava for 'helloworld' with scott/tiger I am getting the error ORA-03113 - end-of-file on commmunication channel.. I am runnig Oracle 8.1.5 on AIX machine and connecting to database through local connection (thru TNVT plus) ...
    null

    DB:3.80:Loadjava Utitlity Gives Error Ora-03113 m8

    Hi,

    I just learned yesterday that AIX has patched JDBC drivers which are later than the ones distributed with JDeveloper 3.0.

    I believe the patch contains a new classes111.zip file which you need to use to replace the classes111.zip file in JDEV_HOME\jdbc\lib\oracle8.1.5.

    If you need a patch reference, it is bug883333.

    Laura

  • RELEVANCY SCORE 3.80

    DB:3.80:Re: Error Ora-03113: End-Of-File On Communication Channel In Droppping A T zd


    Hi,

    Sorry, type analyze table table_name compute statistics, but if the tables already empty, then I think there is no effect.

    Cheers

    DB:3.80:Re: Error Ora-03113: End-Of-File On Communication Channel In Droppping A T zd

    Hi Anna,

    I think that this problems will take me a lot of time. :(

    Already it take lot of time... your first post is "Oct-27". ;-)

    regards
    Taj.

  • RELEVANCY SCORE 3.80

    DB:3.80:Ora-03113: End-Of-File On Communication Channel 8j


    Hi all,

    OS: Win 2002
    Oracle: 11.2

    ORA-03113: end-of-file on communication channel

    Found this error when i tried to open my database. please help me in this.

    Thanks,
    Sathiesh

    DB:3.80:Ora-03113: End-Of-File On Communication Channel 8j

    Sathiesh wrote:
    Hi,

    I followed that link and got this error,

    SQL Recover database using backup controlfile;
    ORA-00279: change 1571911 generated at 08/24/2012 10:01:38 needed for thread 1
    ORA-00289: suggestion :
    C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ARCHIVELOG\2012_08_28\O1_MF_1_1_%U

    _.ARC
    ORA-00280: change 1571911 for thread 1 is in sequence #1

    Specify log: {RET=suggested | filename | AUTO | CANCEL}
    cancel
    Media recovery cancelled.
    SQL

    Thanks,
    SathieshThe ORA-00279 error indicates a missing redo log! ,

    ORA-00279: change string generated at string needed for thread string

    Cause: The requested log is required to proceed with recovery.

    Action: Please supply the requested log with "ALTER DATABASE RECOVER LOGFILE file_name" or cancel recovery with "ALTER DATABASE RECOVER CANCEL".

  • RELEVANCY SCORE 3.80

    DB:3.80:Ora-03113 dm


    After running a script to insert 10000000 records my hard disk got full. And after that when i am trying to login it is giving error like ORA-03113 End-of-File communication channel.

    DB:3.80:Ora-03113 dm

    After running a script to insert 10000000 records my hard disk got full. And after that when i am trying to login it is giving error like ORA-03113 End-of-File communication channel.

  • RELEVANCY SCORE 3.80

    DB:3.80:"Ora-03113: End-Of-File On Communication Channel" Help!! pz


    On Win 2000, I installed Oracle8i Ent, Release 3 (8.1.7).
    When I try to start database I've got this message:
    "ORA-03113: end-of-file on communication channel"

    Whats Happening?

    Thanks

    sgriffin@mobileaware.ie

    DB:3.80:"Ora-03113: End-Of-File On Communication Channel" Help!! pz

    On Win 2000, I installed Oracle8i Ent, Release 3 (8.1.7).
    When I try to start database I've got this message:
    "ORA-03113: end-of-file on communication channel"

    Whats Happening?

    Thanks

    sgriffin@mobileaware.ie

  • RELEVANCY SCORE 3.80

    DB:3.80:Ora-03113 End-Of-File On Communication... While Creating Database On Linux j1


    Oracle version: 8.1.7 on Redhat 8.0

    Hi,

    As I try to create an initial database through svrmgrl, using this command: "startup nomount pfile=...",
    the following error occurs: "ORA-03113 end-of-file on communication channel".

    Did someone solve this problem?

    Thx

    DB:3.80:Ora-03113 End-Of-File On Communication... While Creating Database On Linux j1

    i finally managed to succesfully install 8iR3 on Red Hat 8.0 with some help from the Red Hat psyche-list. here's how to it:

    - run installer with installation type: Custom. NB: only install software do not create database.
    - i had to fix syntax errors in $ORACLE_HOME/root.sh (see lines with 'RMF=' and 'RUID=') before running it
    - install 8.1.7.4 patch set (2376472) from Metalink (should not be absolutely necessary)
    - install the glibc-stubs patch (glibc-2.1.3-stubs.tar.gz) from OTN (this is very important)
    - run $ORACLE_HOME/bin/dbassist to create database

    also, because on my system output entries from df can span multiple lines i had to replace /bin/df with a script that adds '-P' option to the df command line. otherwise the installer was not able to parse df output when checking available disk space.

  • RELEVANCY SCORE 3.80

    DB:3.80:Ora- 03113 And Ora-01031 Errors 7c


    Hi all
    Please help when i login through remote login with sysdba and i try to change the password for users I am getting this error
    ORA- 03113: end-of-file on communication channal

    On another database i cannot login through INTERNAL user getting error ORA- 01031: Insufficient privilages.

    Please help

    DB:3.80:Ora- 03113 And Ora-01031 Errors 7c

    Hi Jagjit,

    ORA-3113 may be the cause of n number of problem. few tips :

    o check if you can connect from a different client.
    o check the init.ora remote_login_passwordfile parameter. it should be set to exclusive.

    just my 2 cents,
    G

  • RELEVANCY SCORE 3.80

    DB:3.80:Ora-03113 jz


    Hi,
    For my 11g Express that resides in Win 08 server, I've got this

    SQL conn system as sysdba
    Enter password:
    ERROR:
    ORA-03113: end-of-file on communication channel
    Process ID: 0
    Session ID: 0 Serial number: 0

    Why?
    Many Thanks Best Regards,
    HuaMin

    DB:3.80:Ora-03113 jz

    did you check alertlog ?
    share the Alertlog file contents

  • RELEVANCY SCORE 3.80

    DB:3.80:Regarding :Ora-03113: End-Of-File On Communication Channel 9j


    Hi All,

    While starting the database i am geeting this error.....

    ORA-03113: end-of-file on communication channel
    Process ID: 9974
    Session ID: 125 Serial number: 5

    can you help me on this......

    ThanksRegards
    Shiva

  • RELEVANCY SCORE 3.80

    DB:3.80:Ora-03113 :End-Of-File On Communication Channel At Oci Call Ocistmtexecute z9


    Hi experts ..

    when i am running my reports in OBIEE, i am getting this error:

    ORA-03113:end-of-file on communication channel at OCI call OCIStmtExecute

    So Please suggest me how can we resolve this....

    Thanks in advance

    Regards
    Frnds

    DB:3.80:Ora-03113 :End-Of-File On Communication Channel At Oci Call Ocistmtexecute z9

    That error usually means you Oracle DB crash dumped. Look at your DB alert log and get your DBA involved.

  • RELEVANCY SCORE 3.80

    DB:3.80:Re: Ora-03113: End-Of-File On Communication Channel j7


    Put this into your sqlnet.ora
    sqlnet.expire_time=0
    it will disable dead connection detection.
    There are several bugs relating to this features causing core dumps.

  • RELEVANCY SCORE 3.80

    DB:3.80:Ora-03113 / Ora-07445 [25] [0] [] [] [] [] m8


    I consistently get an ORA-03113 End of File on communication channel when querying a large table. The alert log shows an ora-07445 [25] [0] [] [] [] [] with a core dump. I have seen a several 7445's with exception signal [11] on OTN but have not seen anyone report a [25].

  • RELEVANCY SCORE 3.80

    DB:3.80:Ora-03113: End-Of-File On Communication Channel sa


    Hi,
    when I am trying to connect localy or remotly to oracle instance it gives this error .
    ORA-03113: end-of-file on communication channel

    I already uninstalled and reinstalled oracle9i R2 software but nothing happend, waiting for reply
    Thanks in advance, Khawar

    DB:3.80:Ora-03113: End-Of-File On Communication Channel sa

    Hi,
    this kind of errors is often caused by an interruption on the network. Check if you have installed software like firewalls or network antivirus. Try also to connect localy without specify the connection string:
    sqlplus /nolog
    connect system/manager

    Hope helps
    Sam

  • RELEVANCY SCORE 3.80

    DB:3.80:Ora-03113: End-Of-File On Communication Channel Problem c8


    Hi,

    issue in Opening the Database:

    ORA-03113: end-of-file on communication channel

    sqlplusStarup
    The Database is Mounted but could not open and giving error as:

    ORA-03113: end-of-file on communication channel

    Any help will be needful for me

    I ahve see the listener and its getting started by seeing the lsnrctl status

    DB:3.80:Ora-03113: End-Of-File On Communication Channel Problem c8

    Hi,

    this is not an issue with SQL or PL/SQL. Talk to your DBA and have him a look at the alert.log at the server. Also there should be a trace file. If not get support from Oracle for the issue.

    Herald ten Dam
    superconsult.nl

  • RELEVANCY SCORE 3.80

    DB:3.80:Ora-03113: End-Of-File On Communication Channel za


    HI All,

    While adding datafile to a tablespace following error comes :
    ORA-03113: end-of-file on communication channel

    file is added at os level but missing at database level.

    os : RedHat AS
    oracle 9i R2

    Please suggest.

    Thanks in Advance,
    Vivek

    DB:3.80:Ora-03113: End-Of-File On Communication Channel za

    If I don't understand what the meaning to check v$datafile, it is really wrong do not get any rows into that table.
    For your 3113 error, please go through Metalink.

    Nicolas.

  • RELEVANCY SCORE 3.80

    DB:3.80:Ora-03113: End-Of-File On Communication Channel 8x


    HI ALL,
    I AM INSTALLING ORACLE 8.1.6 ON W2K PROFESSIONAL EDITION , DURING THE DATABASE CREATION I AM GETTING THIS ERROR

    ORA-03113: end-of-file on communication channel

    SAME THING HAPPENS WHEN I CREATE THE DATABASE USING DATABASE CONFIGURATION ASSISTANT.

    I WILL BE THANKFUL IF SOMEONE HAVE THE SOLUTION

    DB:3.80:Ora-03113: End-Of-File On Communication Channel 8x

    I installed on RedHat 7.1 and had this problem. Thanks to the counsel of others, I solved this problem by setting shmmax to a ridiculously large bit pattern.

    As root,
    echo 400000000 /proc/sys/kernal/shmmax
    then retry the install. Remember this setting will only prevail during this login and will be reset to normal values on next boot.

  • RELEVANCY SCORE 3.80

    DB:3.80:I Figure Out Ora-03113 1x


    Hi,everyone:
    I figure out the ORA-03113 end-of-file
    ..communication channel which arise from
    the creatation of DB,The following is the key

    SQLNET.AUTHENTICATION_SERVICES= (BEQ, NONE)

    modify that string into the upper one in sqlnet.ora.
    I Hope Help You!
    null

    DB:3.80:I Figure Out Ora-03113 1x

    Thanks for the tip. I made the change in the sqlnet.ora from the default (NTS) to (beq, oss) and IT WORKED! I was amazed.

    I kept getting the ora-03113 error message as i was logging on to sqlplus after i had made the connection many times in the past. I'm not sure what changed to cause me to have to make this change, but at least I'm back up and running.

    Thanks for the info.

    Tricia

  • RELEVANCY SCORE 3.80

    DB:3.80:Ora-03113 : End-Of-File On Communication Channel 71


    Hi All

    When I tested table function of Oracle 9.2.0.1, I got a problem.

    ORA-03113 : end-of-file on communication channel

    the query is like below :

    select * from
    table(mes_ds_gerp_ws_pkg.ws_own_mes_order_rate_select('GSZ',null,null,null,null))

    The function - ws_own_mes_order_rate_select returns a table type of pipelined.

    Have you ever seen this bug?

    DB:3.80:Ora-03113 : End-Of-File On Communication Channel 71

    but you can't test with this source because this function calls bpel process
    webservice,and get XML soap message back as a result.
    Understand. But it still gives a very good idea to what the potential issues is to isolate and test.

    FWIW, I have pipelined tables working along these exact lines - wrapping a web service/URL into a SQL table. The most common one it to pull CSV formatted pages from web servers and present that as a SQL table.

    Yours are more complex though as you deal with
    - XML parsing and a XML DOM
    - SOAP processing
    - running SQLs against a PL/SQL instantiated object

    This impacts PGA memory and has a lot more moving parts that can fail.

    I would pull this from the pipeline table and write a test harness for each of these two, in order to test them separately and then together.

    Of course, it could also be a lot simpler to get the ORA-0600 error(s) from the alert log and trace files, and then using [url http://metalink.oracle.com]Metalink to analyse it via the ORA-600/ORA-7445 Troubleshooter (Note:153788.1).

  • RELEVANCY SCORE 3.79

    DB:3.79:Ora-03113 Transparent Gateway 9.01.1 8p


    I use two ways to connect SQL Server2000 from
    Oracle9.0.1.1 :heterogeneous connectivity and transparent
    gateway for sql, all products are 9.0.1.1 and on windows 2000
    sp2. The final respons is "ORA-03113: end-of-file on
    communication channel".
    Please kindly help.

    DB:3.79:Ora-03113 Transparent Gateway 9.01.1 8p

    Please contact Oracle support for this issue.

    Vira

  • RELEVANCY SCORE 3.78

    DB:3.78:Re: Ora-03113: End-Of-File On Communication Channel 8f


    check for network problems

    DB:3.78:Re: Ora-03113: End-Of-File On Communication Channel 8f

    hI,

    AFRTER I AM RUNNING THE QUERY I RECEIVED THE FOLLOWING ERROR....

    SQL SELECT EXTRACTVALUE(VALUE(T),'//aircraftName/text()') aircrafts
    FROM drm_cm_data rm,TABLE(XMLSEQUENCE(EXTRACT(XML_DATA,'//aircraftName'))) T
    WHERE rm.XML_NAME = 'AIRCRAFT_LIST' order by aircrafts;
    2 3 FROM drm_cm_data rm,TABLE(XMLSEQUENCE(EXTRACT(XML_DATA,'//aircraftName'))) T
    *
    ERROR at line 2:
    ORA-00904: "XMLSEQUENCE": invalid identifier

    SQL

    REGARSD.

  • RELEVANCY SCORE 3.78

    DB:3.78:Ora-03113: End-Of-File On Communication Channel ka


    Hi,

    I am having issues calling java code which is loaded into the database, I am getting end-of-file on communication channel exception, could anyone please help?

    Error Codes:

    ORA-03113 ORA-07445 ORA-03114

    Thanks,
    Bharat

    DB:3.78:Ora-03113: End-Of-File On Communication Channel ka

    Yes and as per my understanding the issue might me in the so file, which is unable to handle the exception and causing ORA-03113 when I call the java sp from reports.

  • RELEVANCY SCORE 3.77

    DB:3.77:Trap Ora-03113 Error?? ck


    Hello,

    I have PL/SQL program, which gets "ORA-03113: end-of-file on communication channel" after processing data (in between). How do we trap this offensive sql statement?

    Let me know your thought.

    Ram

    DB:3.77:Trap Ora-03113 Error?? ck

    hi,

    u may see this. hope it will help u.

    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:

    ALTER SYSTEM KILL SESSION ... IMMEDIATE
    ALTER SYSTEM DISCONNECT SESSION ... IMMEDIATE
    SHUTDOWN ABORT/IMMEDIATE/TRANSACTIONAL
    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.

    best regards
    shakeel ahmed

  • RELEVANCY SCORE 3.75

    DB:3.75:Error Ora-03113 When Execute Procedure Via Oem jz


    Hi All,

    I got error messages

    ORA-03113: end-of-file on communication channel
    *
    ERROR at line 1:
    ORA-03114: not connected to ORACLE
    when execute procedure via Oracle Enterprise Manager

    Who do you know what 's the problem and how can I resolves ?

    Thanks,
    Mcka

    DB:3.75:Error Ora-03113 When Execute Procedure Via Oem jz

    Solution Description:
    =====================

    The ORA-3113 error is a general error reported by Oracle client tools,
    which signifies that they cannot communicate with the oracle shadow
    process. As it is such a general error more information must be collected
    to help determine what has happened.

    This short article describes what information to collect for an
    ORA-3113 error when the Oracle server is on a Unix platform.

    General Issues:
    ===============

    1) Is it only one tool that encounters the error or
    do you get an ORA-3113 from any tool doing a similar operation?
    If the problem reproduces in SQL*Plus, use this in all tests
    below.

    2) Check if the problem is just restricted to:

    [ ] One particular UNIX user,
    [ ] Any UNIX user
    or [ ] Any UNIX user EXCEPT as the Oracle user.

    3) Check if the problem is just restricted to:

    [ ] One particular ORACLE logon
    or [ ] Any ORACLE logon that has access to the
    relevant tables.

    4) If you have a client-server configuration does this occur from:

    [ ] Any client
    [ ] Just one particular client
    or [ ] Just one group of clients ?
    If so what do these clients have in common ?
    Eg: Software release .

    5) Do you have a second server or database version where the
    same operation works correctly?

  • RELEVANCY SCORE 3.74

    DB:3.74:Re: Ora-03113: End-Of-File On Communication Channel Process Id: 4984 Session Id fs


    Hi;

    1. What is your DB version and OS?
    2. What your alertlog says?

    Regard
    Helios

    DB:3.74:Re: Ora-03113: End-Of-File On Communication Channel Process Id: 4984 Session Id fs

    Hi Helios,

    metalink note?
    I'm not aware of it. Could u give me a brief about it?

    Thanks,
    Sathiesh

  • RELEVANCY SCORE 3.74

    DB:3.74:Ora-03113: End-Of-File On Communication Channel za


    I am installing Oracle 8i 8.1.7 on Win 2000, The software gets installed sucessfully and while creating database it is giving

    ora-03113: end-of-file on communication channel

    What can be the reason.

    Thanks

    Dilip Patel.

    DB:3.74:Ora-03113: End-Of-File On Communication Channel za

    Is your win 2000 server is primary server or secondary server and are you connecting as administrator?

  • RELEVANCY SCORE 3.73

    DB:3.73:Re: Ora-03113: End-Of-File On Communication Channel &Amp; Ora-00600: Internal Error 8p


    Hi,

    Welcome 2 oracle forums :)

    Please refer MOS tech note:
    *ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KKOCXJ : PJPCTX] When Executing a SQL [ID 566823.1]*

    see Workaround section and make sure parameter optimizerpush_pred_cost_based* is set to false.

    If this doesn't help, please see trace file for the specific session.

    thanks,
    X A H E E R
    http://appsdbaworkshop.blogspot.com

    DB:3.73:Re: Ora-03113: End-Of-File On Communication Channel &Amp; Ora-00600: Internal Error 8p

    This seems to be a bug (8896955)

    Queries may raise ora-600 [kkqtSetOp: 0] or ora-600 [kkqtSetOp.1]
    or the query may fail to be fully optimized with table expansion, star transformation and join factorization all together when the query is eligible for all 3 transformations.

  • RELEVANCY SCORE 3.72

    DB:3.72:Ora-03113 dx


    Hello all,

    I get the Error Message ORA-03113: end-of-file on communication channel
    when i issue SQL show parameter log in SQL*PLUS.

    Has anyone experienced the same error and how did you solve it ?

    Thanks in advance

    Ken

    DB:3.72:Ora-03113 dx

    Hello all,

    I get the Error Message ORA-03113: end-of-file on communication channel
    when i issue SQL show parameter log in SQL*PLUS.

    Has anyone experienced the same error and how did you solve it ?

    Thanks in advance

    Ken

  • RELEVANCY SCORE 3.72

    DB:3.72:Ora -03113 End Of File On Communication Channel z7


    Hi,

    I tried to install Oracle 8.1.6 or 8.1.7 on MS Windows 2000
    Professional after installing service pack 2 . But while
    creating or databse or executing svrmgrl it gives error ora-
    03113 End of file on communication channel.

    Can anybody help me? Your earlier response will be appreciated.

    Thanks

    Mark

    DB:3.72:Ora -03113 End Of File On Communication Channel z7

    Hi,

    I tried to install Oracle 8.1.6 or 8.1.7 on MS Windows 2000
    Professional after installing service pack 2 . But while
    creating or databse or executing svrmgrl it gives error ora-
    03113 End of file on communication channel.

    Can anybody help me? Your earlier response will be appreciated.

    Thanks

    Mark

  • RELEVANCY SCORE 3.72

    DB:3.72:Re: "Ora-03113: End-Of-File On Communication Channel" After "Database Mounted" af


    Hi,
    Thanks for your reply. I tried "export ORACLE_SID", then "sqlplus /as sysdba", "shutdown abort", and could shutdown the instance successfully "ORACLE instance shut down." But when I tried to startup instance again by issuing command "startup", the message show below (same as before).

    ORACLE instance started.

    Total System Global Area 1073741824 bytes
    Fixed Size 1264892 bytes
    Variable Size 427819780 bytes
    Database Buffers 633339904 bytes
    Redo Buffers 11317248 bytes
    Database mounted.
    ORA-03113: end-of-file on communication channel

    Any advice on this?

    Thanks.

    Kenneth

  • RELEVANCY SCORE 3.71

    DB:3.71:Ora-03113 xs


    Hi All,

    From the on-site(two seperate networks) we are getting this error 'ORA-03113 end-of-file on communication channel'.Locally there is no problems for the DB server/clients connections. There is no messages in alert or dump files.

    Any one have any idea about this error?

    Please help me,
    Thomas VA.

    DB:3.71:Ora-03113 xs

    Additonally, report this error to Oracle support.

  • RELEVANCY SCORE 3.71

    DB:3.71:Ora-03113: End-Of-File On Communication Channel zp


    when we run a select query we get this error(there is no problem of connectivity and network)
    ORA-03113: end-of-file on communication channel

    how we solve this problem please give solution for this error.

    thanks

    DB:3.71:Ora-03113: End-Of-File On Communication Channel zp

    the problem will be same as yours.. web server profile would have been configured so..

  • RELEVANCY SCORE 3.70

    DB:3.70:Error Ora-03113 87


    Hi,

    I have got this error while executing procedure.

    It goes on to note that the ORA-03113 End-Of-File error often has additional messages:

    Please tell me what is the solution for this error?

    DB:3.70:Error Ora-03113 87

    ORA-03113end-of-file on communication channel

    CauseAn 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.
    ActionIf 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 customer support.

    Copyright (C) 1998, Oracle Corporation

  • RELEVANCY SCORE 3.70

    DB:3.70:Ora-03113 On Solaris 8 za


    On Solaris 8, I installed Oracle8i, Release 3 (8.1.7).

    When I try to start database from svrmgrl I've got this message:
    "ORA-03113: end-of-file on communication channel"

    What I do wrong?

    Thanks
    Paula
    null

    DB:3.70:Ora-03113 On Solaris 8 za

    I'm sorry, wrong Forum!

    BLOCKQUOTEfont size="1" face="Verdana, Arial"quote:/fontHROriginally posted by Paula Marin (p.marin@voxtime.com):
    On Solaris 8, I installed Oracle8i, Release 3 (8.1.7).

    When I try to start database from svrmgrl I've got this message:
    "ORA-03113: end-of-file on communication channel"

    What I do wrong?

    Thanks
    PaulaHR/BLOCKQUOTE

    null

  • RELEVANCY SCORE 3.69

    DB:3.69:Re: Ora-03113: End-Of-File In Startup a7


    Thanks all.
    Of cours Windwos service is created using oradim.
    It even does not touch alertlog. I mean it does not write on it. Server had 1 G RAM. I increased it to 1.5 Gb and will restart.

  • RELEVANCY SCORE 3.69

    DB:3.69:Ora-03113: End-Of-File On Communication Channel m1


    Hi all,

    I m in big problom,please help me.
    when i m executing big select statement it gives the following error.
    "ORA-03113: end-of-file on communication channel"

    please help me ,immidiate responce
    subba

    DB:3.69:Ora-03113: End-Of-File On Communication Channel m1

    Is your network killing idle sessions - limited ports?

  • RELEVANCY SCORE 3.69

    DB:3.69:Scheduler Error Oracle Error Code: 3113, Message: Ora-03113: End-Of-File On Communication Channel After The Applying The Patch 11.1.1.7.140225 jm


    Hi Experts,We are facing the issue with Scheduler is not starting up after applying the patch 11.1.17.140225.In scheduler log showing error ORA-03113: end-of-file on communication channel.please help me on this.Thanks,Charan.

  • RELEVANCY SCORE 3.69

    DB:3.69:Re: Ora-00214 df


    Dear Sir

    Thanks to reply and i had followed your instruction and start the data base and my data base came to Mount state but when try to open it then get this error.

    ORA-03113 end-of-file on communication channel

    Please help me. I will be thanks full

    Regards,

    DB:3.69:Re: Ora-00214 df

    I do not know which of the methods from the other thread did you adopt.

    a. You could do a CREATE CONTROLFILE but that isn't strictly necessary.
    b. allowresetlogs_corruption is certainly not to be done at all.

    Hemant K Chitale

  • RELEVANCY SCORE 3.69

    DB:3.69:Oracle 9i R2 Installation On Linux -Ora-03113 Error 1k


    I am in the process of installing Oracle 9i R2 trail version on Linux Server 2.2.4. The software did get installed but the DBCA did not create the sample database.
    The error I get is:

    ORA-03113:end-of-file on communication channel.

    I have also after the installation re-run the DBCA but get the same error. Any help will be appreciated.
    Thank you

    DB:3.69:Oracle 9i R2 Installation On Linux -Ora-03113 Error 1k

    Please post this question in the Database - Installation forum. The URL is:
    Database Installation

  • RELEVANCY SCORE 3.69

    DB:3.69:Re: Sql≫Startup Error:Ora-03113: End-Of-File On Communication Channel k8


    C:\Set ORACLE_SID=XE

    C:\sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 28 15:17:42 2012

    Copyright (c) 1982, 2010, Oracle. All rights reserved.

    Connected to an idle instance.

    SQL startup mount pfile='D:\pfile.ora';
    ORA-03113: end-of-file on communication channel
    SQL

    DB:3.69:Re: Sql≫Startup Error:Ora-03113: End-Of-File On Communication Channel k8

    SQL show parameter spfile

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    spfile string C:\ORACLEXE\APP\ORACLE\PRODUCT
    \11.2.0\SERVER\DBS\SPFILEXE.OR
    ANAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    aq_tm_processes integer 0
    cell_offload_processing boolean TRUE
    db_writer_processes integer 1
    gcs_server_processes integer 0
    global_txn_processes integer 1
    job_queue_processes integer 4
    log_archive_max_processes integer 4
    processes integer 80

  • RELEVANCY SCORE 3.69

    DB:3.69:Ora-03113 With Creation Of A Spatial Index cf


    Hello,

    the creation of a spatial index with 11G database interrupts with:
    ORA-03113 end-of-file on communication channel.
    The table contains only point data, but has over 3.000.000 data records.

    Has anyone an idea what to do?
    ??
    Anna

    DB:3.69:Ora-03113 With Creation Of A Spatial Index cf

    Hello Ivan,

    the tablespace was too small. After adding a datafile the index creation worked. The given error message of the database was very misleading.

    Regards.
    Anna

  • RELEVANCY SCORE 3.69

    DB:3.69:Ora-03113: End-Of-File On Communication Channel ff


    The ORA-03113 error is occuring randomly most frequently on a local machine when first started. This is triggered with an OracleDataAdapter.Fill command. Any ideas what could cause it?

    DB:3.69:Ora-03113: End-Of-File On Communication Channel ff

    Please provide a test case to reproduce this issue.

  • RELEVANCY SCORE 3.69

    DB:3.69:Ora-03113: End-Of-File On Communication Channel fx


    Hi

    I'm building a Portal Report in Oracle9iAS 9.0.2 with the following line in the where clause

    portal.wwsto_api_session.load_session
    ('iPortal','SENIAT').get_attribute_as_number
    ('a_id_tramite_hist')

    if I leave the line and press ok to compile the report is throws

    ORA-03113: end-of-file on communication channel

    if I take it out it works fine

    DB:3.69:Ora-03113: End-Of-File On Communication Channel fx

    Hi

    Thanks but I already tried putting the logic in a function and still it doesn't work.

  • RELEVANCY SCORE 3.69

    DB:3.69:Creating Intermedia Index Gives Ora-03113 - End-Of-File On Communication Channel c7



    Please always mention version when posting.

    You need to issue "drop index idx_name force". Then re-create your index.

    o.

    null

    DB:3.69:Creating Intermedia Index Gives Ora-03113 - End-Of-File On Communication Channel c7

    SQL select count(*) from company where contains(ctx_content_zhs,'Az')0;

    select count(*) from company where contains(ctx_content_zhs,'Az')0
    *
    ERROR at line 1:
    ORA-03113: end-of-file on communication channel

    content search is bad!
    null

  • RELEVANCY SCORE 3.69

    DB:3.69:Getting Ora-03113 While Creating Database j7


    dear all

    i've successfully installed oracle 11g r2 on oel

    now while using dbca I'm getting ORA-03113 "end-of-file" on communication channel" error and I checked alert.log file, its written that:

    *ORA-00600: internal error code, arguments: [16305], [], [], [], [], [], [], [], [], [], [], []*

    Why I'm getting this error sudenly?

    thanks

    john

    DB:3.69:Getting Ora-03113 While Creating Database j7

    always use this to troubleshoot ora-600:

    MOS:
    Troubleshoot an ORA-600 or ORA-7445 Error Using the Error Lookup Tool [ID 153788.1]

  • RELEVANCY SCORE 3.69

    DB:3.69:Ora-03113 When Executing Flashback Query md


    Using DB 11g 11.1.0.6 Have enabled flashback on specific tables. Tested fine. Now testing database maintenance but getting dodgy results. Steps taken were:
    - disabled flashback on one table
    - dropped table and re-created it
    - enabled flashback on it
    -- could perform normal queries against table
    -- got ORA-03113 (end-of-channel, session disconnected) when doing a flashback query (select * from x as of ...)

    Stopped and re-started database and all was well. Seemingly. Then I tried more:
    - disabled flashback on one table,
    - renamed one column
    - enabled flashback on it
    -- same results. Normal queries are ok. Flashback queries get disconnected (ORA-03113: end-of-file on communication channel).

    BUT stop and re-start of database does NOT clear up the problem this time.
    Any ideas??

    DB:3.69:Ora-03113 When Executing Flashback Query md

    ANSWER: ignore the problem, and it goes away. I could demonstrate this error from different sessions, from different users, all queries against that same TableX.

    Six hours later, with no changes in the network, permissions, database, or anything else (except for some standard database DDL activity) all is well and a "select * from TableX as of ..." works just fine.

    ah well. thanks anyways folks.

  • RELEVANCY SCORE 3.69

    DB:3.69:Ora-03113: End-Of-File On Communication Channel z1


    HI ALL,
    I AM INSTALLING ORACLE 8.1.6 ON W2K PROFESSIONAL EDITION , DURING THE DATABASE CREATION I AM GETTING THIS ERROR

    ORA-03113: end-of-file on communication channel

    SAME THING HAPPENS WHEN I CREATE THE DATABASE USING DATABASE CONFIGURATION ASSISTANT.

    I WILL BE THANKFUL IF SOMEONE HAVE THE SOLUTION

    DB:3.69:Ora-03113: End-Of-File On Communication Channel z1

    check your alert.log file and trace files for the cause of the problem.

  • RELEVANCY SCORE 3.69

    DB:3.69:How Will I Resolve This Issue 1a


    ORA-03113: end-of-file on communication channel

    DB:3.69:How Will I Resolve This Issue 1a

    I think perhaps this is a result of buffer overflow. I'm not sure.

    No, it isn't. That would give you either

    ORU-10027: buffer overflow, limit of n bytes

    or

    ORU-10028: line length overflow, limit of 255 chars per line

    (in Oracle versions prior to 10.2)

  • RELEVANCY SCORE 3.69

    DB:3.69:Ora-03113 - End-Of-File On Communication Channel s1


    hi,

    When i execute an DML statement then deletes 2 milion of rows, the oracle returns an error (ORA-03113 - end-of-file on communication channel).

    The alert.log doesnt log this error. An google results not resolve my problem. What i resolve this ?

    Thanks,
    Carlos

    DB:3.69:Ora-03113 - End-Of-File On Communication Channel s1

    Hi,

    Try executing this command from Server maybe it is a network problem.

    Regards,
    Paulo.

  • RELEVANCY SCORE 3.69

    DB:3.69:Re: Ora-03113: End-Of-File On Communication Channel f3


    do you have enough space on USER_DUMP_DEST and BACKGROUND_DUMP_DEST? check them.
    because the command of 'DELETE' does not really delete your data until you submit.

    DB:3.69:Re: Ora-03113: End-Of-File On Communication Channel f3

    hi,
    Just add one dispatcher and confgure your connection
    Thanks,
    Neerav

  • RELEVANCY SCORE 3.69

    DB:3.69:Ora-00600 Ora-03113 Error ? 8z


    In EM a have this Alert:

    ~Errors in file d:\...\ora_111111.trc: ~ORA-00600: internal error code, arguments: [psi.c: psitrp3: leak], [], [], [], [], [], [], [] ~ORA-03113: end-of-file on communication channel~

    What is the problem???

    DB:3.69:Ora-00600 Ora-03113 Error ? 8z

    Hi !

    Try this man

    ORA-600
    ORA-600 errors are raised from the kernel code of the Oracle Database software when an
    internal inconsistency is detected or an unexpected condition is met. This situation is not
    necessarily a bug, it might be caused by problems with the operating system, lack of resources,
    hardware failures, or other conditions.
    With the ORA-600 error comes a list of arguments in square brackets. The first of these
    arguments tells us from where in the code the error was caught and thus is the key information in
    identifying the problem. This argument is either a number or a character string. The remaining
    arguments are used to supply further information such as values of internal variables.
    When an ORA-600 error is raised a trace file is generated in either USER_DUMP_DEST or
    BACKGROUND_DUMP_DEST depending on whether the error was caught in a user or a
    background process. The error is also written in the alert log with the name of the trace file. The
    trace file contains vital information about what led to the error condition.

    Hope this might help.

    Thanks.