Imp-00058 Oracle Error 3113 Encountered
Contents |
#121231] Fri, 27 May 2005 01:49 8683 Messages: 2Registered: May 2005 Location: india Junior Member while importing dump file. i am getting this error. IMP-00058: ORACLE error 3113 encountered ORA-03113: end-of-file on communication channel IMP-00000: Import terminated unsuccessfully thanks in advance "psdrpc returns significant error" [Updated on: Fri, 27 May 2005 02:10]Report message to a moderator Re:
Oracle Error 3114
ORACLE error 3113 encountered [message #121245 is a reply to message #121231] Fri, 27 May 2005 02:52 skooman Messages: 912Registered: March 2005 rman psdrpc returns significant error 3113 Location: Netherlands Senior Member From the reference: "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
Ora-3113 End-of-file On Communication Channel
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." You didn't state the Oracle version you work with, but it appears on Metalink that there were some problems with 8.1.6. More info on Metalink. Report message to a moderator Re: ORACLE error 3113 encountered [message #121474 is a reply to message #121245] Mon, 30 May 2005 02:15 8683 Messages: 2Registered: May 2005 Location: india Junior Member hi we are using oracle 9.2 i am attaching log file Attachment: TLM.log (Size: 212.45KB, Downloaded 865 times) Report message to a moderator Re: ORACLE error 3113 encountered [message #121488 is a reply to message #121474] Mon, 30 May 2005 04:14 girish.rohini Messages: 744Registered: April 2005 Location: Delhi (India) Senior Member From Reference: 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 fai
2007 - 8:21 pm UTC Category: Database � Version: 8.1.6 Latest Followup You Asked Tom, I export a table that has the following constraints: Primary key Unique key Check Why does an import back into the same schema with ignore=y show errors for unique and check constraints but does not show them for primary key constraints that exist also? IMP-00017: following statement failed with ORACLE error 2261: "ALTER TABLE "TABLE1" ADD CONSTRAINT "TABLE1_UK" UNIQUE ("COLUMN2") USING I" "NDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 24576 NEXT 409600 M" "INEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUP" "S 1 BUFFER_POOL DEFAULT) http://www.orafaq.com/forum/t/46556/2 TABLESPACE "USERS" ENABLE " IMP-00003: ORACLE error 2261 encountered ORA-02261: such unique or primary key already exists in the table IMP-00017: following statement failed with ORACLE error 2264: "ALTER TABLE "TABLE1" ADD CONSTRAINT "TABLE1_CK" CHECK (column2 > '') ENABL" "E NOVALIDATE" IMP-00003: ORACLE error 2264 encountered ORA-02264: name already used by an existing constraint About to enable constraints... Import terminated successfully with warnings. Just Curious . Thanks https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:1492331695311 Peter and we said... ignore=y changes the behavior of CREATE statements. If the CREATE statement failed - no data would be imported. Ignore=y says "go ahead, import the data anyway". The failure of the ALTERS affects nothing -- the data is already imported by then, so we just "fail" them (but continue on) Reviews Write a Review ignore=y May 23, 2002 - 11:31 am UTC Reviewer: X Wang from NJ USA I use ignore=y option when I import the data. It only ignore CREATE TABLE command, but failed in CREATE TYPE command. IMP-00015: following statement failed because the object already exists: "CREATE TYPE "MYTYPE_T" TIMESTAMP '2002-02-10:16:24:15' OID 'F4CDB776D6771" "1D3AD090008C7E98428' " How can I ignore create type command? Thank you Followup May 23, 2002 - 3:31 pm UTC it didn't fail, it just keeps on going. ops$tkyte@ORA817DEV.US.ORACLE.COM> drop user a cascade; User dropped. ops$tkyte@ORA817DEV.US.ORACLE.COM> ops$tkyte@ORA817DEV.US.ORACLE.COM> grant dba to a identified by a; Grant succeeded. ops$tkyte@ORA817DEV.US.ORACLE.COM> ops$tkyte@ORA817DEV.US.ORACLE.COM> @connect a/a ops$tkyte@ORA817DEV.US.ORACLE.COM> set termout off a@ORA817DEV.US.ORACLE.COM> REM GET afiedt.buf NOLIST a@ORA817DEV.US.ORACLE.COM> set termout on a@ORA817DEV.US.ORACLE.COM> a@ORA817DEV.US.ORACLE.COM> a@ORA817DEV.US.ORACLE.COM> create table t ( x int ); Table created. a@ORA817DEV.US.ORACLE.COM> create or replace type my_type as object ( x int ); 2 / Type created. a@ORA817DEV.US.ORACLE.COM> create
ORACLE error 600 encounteredORA-00600: internal error code, arguments: [4454], [], [], [], [], [], http://grokbase.com/t/freelists.org/oracle-l/01czftsa0f/import-failed [],[]IMP-00017: following statement failed with ORACLE error 3113:"ALTER TABLE "PROD_SEARCH_TRACK" ADD PRIMARY KEY ("ID") USING INDEX PC""TFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 227672064 NEXT 8388608MIN""EXTENTS 1 http://www.progtown.com/topic1021844-by-importation-produces-error-import-terminated-unsuccessfully.html MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS1"" BUFFER_POOL DEFAULT) TABLESPACE "INDEX1" ENABLE"IMP-00003: ORACLE error 3113 encounteredORA-03113: end-of-file on communication channelIMP-00000: Import terminated unsuccessfullyWhat could be oracle error problem and how I correct it?Thanks-SeemaMSN Photos is the easiest way to share and print your photos:http://photos.msn.com/support/worldwide.aspx--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Seema SinghINET: oracledbam_at_hotmail.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an psdrpc returns significant E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). reply Tweet Search Discussions Search All Groups oracle-l 1 response Oldest Nested Karniotis, Stephen Log on to Metalink and enter the ORA-600 line, including the arguments in brackets, in the search. It will provide a resolution for you. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: Stephen.Karniotis_at_Compuware.com Web: www.compuware.com -----Original Message----- Sent: Monday, December 31, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Subject: IMPORT FAILED Hi Gurus I was try to import one table Karniotis, Stephen at Dec 31, 2001 at 4:02 pm ⇧ Log on to Metalink and enter the ORA-600 line, including the arguments inbrackets, in the search. It will provide a
»Databases »By importation produces error Import terminated unsuccessfully Pages 1 You must login or register to post a reply Topic RSS feed Posts [ 7 ] 1 Topic by Gvardman 2013-02-26 17:57:28 Gvardman New member Offline Registered: 2013-02-26 Posts: 9 Topic: By importation produces error Import terminated unsuccessfully Help, please!The version 11g enterprise editionFor import entered such command:imp admin/admin@mdo file ='D:\exp20120612.DMP ' fromuser=admin touser=admin ignore=y log=c:\1.txtAnd here a broad gull:Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport file created by EXPORT:V11.02.00 via conventional pathimport done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character setimport server uses CL8MSWIN1251 character set (possible charset conversion)export client uses CL8MSWIN1251 character set (possible charset conversion). . importing table "AATESTTBL" 0 rows imported. . importing table "ACCFORUM" 127116 rows imported. . importing table "ACC_COMP" 0 rows imported. . importing table "ACC_COMP_C" 0 rows imported. . importing table "ACC_COMP_D" 0 rows imported. . importing table "ACC_ENT" 3947 rows imported. . importing table "ACC_ENT_C" 30716535 rows importedIMP-00017: following statement failed with ORACLE error 1658:"CREATE INDEX" ACC_ENT_C_DOC_IDX "ON" ACC_ENT_C "("DATE_MODIFY","DOC_HELP _""FILE") PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 729808896 NEXT""1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TAB""LESPACE" USERS_IND "LOGGING"IMP-00003: ORACLE error 1658 encounteredORA-01658: unable to create INITIAL extent for segment in tablespace USERS_INDIMP-00017: following statement failed with ORACLE error 20000:"BEGIN DBMS_STATS.SET_INDEX_STATS (NULL, '" ACC_ENT_C_DOC_IDX "', NULL, N ULL, NULL"", 30558208,87614,19710122,1,1,6164535,2,6); END;"IMP-00003: ORACLE error 20000 encounteredORA-20000: INDEX "ADMIN". "ACC_ENT_C_DOC_IDX" does not exist or insufficient privilegesORA-06512: at "SYS.DBMS_STATS", line 3007ORA-06512: at "SYS.DBMS_STATS", line 7865ORA-