Ora 12560 Error 9i
Contents |
Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus � Version: 9.2.0 Whilst you are here, check out some content from the AskTom team: Certification exams Latest Followup You ora 12560 tns protocol adapter error windows Asked i'm running oracle on standalone computer at home.it used to work ora 12560 tns protocol adapter error 11g client properly but from couple of days i'm getting error stating "ORA-12560: TNS:protocol adapter error " what should i ora-12560 tns protocol adapter error sqlplus 11g do? please help.. (scott/tiger) and we said... sounds like the database is not up. you probably restarted your machine and the instance is not set to autostart C:\Documents and Settings\tkyte>sqlplus
Ora-12560 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 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 ora-12560 windows 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 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: Arangaperumal G from Chennai,India Start -->
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 tns-00530: protocol adapter error Stack Overflow the company Business Learn more about hiring developers or posting ads with
Ora 12560 Tns Protocol Adapter Error Windows Oracle Client
us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is
Ora 12560 Tns Protocol Adapter Error Client Machine
a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ora 12560 tns protocol adapter error- while connecting to oracle up vote 0 https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 down vote favorite I have oracle 9i already installed in my machine. I am trying to connect to the oracle but while connection i am getting "ora 12560 tns protocol adapter error" type of error. i have tried it with the default pass scott/tiger , system/manager.. When i tried to connect to the oracle using default credentials i am getting the above error. is it the problem with the username http://stackoverflow.com/questions/13248981/ora-12560-tns-protocol-adapter-error-while-connecting-to-oracle and password ? if so how can i get the username and password which is already set ? oracle oracle9i share|improve this question asked Nov 6 '12 at 10:23 user1728578 2717 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote IME, ORA-12560 means the Oracle Universal Installer messed up your listener configuration. Assuming you have an Oracle 9i Server installed on your computer, here's a list of things to check. does "lsnrctl status" show your database instance? does "tnsping my_service_name" work? do tnsnames.ora and listener.ora contain entries for your database? Are the hostname / port etc. correct? If the configuration is wrong, your best bet is to start netca, remove your existing listener configuration and re-configure it. One question, though: Why do you want to run Oracle 9i? Do you have to support some kind of legacy application / database? (Oracle 11gR2 is so much nicer than 9i) share|improve this answer answered Nov 6 '12 at 11:26 Frank Schmitt 18.8k63368 add a comment| up vote 0 down vote Start -> Run -> services.msc Select the oracle service name and right click on it then select start. share|improve this answer edited Jul 2 '13 at 18:43 DontVoteMeDown 9,59453171 answered Jul 2 '13 at 18:23
ORA-12560: TNS:protocol adapter error Deepak Soni SubscribeSubscribedUnsubscribe4444 Loading... Loading... Working... Add to Want to watch this again later? Sign in to add this video to a playlist. Sign in Share More Report Need to report the video? Sign in to report inappropriate https://www.youtube.com/watch?v=agx5uVIq3gw content. Sign in Transcript Statistics 111,811 views 217 Like this video? Sign in to make your opinion count. Sign in 218 22 Don't like this video? Sign in to make your opinion count. Sign in 23 Loading... Loading... Transcript The interactive transcript could not be loaded. Loading... Loading... Rating is available when the video has been rented. This feature is not available right now. Please try again later. Published on Apr 12, protocol adapter 2014protocol error while login. unable to start services. Category People & Blogs License Standard YouTube License Show more Show less Loading... Advertisement Autoplay When autoplay is enabled, a suggested video will automatically play next. Up next how to fix ORA-12560 TNS:protocol adapter error ? - Duration: 4:12. Programming World 5,581 views 4:12 Resolved: The Network Adapter could not establish the connection - Duration: 9:36. daniele perrotta 31,335 views 9:36 How To Solve TNS protocol adapter error protocol Adapter Error Of Oracle Database!! - Duration: 3:44. Cecret Point 582 views 3:44 Oracle - TNS : Protocol Adapter Error Working Solution - Duration: 0:57. Srijit Banerjee 49,307 views 0:57 Oracle - Understanding the tnsnames.ora and listener.ora files - Duration: 12:46. Chris Ostrowski 91,272 views 12:46 How to solve TNS: protocol adaptor error in oracle - Duration: 4:41. Tsega Zeab 5,520 views 4:41 Oracle username and password and Account unlocking - Duration: 8:37. Chandra Shekhar Reddy 117,528 views 8:37 ORACLE DBA Telephonic Round Interview - Duration: 41:57. Yasin Basha 68,488 views 41:57 solving protocol adapter error in oracle 11g - Duration: 2:10. ANANTHAN N.A 18,626 views 2:10 insufficient privileges Problem solved - Duration: 7:21. BunHong Hak 49,311 views 7:21 ORA-12505: TNS:listener does not currently know of SID given in connect descriptor - Duration: 1:49. INNo MATHs 25,545 views 1:49 ora - 12514 and ora - 12505 tns listener error fixed in 90 seconds ✅ - Duration: 1:30. CBOT 1,746 views 1:30 how to solve ORA 12560 TNS protocol adapter error in oracle - Duration: 1:14. Anilkumar 455 1,696 views 1:14 Oracle Error Fix : Network Adapter Couldn't Be Establish Connection - Duration: 3:02. pra30k 9,782 views 3:02 How to install Oracle 10g on Windows 7 32bit 64bit.flv - Duration: 7:18. Mustafa Ujjainwala 32,207 views