Imp-00058 Oracle Error 12571 Encountered
Contents |
while importing ? If this is your first visit, be sure to check out the FAQ by imp-00058 oracle error 12154 encountered clicking the link above. You may have to register before you imp-00058 import terminated unsuccessfully can post: click the register link above to proceed. To start viewing messages, select the forum oracle error 12154 encountered import that you want to visit from the selection below. Results 1 to 5 of 5 Thread: error while importing ? Tweet Thread Tools Show Printable Version
Imp 00000 Import Terminated Unsuccessfully
Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 12-16-2008,01:40 AM #1 gopu_g View Profile View Forum Posts Senior Member Join Date Aug 2007 Location Cyberjaya,kuala lumpur Posts 340 error while importing ? i am importing remotely to the database. The size of imp-00058 oracle error 12560 encountered the dump is 9GB.After a long time.. the import is terminated with the below error.....please suggest. IMP-00058: ORACLE error 12571 encountered ORA-12571: TNSacket writer failure IMP-00058: ORACLE error 3114 encountered ORA-03114: not connected to ORACLE IMP-00000: Import terminated unsuccessfully Thanks/Gopu Reply With Quote 12-16-2008,04:01 AM #2 PAVB View Profile View Forum Posts Senior Advisor Join Date Mar 2007 Location Ft. Lauderdale, FL Posts 3,555 What are errors ORA-12571 and ORA-03114 suggesting to you? Pablo (Paul) Berzukov Author of Understanding Database Administration available at amazon and other bookstores. Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice. Reply With Quote 12-16-2008,04:36 AM #3 gopu_g View Profile View Forum Posts Senior Member Join Date Aug 2007 Location C
by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Page 1 of 2 12 Last Jump to imp-00058 oracle error 12154 encountered 11g page: Results 1 to 15 of 16 Thread: Import Tweet Thread Tools Show Printable Version Subscribe to
Imp 00058 Oracle Error 1034 Encountered
this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-17-04,08:35 #1 dr_suresh20 View Profile View Forum
Imp 00058 Ora 12154
Posts Registered User Join Date Sep 2003 Posts 218 Unanswered: Import I am using Oracle 9.x.x on Win2k. I have a full export oracle db dump (80 GB), & I try to bring in the full import into a existing db. There http://www.dbasupport.com/forums/showthread.php?59119-error-while-importing is only one schema owner and it is for this user, I am trying to import data. I'm getting a lot of ORA-2291 parent key not found errors. I tried using rows=y constraints=n indexes=n in a parameter file but i still get ORA-2291 errors on the screen. Besides, it nearly takes two days to complete a 80 GB db dump import. What's the best way of successfully doing this? Many thanks. Reply With Quote 03-17-04,08:59 #2 SkyWriter View Profile View Forum Posts Registered User http://www.dbforums.com/showthread.php?988930-Import Join Date Jan 2004 Posts 370 You must have constraints on the existing tables. Reply With Quote 03-17-04,09:13 #3 osy45 View Profile View Forum Posts Registered User Join Date Nov 2002 Posts 833 imp is doning loading tables in alphabetical order, but to me it sounds you are going to imp into a schema which is not empty ... assign a redo/undo segment as large as you can at least use a buffer of at least 16000000 and separate loading data from index use commit=n Reply With Quote 03-17-04,09:46 #4 dr_suresh20 View Profile View Forum Posts Registered User Join Date Sep 2003 Posts 218 Thanks... to you both for quick response. Firstly, If constraints are enabled then "constraints=n" is supposed to take care of it right? Secondly, if import is happening alphabetically - then do I have any control on the list of tables to be imported? Reply With Quote 03-17-04,09:53 #5 osy45 View Profile View Forum Posts Registered User Join Date Nov 2002 Posts 833 Originally posted by dr_suresh20 Thanks... to you both for quick response. Firstly, If constraints are enabled then "constraints=n" is supposed to take care of it right? Secondly, if import is happening alphabetically - then do I have any control on the list of tables to be imported? no normally - and that is my experience - the constraints are loaded at the end of the import process and file then all constaints are being enabled ... you can only control the list of tables i
Topic Backup and recovery Database Admin View All Cloud infrastructure Availability Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security http://searchoracle.techtarget.com/tutorial/Solving-common-Oracle-errors-guide Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Applications View All Enterprise and business performance management Implementing and upgrading Oracle apps http://stackoverflow.com/questions/7151175/ora-12571-tnspacket-writer-failure-with-asp-net E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All BI (business intelligence) Data quality Data warehousing oracle error Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java 00058 oracle error / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fusion Infrastructure Oracle management Sun-Oracle infrastructure Section Get Started News Get Started Evaluate Manage Problem Solve Sponsored Communities Solving common Oracle error codes guide
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-12571: TNS:packet writer failure with ASP.NET up vote 6 down vote favorite My development team is experiencing numerous ORA-12571: TNS:packet writer failure errors using ASP.NET 3.5 and 4.0 against Oracle 11g. These errors are inconsistent as to when they occur, and are generated by numerous applications. This exception happens while calling random stored procedures, packets, and inline SQL statements. The Oracle 11 client is installed on the web server. Some applications use Microsoft System.Data.OracleClient to connect to Oracle, and some use the .NET components provided by oracle (ODP.NET). Both data access objects come up with the same error. There are other non .NET applications that run on a different web server, but use the same database server. The apps do not have any such issues. My initial thinking is that there is something configured incorrectly on the web server with the Oracle client. Has anyone else received this error? What did you do to fix it? ORA-12571: TNS:packet writer failure Stack Trace: at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals) at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals) at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Oracl