Protocol Adapter Error In Oracle 11g R2
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 ora-12560 tns protocol adapter error in oracle 11g AskTom team: Reflections on Oracle Open World 2015 Latest Followup You
Ora 12560 Tns Protocol Adapter Error 11g Client
Asked i'm running oracle on standalone computer at home.it used to work properly but from couple
Ora 12560 Tns Protocol Adapter Error Windows Oracle Client
of days i'm getting 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
Tns-00530: Protocol Adapter Error
up. 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 - Production With the Partitioning, OLAP and Data Mining tns protocol adapter not loadable 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 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
Επιλέξτε τη γλώσσα σας. Κλείσιμο Μάθετε περισσότερα View this message in English Το YouTube εμφανίζεται στα Ελληνικά. Μπορείτε να αλλάξετε αυτή την oracleserviceorcl not found προτίμηση παρακάτω. Learn more You're viewing YouTube oracleserviceorcl not found in services in Greek. You can change this preference below. Κλείσιμο Ναι, θέλω tns-03505 failed to resolve name να τη κρατήσω Αναίρεση Κλείσιμο Αυτό το βίντεο δεν είναι διαθέσιμο. Ουρά παρακολούθησηςΟυράΟυρά παρακολούθησηςΟυρά Κατάργηση όλωνΑποσύνδεση Φόρτωση... https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 Ουρά παρακολούθησης Ουρά __count__/__total__ Oracle - TNS : Protocol Adapter Error Working Solution Srijit Banerjee ΕγγραφήΕγγραφήκατεΚατάργηση εγγραφής801801 Φόρτωση... Φόρτωση... Σε λειτουργία... Προσθήκη σε... Θέλετε να το δείτε ξανά αργότερα; Συνδεθείτε για να προσθέσετε το βίντεο σε https://www.youtube.com/watch?v=oIsbPJGC2k4 playlist. Σύνδεση Κοινή χρήση Περισσότερα Αναφορά Θέλετε να αναφέρετε το βίντεο; Συνδεθείτε για να αναφέρετε ακατάλληλο περιεχόμενο. Σύνδεση 49.389 προβολές 76 Σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 77 6 Δεν σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 7 Φόρτωση... Φόρτωση... Φόρτωση... Η δυνατότητα αξιολόγησης είναι διαθέσιμη όταν το βίντεο είναι ενοικιασμένο. Αυτή η λειτουργία δεν είναι διαθέσιμη αυτήν τη στιγμή. Δοκιμάστε ξανά αργότερα. Ανέβηκε στις 14 Φεβ 2012Oracle - TNS : Protocol Adapter Error Working Solution Κατηγορία Εκπαίδευση Άδεια Τυπική άδεια YouTube Εμφάνιση περισσότερων Εμφάνιση λιγότερων Φόρτωση... Διαφήμιση Αυτόματη αναπαραγωγή Όταν είναι ενεργοποιημέ
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 http://stackoverflow.com/questions/21707368/tns-protocol-adapter-error-with-oracle-and-odac Business Learn more about hiring 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 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Tns protocol adapter error with Oracle and ODAC up vote 1 down vote favorite I am using Oracle 11g express edition.Getting error when protocol adapter I try to connect with SQLPLUS / AS SYSDBA in command window. Error is : TNS protocol adapter error. tnsping tns_entry_name Message:Used parameter files: C:\oraclexe\app\oracle\product\11. TNS-03505: Failed to resolve name I am using window XP, Oracle Service is running, Firewall is off. I can connect through sqldeveloper but not through sql plus. Please help guys, if you need any other information kindly reply. Many thanks. EDIT: tnsnames.ora file XE = (DESCRIPTION = (ADDRESS = protocol adapter error (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) EDIT2 : Unistalled the Oracle Developer tools with ODAC 11.2 release 5. And everything goes back to normal. I can connect through sqlplus. But I want to connect through .NET, Is ODTwithODAC 11.2r5 not compatible with oracle 11g express. Please help. EDIT3: As by the comments, In order to use ODT with ODAC 11.2 , do I need to install Oracle Client also or there some another way. Please suggest Many thanks. oracle oracle11g share|improve this question edited Feb 11 '14 at 22:43 asked Feb 11 '14 at 16:25 MKMohanty 586415 Check the tnsnames.ora file and compare the host and service names with the names you entered in sql developer. –Jasti Feb 11 '14 at 18:00 @Jasti Its same ... I am using default XE for SID and service name both –MKMohanty Feb 11 '14 at 21:25 Can you post screen shot of your sql developer connection and tnsnames.ora file