Imp-00058 Oracle Error 12560
Contents |
Search Username Password Remember Me? Register Lost Password? facebook google twitter rss Free Web Developer Tools Advanced Search Forum Databases imp-00058 imp-00000 import terminated unsuccessfully Oracle Development IMP: ORA-12560 TNS:protocol adapter error Thread: IMP: ORA-12560 TNS:protocol impdp from 10g to 11g adapter error Share This Thread Tweet This + 1 this Post To Linkedin Subscribe to oracle 10g export 11g import this Thread Subscribe to This Thread August 2nd, 2004,09:00 AM #1 No Profile Picture Zveroa View Profile View Forum Posts Registered User Devshed Newbie
Imp-00058: Oracle Error 12154 Encountered
(0 - 499 posts) Join Date Jan 2004 Posts 6 Rep Power 0 IMP: ORA-12560 TNS:protocol adapter error Hi, I have installed a Oracle 8.1.7 database and trying to import an existing dump, but I'm getting the error message "ORA-12560 TNSrotocol adapter error" when running the IMP command (see below). The instance already import 10g dump to 11g exist, but I want to overwrite existing data. I can connect to the database from the database server itself and another client machine. Can I overwrite thethis, or do I have to create an empty database instance? I getting this "ORA-12560" when I'm trying to run other Oracle tools as well. Any clues what I'm missing? IMP-command -------------- C:\oracle\ora81\bin>set ORACLE_SID=prosty C:\oracle\ora81\bin>imp userid=system/manager full=y ignore=y file=T18820040729.dmp log=T18820040729 .log Import: Release 8.1.7.0.0 - Production on Mon Aug 2 15:49:58 2004 (c) Copyright 2000 Oracle Corporation. All rights reserved. IMP-00058: ORACLE error 12560 encountered ORA-12560: TNSrotocol adapter error IMP-00000: Import terminated unsuccessfully Faq Reply With Quote August 2nd, 2004,12:53 PM #2 No Profile Picture jim mcnamara View Profile View Forum Posts ......@......... Devshed Beginner (1000 - 1499 posts) Join Date Jun 2004 Posts 1,345 Rep Power 58 If the Oracle instance is on another physical box then you need to define TWO_TASK something like thi
Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus � Version: 9.2.0 Latest Followup You Asked i'm running oracle on standalone computer at home.it used ora-12560 tns protocol adapter error 11g to work properly but from couple of days i'm getting error stating
How To Import Dump File In Oracle 11g
"ORA-12560: TNS:protocol adapter error " what should i do? please help.. (scott/tiger) and we said... sounds like
Ora-12154
the database is not up. you probably restarted your machine and the instance is not set to autostart C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on http://forums.devshed.com/oracle-development-96/imp-ora-12560-tns-protocol-adapter-error-170785.html Thu Sep 6 15:43:55 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options C:\Documents and Settings\tkyte>net stop oracleserviceora10gr1 https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 The OracleServiceORA10GR1 service is stopping......... The OracleServiceORA10GR1 service was stopped successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:44:35 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus C:\Documents and Settings\tkyte>net start oracleserviceora10gr1 The OracleServiceORA10GR1 service is starting.......... The OracleServiceORA10GR1 service was started successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:45:12 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> in the above ora10gr1 is my oracle sid, you can use control panel instead - control panel -> services -> look for the services starting with Oracle. Reviews Write a Review Another method September 10, 2007 - 3:15 am UTC Reviewer: Ar
here for a quick overview of the site Help Center Detailed answers to any questions you might http://stackoverflow.com/questions/3470205/unable-to-import-dump-using-imp have Meta Discuss the workings and policies of this site About http://www.ajpdsoft.com/modules.php?name=Foros&file=viewtopic&t=1056 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 oracle error programmers, just like you, helping each other. Join them; it only takes a minute: Sign up unable to import dump using “imp” up vote 0 down vote favorite I am trying to import into oracle using imp command and the output of the command is as below. invincible:/home/invincible# imp Import: Release 10.2.0.1.0 - Production on Thu imp-00058 oracle error Aug 12 22:19:00 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Username: n_data Password: IMP-00058: ORACLE error 1034 encountered ORA-01034: ORACLE not available ORA-27123: unable to attach to shared memory segment Linux Error: 13: Permission denied IMP-00005: all allowable logon attempts failed IMP-00000: Import terminated unsuccessfully invincible:/home/invincible# user name and password are correct(I am able to connect using sqldeveloper). I have granted dba access to n_data. All the environment variables are set (I ran oracle_env.sh before running env ). So what might be the problem? I am running oracle on debian. oracle oracle10g debian oracleclient ora-01034 share|improve this question edited Mar 19 '11 at 0:47 OMG Ponies 199k37356416 asked Aug 12 '10 at 17:06 hnm 27127 I assume the database is on the same host because you haven't specified a tns alias - is ORACLE_SID set correctly? –dpbradley Aug 12 '10 at 17:22 yes, database is on the same host. ORACLE_SID is set to XE. –hnm Aug 12 '
·Proponer ·Temas ·Top 10 ·Trucos ·Tutoriales ·Usuario ·Wiki NickContraseñaNuevo usuario English Proyecto AjpdSoft: Foros AjpdSoft :: Índice Fecha y hora actual: Mar Oct 18, 2016 8:05 pm Foros de discusión Ver mensajes sin respuesta Foro Último Mensaje Programación Borland Delphi, Codegear Delphi .Net Lenguaje de programación de Codegear. Trucos Delphi, utilidades, solución de errores, dudas. Mar Mar 22, 2016 6:59 pmfiderosado VB.Net, C# .Net, Visual Studio .Net Lenguaje de programación de Microsoft: Microsoft Visual Basic 6, Microsoft Visual Basic .Net, Microsoft Visual Studio .Net, Microsoft Visual C# .Net Dom Jun 05, 2016 10:31 amtcubells PHP, CMS, Joomla, WordPress, Alfresco, Apache, Tomcat, Drupal Lenguaje de programación para servidores Web (PHP Hypertext Pre-processor), para creación de contenido web dinámico. En este foro damos cabida también a los CMS como Joomla!, WordPress, Alfresco, Drupal, PHP-Nuke. También a los servicios web Apache, Tomcat, JBoss. Mie Feb 10, 2016 7:32 amalonsojpd Android, Java, software para smartphones Lenguaje de programación Java para desarrollo de aplicaciones para Android. Desarrollo de aplicaciones para smartphones y tablets Sab Ago 15, 2015 8:50 pmalonsojpd Base de Datos Oracle Database, motor de base de datos profesional Base de Datos Oracle (sistema de gestión de base de datos relacional), propiedad de Oracle Corporation. Errores Oracle, copia de seguridad, dudas. Mar Oct 04, 2016 12:16 pmquimby06 MySQL Server, MySQL Client, motor de bd gratuito Base de Datos MySQL Server. Motor de base de datos gratuito y open source. Errores, consultas SQL, dudas sobre MySQL. Sab Jun 25, 2016 8:56 pmCarlos_rrf Microsoft SQL Server, motor de base de datos profesional Microsoft SQL Server. Motor de base de datos profesional de Microsoft. Errores, dudas, consultas, copia de seguridad. Mar Oct 27, 2015 7:27 p