Oracle Error 12560 Encountered Imp
Contents |
Search Username Password Remember Me? Register Lost Password? facebook google twitter rss Free Web Developer Tools Advanced Search Forum Databases Oracle Development IMP: ORA-12560 TNS:protocol
Imp-00058 Imp-00000 Import Terminated Unsuccessfully
adapter error Thread: IMP: ORA-12560 TNS:protocol adapter error Share This Thread ora-12560 tns protocol adapter error 11g Tweet This + 1 this Post To Linkedin Subscribe to this Thread Subscribe to This Thread August
Impdp From 10g To 11g
2nd, 2004,09:00 AM #1 No Profile Picture Zveroa View Profile View Forum Posts Registered User Devshed Newbie (0 - 499 posts) Join Date Jan 2004 Posts oracle 10g export 11g import 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 exist, but I want to overwrite existing data. I can connect to the database from the imp-00058 oracle error 12154 encountered 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 this: Code: export TWO_TASK=prosty OTherwise you have a network or SQLNet problem.... Faq Reply With Quote August 11th, 2004,04:29 AM #3 No Profile Picture Hans Brenkman View Profile View Forum Posts
Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus � Version: 9.2.0 Whilst you are here, check out some content
Import 10g Dump To 11g
from the AskTom team: On Better Loading and Fact-Checking Latest imp-00058 oracle error 12154 encountered 11g Followup You Asked i'm running oracle on standalone computer at home.it used to work properly but
Imp-00058 Oracle Error 1034 Encountered
from couple of days i'm getting error stating "ORA-12560: TNS:protocol adapter error " what should i do? please help.. (scott/tiger) and we said... sounds like the http://forums.devshed.com/oracle-development-96/imp-ora-12560-tns-protocol-adapter-error-170785.html 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 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 https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 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 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 t
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 http://stackoverflow.com/questions/3470205/unable-to-import-dump-using-imp 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 6.2 million 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 oracle error 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 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 imp-00058 oracle error 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 199k37361417 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 '10 at 17:26 Can you run sqlplus from the same prompt and log in? If so, can you run select count(*) from all_objects; and what does that query return? –Adam Musch Aug 12 '10 at 17:33 No I am not able to run sqlplus(that is why I am using sqldeveloper) –hnm Aug 12 '10 at 17:38 5 I know you've said that your environment is set up properly, but if you can't run SQL*Plus then something is wrong. Ca