How To Solve Tns Protocol Adapter Error In Oracle 10g
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 a title. You can not post a blank message. Please type your message and ora 12560 tns protocol adapter error 11g client try again. More discussions in Service All PlacesOracle ApplicationsE-Business SuiteCustomer Experience (CX)Service This discussion is ora-12560 tns protocol adapter error sqlplus 11g archived 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
Tns-12560: Tns:protocol Adapter Error Linux
I am using Win XP Pro. in my 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
Tns-00530: Protocol Adapter Error
error. I am new to Oracle. Please give me the steps how to fix this error to be able to run SQL+. Many thanks 158315Views Tags: none (add) This content has been 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. ora 12560 tns protocol adapter error windows oracle client 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 Likes(0) Actions 4. Re: re:ERROR:ORA-12560: TNS:protocol adapter error 521131 Jul 14, 2007 10:54 PM (in response to 585459) This error will come if Listener is not up or problem in tnsnames or database is not up. 1.Check the listener status by executing lsnrctl status 2.check the tnsnames entry is proper t not by tnsping INSTANCENAME 3.Check the database is up r not by checking the service in windows ,(process in Unix) Like Show 0 Likes(0) Actions 5. Re: ERROR:ORA-12560: TNS:protocol adapter error 599487 Sep 24, 2007 1
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
Ora-12560: Tns:protocol Adapter Error Sap
machen Schließen Dieses Video ist nicht verfügbar. WiedergabelisteWarteschlangeWiedergabelisteWarteschlange Alle entfernenBeenden Wird geladen... ora-12560 sqlplus Wiedergabeliste Warteschlange __count__/__total__ Oracle - TNS : Protocol Adapter Error Working Solution Srijit Banerjee AbonnierenAbonniertAbo beenden797797 Wird ora-12560 windows geladen... Wird geladen... Wird verarbeitet... Hinzufügen Möchtest du dieses Video später noch einmal ansehen? Wenn du bei YouTube angemeldet bist, kannst du dieses Video zu einer Playlist hinzufügen. https://community.oracle.com/thread/76240 Anmelden Teilen Mehr Melden Möchtest du dieses Video melden? Melde dich an, um unangemessene Inhalte zu melden. Anmelden 49.270 Aufrufe 75 Dieses Video gefällt dir? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 76 6 Dieses Video gefällt dir nicht? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 7 Wird https://www.youtube.com/watch?v=oIsbPJGC2k4 geladen... Wird geladen... Wird geladen... Die Bewertungsfunktion ist nach Ausleihen des Videos verfügbar. Diese Funktion ist zurzeit nicht verfügbar. Bitte versuche es später erneut. Hochgeladen am 14.02.2012Oracle - TNS : Protocol Adapter Error Working Solution Kategorie Bildung Lizenz Standard-YouTube-Lizenz Musik "Insurrection (Megara vs. DJ Lee Remix)" von Tripple Star (Google Play • iTunes) Mehr anzeigen Weniger anzeigen Wird geladen... Autoplay Wenn Autoplay aktiviert ist, wird die Wiedergabe automatisch mit einem der aktuellen Videovorschläge fortgesetzt. Nächstes Video how to solve ORA-12560: TNS:protocol adapter error - Dauer: 2:27 Deepak Soni 110.842 Aufrufe 2:27 Oracle username and password and Account unlocking - Dauer: 8:37 Chandra Shekhar Reddy 115.792 Aufrufe 8:37 how to fix ORA-12560 TNS:protocol adapter error ? - Dauer: 4:12 Programming World 5.581 Aufrufe 4:12 How to solve TNS: protocol adaptor error in oracle - Dauer: 4:41 Tsega Zeab 5.520 Aufrufe 4:41 Oracle - Understanding the tnsnames.ora and listener.ora files - Dauer: 12:46 Chris Ostrowski 90.535 Aufrufe 12:46 How to resolve the ora 12154 error - Dauer: 7:03 DBA Pro
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 http://stackoverflow.com/questions/6894558/ora-12560-tnsprotocol-adaptor-error site About Us Learn more 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 http://techiesdigest.com/ora-12560-tns-protocol-adapter-error/ 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 protocol adapter 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 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 protocol adapter error 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) 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 an
Facebook Twitter Google+ YouTube Google Products Gmail Google Apps Google Forms Google Drive Internet Android Reviews Fixed – ORA-12560: TNS: protocol adapter error Posted by Techies on June 29, 2015 Home 3 Comments This article will explain you how to resolve ORA-12560: TNS: protocol adapter error. Error Message: ORA-12560: TNS: protocol adapter error Resolution: Method-1: To resolve this issue, you need to make sure that you have set the correct oracle SID. Lets take the following example. C:\>sqlplus system/manager@xe SQL*Plus: Release 11.2.0.2.0 Production ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: I got the error "ORA-12560: TNS:protocol adapter error" Now what I did to resolve this issue. I set the Oracle SID on command prompt and tried to STARTUP again. Now this time my startup was successful. 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, might be service of Oracle 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. Method-2: 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 How to restart the Oracle Service? Go to Start > Run > Type Services.msc Now Start/Restart both Oracle service & listener service- OracleServiceXE & OracleXETNSListener Once both the services are started, try to start your database. 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