Ora 12560 Error In Oracle 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: Loading ora 12560 tns protocol adapter error windows file data easier than you think Latest Followup You Asked i'm
Ora 12560 Tns Protocol Adapter Error 11g Client
running oracle on standalone computer at home.it used to work properly but from couple of days i'm getting
Ora-12560 Tns Protocol Adapter Error Sqlplus 11g
error stating "ORA-12560: TNS:protocol adapter error " what should i do? please help.. (scott/tiger) and we said... sounds like the database is not up. you probably restarted your
Ora-12560 Sqlplus
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 the Partitioning, OLAP and Data Mining options scott%ORA10GR1> exit Disconnected from Oracle Database ora-12560 windows 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 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 f
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 ora 12560 tns protocol adapter error windows oracle client Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation tns-00530: protocol adapter error Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just ora 12560 tns protocol adapter error client machine 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 down vote favorite I have oracle 9i already installed in https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 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 and password ? if so how can i get the username and password which is http://stackoverflow.com/questions/13248981/ora-12560-tns-protocol-adapter-error-while-connecting-to-oracle 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 mahesh 1 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email a
Google. Het beschrijft hoe wij gegevens gebruiken en welke opties je hebt. Je moet https://www.youtube.com/watch?v=agx5uVIq3gw dit vandaag nog doen. Navigatie overslaan NLUploadenInloggenZoeken Laden... Kies je taal. Sluiten Meer informatie View this message in English Je gebruikt YouTube in het Nederlands. Je http://itbloggertips.com/2013/11/fixed-ora-12560-tns-protocol-adapter-error/ kunt deze voorkeur hieronder wijzigen. Learn more You're viewing YouTube in Dutch. You can change this preference below. Sluiten Ja, nieuwe versie behouden Ongedaan maken Sluiten protocol adapter Deze video is niet beschikbaar. WeergavewachtrijWachtrijWeergavewachtrijWachtrij Alles verwijderenOntkoppelen Laden... Weergavewachtrij Wachtrij __count__/__total__ how to solve ORA-12560: TNS:protocol adapter error Deepak Soni AbonnerenGeabonneerdAfmelden4444 Laden... Laden... Bezig... Toevoegen aan Wil je hier later nog een keer naar kijken? Log in om deze video toe te voegen aan een afspeellijst. Inloggen Delen Meer Rapporteren Wil je protocol adapter error een melding indienen over de video? Log in om ongepaste content te melden. Inloggen Transcript Statistieken 111.811 weergaven 217 Vind je dit een leuke video? Log in om je mening te geven. Inloggen 218 22 Vind je dit geen leuke video? Log in om je mening te geven. Inloggen 23 Laden... Laden... Transcript Het interactieve transcript kan niet worden geladen. Laden... Laden... Beoordelingen zijn beschikbaar wanneer de video is verhuurd. Deze functie is momenteel niet beschikbaar. Probeer het later opnieuw. Gepubliceerd op 12 apr. 2014protocol error while login. unable to start services. Categorie Mensen & blogs Licentie Standaard YouTube-licentie Meer weergeven Minder weergeven Laden... Advertentie Autoplay Wanneer autoplay is ingeschakeld, wordt een aanbevolen video automatisch als volgende afgespeeld. Volgende how to fix ORA-12560 TNS:protocol adapter error ? - Duur: 4:12. Programming World 5.581 weergaven 4:12 How To Solve TNS protocol Adapter Error Of Oracle Database!! - Duur: 3:44. Cecret Point 582 weergaven 3:44 Resolved: Th
by Anil Kumar on November 17, 2013 All Posts, Database, Oracle DBA 14 Comments Rate this post When you login into Oracle Database and it throws an error message: Ora-12560: TNS: protocol adapter error Then follow the below mentioned steps to solve this issue. First of all, make sure that you have set the correct ORACLE_SID: C:\>sqlplus system/manager@xe SQL*Plus: Release 11.2.0.2.0 Production ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: C:\>set ORACLE_SID=xe C:\>sqlplus system/manager@xe Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production SQL> startup ORACLE instance started. Total System Global Area 1071333376 bytes Fixed Size 1388352 bytes Variable Size 620757184 bytes Database Buffers 444596224 bytes Redo Buffers 4591616 bytes Database mounted. Database opened. SQL> If the above method doesn’t work, may be the OracleService for the database is not running. Check for the service, if it is not running then starts the service. If it is running then restart the service. C:\>sqlplus SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 16 22:34:24 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: / as sysdba ERROR: ORA-12560: TNS:protocol adapter error Now restart the service using below method. Start > Run > Type Services.msc Start/Restart both Oracle service & listener service- OracleServiceXE & OracleXETNSListener C:\>sqlplus SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 16 22:41:30 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: / as sysdba Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1071333376 bytes Fixed Size 1388352 bytes Variable Size 620757184 bytes Database Buffers 444596224 bytes Redo Buffers 4591616 bytes Database mounted. Database opened. SQL> If you are still unable to resolve the issue, write below in comment section. We will try to solve your problem. Get Free Blogging Tips & Technology updates in your Email !!! Subscribe via RSS feed 0 Related PostsFixed - ORA-00844: Parameter not taking MEMORY_TARGET into accountFixed ORA-12518: TNS:listener could not hand off client connectionFixed - ORA-19809: limit exceeded for recovery filesFixed: Oracle not started-ORA-16038, ORA-19809, ORA-00312 errorORA-00600: internal error code - FixedResolved ORA-12154: TNS:could not resolve the connect identifier specifiedFixed - ORA-01033: