How To Solve Tns Protocol Adapter Error In Oracle 8i
Contents |
Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus � Version: 9.2.0 Latest Followup ora 12560 tns protocol adapter error windows You Asked i'm running oracle on standalone computer at
Ora 12560 Tns Protocol Adapter Error 11g Client
home.it used to work properly but from couple of days i'm getting error ora-12560 tns protocol adapter error sqlplus 11g 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.
Tns-00530: Protocol Adapter Error
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 - ora 12560 tns protocol adapter error windows oracle client 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 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 2
Du siehst YouTube auf Deutsch. Du kannst diese Einstellung unten ändern. Learn more You're viewing YouTube in German. You can change this preference below. Schließen Ja, ich möchte sie behalten Rückgängig machen Schließen Dieses Video ist nicht verfügbar. WiedergabelisteWarteschlangeWiedergabelisteWarteschlange
Ora-12560 Sqlplus
Alle entfernenBeenden Wird geladen... Wiedergabeliste Warteschlange __count__/__total__ how to solve ORA-12560: TNS:protocol adapter
Ora-12560 Windows
error Deepak Soni AbonnierenAbonniertAbo beenden4444 Wird geladen... Wird geladen... Wird verarbeitet... Hinzufügen Möchtest du dieses Video später noch einmal ora 12560 tns protocol adapter error client machine ansehen? Wenn du bei YouTube angemeldet bist, kannst du dieses Video zu einer Playlist hinzufügen. Anmelden Teilen Mehr Melden Möchtest du dieses Video melden? Melde dich an, um unangemessene Inhalte zu melden. https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 Anmelden Transkript Statistik 110.944 Aufrufe 217 Dieses Video gefällt dir? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 218 22 Dieses Video gefällt dir nicht? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 23 Wird geladen... Wird geladen... Transkript Das interaktive Transkript konnte nicht geladen werden. Wird geladen... Wird geladen... Die Bewertungsfunktion ist nach Ausleihen des Videos verfügbar. https://www.youtube.com/watch?v=agx5uVIq3gw Diese Funktion ist zurzeit nicht verfügbar. Bitte versuche es später erneut. Veröffentlicht am 12.04.2014protocol error while login. unable to start services. Kategorie Menschen & Blogs Lizenz Standard-YouTube-Lizenz Mehr anzeigen Weniger anzeigen Wird geladen... Anzeige Autoplay Wenn Autoplay aktiviert ist, wird die Wiedergabe automatisch mit einem der aktuellen Videovorschläge fortgesetzt. Nächstes Video how to fix ORA-12560 TNS:protocol adapter error ? - Dauer: 4:12 Programming World 5.581 Aufrufe 4:12 Oracle - Understanding the tnsnames.ora and listener.ora files - Dauer: 12:46 Chris Ostrowski 90.535 Aufrufe 12:46 Oracle DBA Justin - How to backup and restore an Oracle database with RMAN (basic) - Dauer: 18:53 jbleistein11 199.632 Aufrufe 18:53 Oracle DBA Justin - How to mirror/multiplex online redo log files - Dauer: 8:32 jbleistein11 5.175 Aufrufe 8:32 Oracle DBA Justin - How to lock and unlock a user account in an Oracle database - Dauer: 2:43 jbleistein11 15.234 Aufrufe 2:43 ORACLE DBA Telephonic Round Interview - Dauer: 41:57 Yasin Basha 68.276 Aufrufe 41:57 Oracle listener configuration | listener.ora | listener configuration in oracle 11g - Dauer: 5:29 Wysheid Wysheid 10.553 Aufrufe 5:29 solving protocol adapter error in oracle 11g - Dauer: 2:10 ANANTHAN
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 http://stackoverflow.com/questions/6894558/ora-12560-tnsprotocol-adaptor-error 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 programmers, just like you, helping each other. Join them; it only takes a 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 protocol adapter this error ? Can anyone tell 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 protocol adapter error start the oracle database service (if not already running) 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 oracleserviceOR