dbms_metadata.get_ddl ORA-03113

Can anybody tell me why I'm getting this error?

SQL> select dbms_metadata.get_ddl('TABLE','ACCOUNT','XUSER') from dual

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

Oracle dbms_xmlschema.registerSchema with ORA-03113: end-of-file ...

I want to register XML schema for XML signature (http://www.w3.org/TR/2002/REC-xmldsig-core-20020212/xmldsig-core-schema.xsd) using dbms_xmlschema.registerSchema:declareenxml XMLType;beginselect xml into enxml from ODP_STATIC_XML where naziv='xmldsig-core-schema.xsd';dbms_xmlschema.registerSchema('h ...

Oracle DBMS_XSLPROCESSOR.processXSL and ORA-03113

I got "ORA-03113: end-of-file on communication channel" error when use DBMS_XSLPROCESSOR.processXSL to transform an xml data. The dump file contains: PL/SQL Call Stack object line objecthandle number name33C61A04 493 package body XDB.DBMS_XSLPROCESSOR33C61A04 520 package body XDB.DBMS_XSLPROCESSOR20 ...

Oracle ORA-03113 when using dbms_xslprocessor.valueof()

I have just recently started using the 9.2.0.2 functionality, and am having great difficulty in getting dbms_xslprocessor.valueof() to work correctly.I am aware of two known issues with this procedure. 1) the necessitaty of including '\text()' on the end of the XPATH e.g.dbms_xslprocessor.valueof(v_ ...

ora-03113 on dbms_java.grant_permission in oracle 10.1.0.4

I recently installed Oracle 10.1.0.4 enterprise edition.when I try to grant a user java permissions I get the error:ERROR at line 1:ORA-03113: end-of-file on communication channelthis happens when I try to create a java source object too.I've searched metalink but didn't find anything relevant.any i ...

Oracle CTX_DDL.SYNC_INDEX gives ORA-03113

I am trying to use the CTX_DDL.SYNC_INDEX command in order to update the full Text Index on a table, which contains a word document as a binary object, but I get an ORA-03113 error every time I do this. I get the same error if the table contains an Excel file. It works perfectly OIK if the table con ...

Oracle CTX_DDL.SYNC_INDEX gives ORA-03113 error

I am trying to use the CTX_DDL.SYNC_INDEX command in order to update the full Text Index on a table, which contains a word document as a binary object, but I get an ORA-03113 error every time I do this. I get the same error if the table contains an Excel file. It works perfectly OK if the table cont ...

Oracle DBMS_JAVA.GRANT_PERMISSION RESULTS IN ORA-03113

I've successfully created and deployed a java procedure that compresses files for use as email attachements. Upon executing the procedure I get a trace file telling me to grant java.io.FilePermission to the user. I attempted the call (connected as sys (sysdba)):exec dbms_java.grant_permission('VEHIC ...

Oracle dbms_xmlDom.AdoptNode fails in 10gR2 with ORA-03113 error

am trying to port the xml db code from 9i to 10g.on executing the procedure i get the following error and am thrown out of the session-ORA-03113: end-of-file on communication channelon debugging i found that the Following line is throwng the error.dbms_xmlDom.AdoptNode(gDoc, dom1);Please let me know ...

Oracle db links and ora-03113

I currently run two 7.3.4 databases linked with a public database link. Every now and then my cobol process on my first db aborts due to ora-03113 while access my second db via the link. I restart the cobol process, and it works fine. It does not appear to correlate to and db or network events. Both ...

Oracle 9i - Full Outer Join - error ORA-03113

My DB server is Oracle 9.2.0.1.0. I try the following FULL OUTER JOIN query:select *from (SELECT p.user_id p_user_idFROM phrepreport$ pWHERE p.starting IN ( SELECT max(p.starting)FROM phrepreport$ pGROUP BY p.user_id )) t1 FULL OUTER JOIN --RIGHT OUTER JOIN (SELECT s.user_id s_user_idFROM synchro_co ...

Oracle 9i R2 Installation on Linux -ORA-03113 error

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 err ...

Oracle linux: ORA-03113 when create database

I'm trying to install Oracle Enterprise R8.1.7 on Linux. I've found Miracle Linux (it's "made" for running Oracle on Linux), it's a Japanese distribution. http://www.miraclelinux.com/Everything works perfect until I get to the point where I have to create a database. I use dbassist, its stops at 2% ...

Oracle ORA-24324 & ORA-03113

i hv installed 9i forms in my pc. when i wnats to create new blocks after connecting to the database and at the time of selecting the filed name from the selected table i'm getting below error"ORA-24324 : Service not initilized"same time whe i work on SQL sometimes the connection to DB getting disco ...

Oracle ORA-03113: end-of-file on communication error in fulltext search

i'm using ctxcat for full text in oracle 9i, my frontend application is webbased(in Microsoft.net) the problem is that when user input data like (wsdsdfdf|!@#$#$%^$%^&$&*)or ('SaturdayMatter|Y''''ahoo|kasldfjlas'''jfl''''aj'''''''''''''''''''''''"""""''''''''''''''''''')it give error ORA-031 ...

ORA-03113 Oracle10G

Hineed help When I exec this whith sql*plus in Oracle10g i have this errorSQL> CREATE TABLE PHOTOS2 (3 ID NUMBER PRIMARY KEY4 ,PHOTO BLOB5 ,PROP CLOB6 )7 /Table created.SQL> Create or Replace Procedure INSERT_IMAGE(P_ID NUMBER, P_FILE VARCHAR2) IS2 V_BLOB BLOB;3 V_CLOB CLOB;4 V_CTX RAW(4000) : ...

Oracle Installing OWB, getting ORA-03113

Greetings,I'm getting a ORA-03113 error during the installation of OWB 10g runtime repository using runtime assistant. Can please someone help me understand why?Here is the final piece of my log.txt file, where the error ocurs. Thks._oracle.wh.util.DebugUtility: the tbspace for snapshot is USERSMon ...

Oracle Getting ORA-03113 error during DML transations on procedure

I have a form with DML data target type as Procedure. I have defined a procedure for insert which takes Table of records as argument. I am getting FRM-40735: INSERT-PROCEDURE trigger raised unhandled exception ORA-03113.(Procedure is in the database). Please help me out in resolving this. ...

Oracle ORA-03113 Error

We are currently running Oracle 8i on HP-UX and each time I run a specific query I get the following error on the console:Warning: Entry/Exit code is optimized. Cannot restore context (UNWIND 22)From SQL*Plus when I run the query I get ORA-03113 error. Has anyone else ran into this problem and found ...

Oracle ORA-03113 on 8.1.7 initial database creation

We have installed Oracle Enterprise Edition 8.1.7 on Solaris 7. During the initial database creation, we get the "ORA-03113: end-of-file on communication channel" error.Our svrmgrl session looks like this$ svrmgrlOracle Server Manager Release 3.1.7.0.0 - ProductionCopyright (c) 1997, 1999 Oracle Cor ...

Oracle Error ORA-03113 while creating index

I consistently get an ORA-03113 error when attempting to create an interMedia index. I was able to build this index successfully by adding several thousand rows at a time and synchronizing the index. After I dropped the index, I have not been able to recreate it.To eliminate the possibility of a fla ...

Oracle ORA-03113 and ORA-03114

When I access our Oracle database with SQL*Plus, from a client machine, after 10 or 15 minutes without requests to the server database, I get these error messages. But when I am running the proccesses from the machine server, it's not happens.Could anyboby help me?Thanks in advance.Rafael.null ...

Oracle ORA-03113 !

Below is sqlnet.log at client side:***********************************************************************Fatal NI connect error 12560, connecting to:(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=OR ...

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

Now I face the error : ORA-03113 end-of-file on communication channel in SQL*PLUS session, and becuase sql*plus works normally, I am sure that the physical connection is well.Error occurs when I run a select statement with a sub select?I did not know how to do next and was confused with it for a whi ...

Oracle Creating Intermedia Index gives ORA-03113 - end-of-file on communication channel

We have tried to create an intermedia index using the syntax:create index <index_name> on <table_name>(<blob_field_name>) indextype is ctxsys.context;After about thirty seconds we get the following error:ORA-03113: end-of-file on communication channelWe have tried to create this in ...

Oracle Error running initjvm.sql ORA-03113: end-of-file on communication channel

I recently was running initjvm.sql when mynetwork took a power hit. My Oracle machine was thus powered down in the middle ofrunning initjvm.sql.Now, when I run the script I get an ORA-03113: end-of-file on communication channel error every time. It alway happensduring the command "create or replace ...

Oracle getting ORA-03113 error message

I have created view of 56 columns.when I do select from the view, I got following error message.select count(*) from local_daily_dom_intl_view_0_b*ERROR at line 1:ORA-03113: end-of-file on communication channelI am not sure why I am getting this error.null ...

Help -> ORA-03113

I am really stuck ;I am running Oracle 9i on Win NT. I have a quiet large database, and was doing alot of deleting when I ran out of undo space.Anyway; i shut down the database and then tried to start it up; every time i do i get the "ORA-03113 end-of-communication channel".Don't really kn ...

fail to create db:"ORA-03113: end-of-file on communication channel"

help! platform: aix 4.3.3 ML:9 (cluster) + oracle 8.1.7.0 (OPS)i have completed the installation of oracle software ,but when i create the db with the DBCA or manual scripts,the error message below is show"..........SVRMGR> SVRMGR> Connected.SVRMGR> ORACLE instance started.Total System ...

intermittent ORA-03113's on same query

Recently I started having problems with my Oracle database. Here is an example:SQL> select sum(CONSTRUCTION_BUDGET) 2 from VW_ESTIMATE_INFO, VW_PROJ_AWD_INFO 3 where VW_ESTIMATE_INFO.PROJ_ID = VW_PROJ_AWD_INFO.PROJ_ID 4 and VW_PROJ_AWD_INFO.BUD_FISC_YR = '2002';select sum(CONSTRUCTION_BUDGET)*ERR ...