Impdp Oracle Error 12560
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter ora 12560 tns protocol adapter error windows a title. You can not post a blank message. Please type your
Ora-12560 Sqlplus
message and try again. More discussions in Service All PlacesOracle ApplicationsE-Business SuiteCustomer Experience (CX)Service This discussion is archived ora 12560 tns protocol adapter error 11g client 12 Replies Latest reply on May 25, 2008 3:40 AM by 641241 ERROR:ORA-12560: TNS:protocol adapter error 259579 Apr 18, 2002 1:03 AM I am using Win XP Pro. in my ora-12560 tns protocol adapter error sqlplus 11g PC. I just installed Oracle 9i. When I put in my user-name and password to run SQL+ 9.0.1 it gives me the following error message : ERROR:ORA-12560: TNS:protocol adapter error. I am new to Oracle. Please give me the steps how to fix this error to be able to run SQL+. Many thanks 158531Views Tags: none (add) This content has been
Ora-12560 Windows
marked as final. Show 12 replies 1. re:ERROR:ORA-12560: TNS:protocol adapter error 367198 Nov 8, 2002 5:03 AM (in response to 259579) I'm also having a hard time with the username and passwrd. I tried scott/tiger, system/manager and sys/change_on_install as sysdba but none work. please help. Like Show 0 Likes(0) Actions 2. Re: ERROR:ORA-12560: TNS:protocol adapter error 579656 Jun 7, 2007 7:23 PM (in response to 259579) Im new with Oracle also and when i open SQLPLUS I get the same error. What should i do? Can I just uninstall Oracle and re-install it again? Like Show 0 Likes(0) Actions 3. Re: re:ERROR:ORA-12560: TNS:protocol adapter error 585459 Jun 28, 2007 9:52 AM (in response to 367198) When installing oracle 9i there are two users sys and system who are created automatically,who have all the privileges however sys has more privileges. also the user scott is created by default. If you are not able to login then the installation may have not been done properly.better you deinstall all the products from oracle universal installer and then re-install oracle again. Like Show 0
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 tns-00530: protocol adapter error ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join ora 12560 tns protocol adapter error windows oracle client 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
Ora 12560 Tns Protocol Adapter Error Client Machine
minute: Sign up ORA-12560: TNS:protocol adaptor error up vote 33 down vote favorite 13 I Google[d] for this error ORA-12560: TNS:protocol adaptor error but not able to find the actual reason and how to solve this error ? Can anyone tell https://community.oracle.com/thread/76240 me a perfect solution to solve login problem. sql oracle oracle9i ora-12560 share|improve this question edited Jan 25 '14 at 7:58 asked Aug 1 '11 at 5:39 mr_eclair 14.7k2387127 add a comment| 13 Answers 13 active oldest votes up vote 47 down vote accepted Go to the windows machine that hosts the Oracle database server Go to Start -> Run -> Services.msc in windows. Locate OracleService (here OracleServiceORCL) and click on "Start" to start the oracle database service (if not already running) http://stackoverflow.com/questions/6894558/ora-12560-tnsprotocol-adaptor-error Once it is up and running, from the command prompt run the following: tnsping < tnsalias > (tnsalias entry you can find it in tnsnames.ora file) share|improve this answer answered Aug 1 '11 at 21:06 Bharathi 69857 9 In my case service is running but again this error ? what should i do? –Suhrob Samiev Sep 25 '12 at 10:38 So, this assumes you are running Oracle Server on Windows? –Jay Sullivan Sep 22 '14 at 13:50 I use Oracle 11g on Windows 8.1 . Before all, I set ORACLE_SID. sqlplus works, no problem, then I close it. I reopen, I try many times, but not working. Even, when service is running, sqlplus doesn't work. –Do Nhu Vy May 11 '15 at 16:11 I am using windows 8 and oracle 12c. Instead of "OracleServiceORCL" i have found "OracleServiceORACLE12C". I have just started it and i have to not run the command. Ur answer is very useful. –Black Swan Jan 26 at 13:30 add a comment| up vote 15 down vote Seems like database is not up. It might be due to restarting machine and the instance is not set to autostart and it so not started munually after starting from services Screen. Just goto Command prompt Set Oracle SID C:>set oracle_sid=ORCL Now run Net start command. C:>net start oracleserviceORCL share|improve this answer answered Dec 6 '12 at 6:32 Yasir Ahmed 15112 2 Worked like a c
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 http://stackoverflow.com/questions/35223645/ora-12560-tns-error-protocol-adapter Learn more about Stack Overflow the company Business Learn more about hiring developers http://forums.devshed.com/oracle-development-96/imp-ora-12560-tns-protocol-adapter-error-170785.html 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-12560: TNS: Error protocol Adapter up vote protocol adapter 1 down vote favorite I would like to export database schema with expdp/impdp. For that reason I am trying to do the same steps like in this tutorial. when I enter sqlplus / as sysdba in the command line, I will be ased to enter user name and pasword. When I do this and click Enter, the following errors is comming: ORA-12560: TNS: Error protocol Adapter I protocol adapter error am using windows 7 and have installed oracle 12c. All oracle services are started. I login from cmd.exe as adminstrator oracle oracle12c share|improve this question asked Feb 5 at 11:56 Ronald 568413 open de cmd and do this lsnrctl status and tell me what's the result –download dowload Feb 5 at 12:05 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted I think i khnow the problem you said that you did the same steps in the tuto. In the tutoriel he did this step C:>set oracle_sid=db my question did you have the same name of the Oracle SID ? if you did a default installation by the default the Oracle SID is orcl in your case do this C:>set oracle_sid=ORCLto verify the Oracle SID go to this path C:\oracle\app\oracle\product\11.2.0\server\network\ADMIN and open the listener.ora and check the host name LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST =ORCL)(PORT = 1521) ) ) ) If you have HOST =ORCL then you must do this C:>set oracle_sid=ORCL if you have another name you do this C:>set oracle_sid=NAME_OF_YOUR_HOST share|improve this answer answered Feb
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 adapter error Thread: IMP: ORA-12560 TNS:protocol adapter error Share This Thread Tweet This + 1 this Post To Linkedin Subscribe to 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 (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 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 this: Code: export TWO_TASK=prosty OTherwise you have a network or SQLNet problem...