Adpater Error
Contents |
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 adapter error message no attributes could be modified this site About Us Learn more about Stack Overflow the company Business
Aix Adapter Error
Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask ora-12560 tns protocol adapter error 11g 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
Tns-00530: Protocol Adapter Error
up ORA-12560: TNS:protocol adaptor error up vote 32 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 protocol adapter error oracle 11g '11 at 5:39 mr_eclair 14.6k2386127 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
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted!
Protocol Adapter Error In Oracle 12c
Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don
Tns Adapter Error In Oracle 11g Client
Burleson Blog
ORA-12560: TNS: hamachi network adapter error protocol adapter error Oracle Tips by Burleson Question: I installed Oracle 10g on my server but there is a problem with error "ORA-12560:TNS:protocol adapter http://stackoverflow.com/questions/6894558/ora-12560-tnsprotocol-adaptor-error error". When I sign on I get the error "ORA-12560:TNS:protocol adapter error"... Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: ORA-12560: TNS:protocol http://www.dba-oracle.com/t_ora_12560_tns_protocol_adapter_error.htm adapter error Answer by Edward Stoever: Is there a listener running? Have you run the netca program to configure and start the listener? The Oracle docs note that you should troubleshoot the ORA-12560 by tracing the connection: ORA-12560: TNS: protocol adapter error Cause: A generic protocol adapter error occurred. Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors. For further details, turn on tracing and re-execute the operation. Turn off tracing when the operation is complete. If you are running Oracle on Windows, you may fi the ORA-12560 by running the oradim utility to create a service for the listener. MOSC Note: 117976.1 offers tips for diagnosing the TNS-12560 error noting that the TNS-12560 is in the TNS transport layer and the TNS-12560 may only be a symptom of a lower-level network error as listed in MOSC Note 3log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and http://dba.stackexchange.com/questions/68939/error-ora-12560-when-trying-to-connect-windows-sqlplus-client-to-oracle-11g-lin policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered http://www.orafaq.com/forum/t/185824/ Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join adapter error them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Error ORA-12560 when trying to connect Windows SQL*Plus client to Oracle 11g Linux server up vote 2 down vote favorite 2 I installed 11g on Centos VM on my mac.I have protocol adapter error everything up and working on server.I have included following command I ran on cenos. $lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-JUN-2014 14:49:41 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hayer)(PORT=1522))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 23-JUN-2014 14:03:58 Uptime 0 days 0 hr. 45 min. 42 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/hayer/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hayer)(PORT=1522))) Services Summary... Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully My tnsnames.ora file is as follows: # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = hayer)(PORT = 1522)) ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hayer)(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) (SID = orcl) ) ) ~ ~ ~ ~ On Centos ser
friend ORA-12560: TNS:protocol adapter error [message #575165] Sun, 20 January 2013 16:36 ganesh_gvn Messages: 33Registered: February 2012 Location: PUNE Member Dear All, I have installed Oracle 11gR2 on Window 7 (Home Basic). Now I am trying to access my database with named 'TEST', from cmd, but I am getting "TNS:protocol adapter error" Below is the error : ============================================================================================= Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\Home>sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Mon Jan 21 03:59:55 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: sys as sysdba Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: / as sysdba ERROR: ORA-12560: TNS:protocol adapter error ================================================================================================== When I start the service name 'OracleServiceTest', then I am not getting the error. But It won't allow me to 'startup' the database instead database get started with 'OracleServiceTest' service start. I am doing this as ADMINISTRATOR. I am not understanding where I am wrong. How this can be solved. Please suggest me. Thanks in advance. Ganesh [Updated on: Mon, 21 January 2013 13:51] by ModeratorReport message to a moderator Re: ORA-12560: TNS:protocol adapter error [message #575174 is a reply to message #575165] Sun, 20 January 2013 22:19 rishwinger Messages: 132Registered: November 2011 Senior Member Ganesh I hope you googled about this error and tried everything I am not sure this would work for you but I resolved this error by fixing my environment variables Edit environment variable tns_admin and point it to your tnsnames.ora file location Report message to a moderator Re: ORA-12560: TNS:protocol adapter error [message #575175 is a reply to message #575174] Sun, 20 January 2013 22:45 BlackSwan Messages: 24912Registered: January 2009 Senior Member >I have installed Oracle 11gR2 on Window 7 (Home Basic). No Oracle version is ever supported on any Windows Home Edition. I don't know of anyone who has gotten V11 Oracle to work on Windows 7 Home edition. Report message to a moderator Re: ORA-12560: TNS:protocol adapter error [message #575251 is a reply to message #575175] Mon, 21 January 2013 13:47 ganesh_gvn Messages: 33Registered: February 2012 Location: PUNE Member Dear Rishwinger , I googled everything before posting above query. But the issue not resolved. even as per your comment , "Edit environment variable tns_admin and point it to