12560 Tns Protocol Adapter Error Windows
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 this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ora-12560 tns protocol adapter error windows oracle 11g ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the ora-12560 tns protocol adapter error 11g windows 7 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 tns protocol adapter error in oracle 11g on windows 7 minute: Sign 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 how to fix ora-12560 tns protocol adapter error 11g 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.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
Sqlplus Tns Protocol Adapter Error
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 oracleserviceORCL share|improve this answer answered Dec 6 '12 at 6:32 Yasir Ahmed 15112 2 Worked like a charm..Thanks Yasir –Web
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson
Tns Protocol Adapter Error 11g Client
Blog
sqlplus error ora-12560 ORA-12560: TNS: protocol adapter error Oracle Tips by Burleson Question: I installed Oracle 10g on my ora 12560 tns protocol adapter error visual studio server but there is a problem with error "ORA-12560:TNS:protocol adapter 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: http://stackoverflow.com/questions/6894558/ora-12560-tnsprotocol-adaptor-error 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 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 http://www.dba-oracle.com/t_ora_12560_tns_protocol_adapter_error.htm 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 39662.1. You can use MOSC Note 39774.1 to get a SQL*Net trace or follow these instructions for getting a SQL*Net trace. The "TNS-12560: TNS:protocol adapter error" sometimes a transient error on a SQL*Net (Oracle*Net) client, happening sporadically. To turn-on tracing for the ORA-12560, use these settings. Also check /var/log/messages (Linux) for errors: TRACE_LEVEL_<log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to http://dba.stackexchange.com/questions/68939/error-ora-12560-when-trying-to-connect-windows-sqlplus-client-to-oracle-11g-lin 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 https://supportforums.cisco.com/document/9371/user-receives-ora-12560-tnsprotocol-adapter-error about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and tns protocol answer site for database professionals who wish to improve their database skills and learn from others in the community. Join 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 tns protocol adapter 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 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 M
Contact Us Help Follow Us Newsletter Instagram YouTube Facebook Twitter Google + LinkedIn DirectoryNetwork InfrastructureWAN, Routing and Switching LAN, Switching and Routing Network Management Remote Access Optical Networking Getting Started with LANs IPv6 Integration and Transition EEM Scripting Other Subjects SecurityVPN Security Management Firewalling Intrusion Prevention Systems/IDS AAA, Identity and NAC Physical Security MARS Email Security Web Security Other Subjects Service ProvidersMetro MPLS Voice Over IP XR OS and Platforms Video Other Subjects Collaboration, Voice and VideoIP Telephony Video Over IP Jabber Clients Unified Communications Applications TelePresence Digital Media System Contact Center Conferencing UC Migrations Other Subjects Wireless - MobilitySecurity and Network Management Wireless IP Voice and Video Getting Started with Wireless WLCCA Other Subjects ServicesCisco ServiceGrid Connected Analytics Smart Call Home Smart Net Total Care Operations Exchange Mobile ApplicationsCisco Proximity Cisco Technical Support Online Tools and ResourcesCisco Bug Discussions Technical Documentation Ideas Cisco CLI Analyzer Support Community Help Data CenterApplication Centric Infrastructure Application Networking Intelligent Automation Server Networking Storage Networking Unified Computing Wide Area Application Services (WAAS) Other Subjects Small BusinessNetwork Storage Routers Security Surveillance Switches Voice and Conferencing Wireless Solutions and ArchitecturesBorderless Networks Collaboration Cisco User GroupsSeattle Cisco User Group (SEACUG) Silicon Valley Cisco User Group (SVCUG) Southern California Cisco User Group (SCCUG) Cisco Certifications Cisco.com Idea Center Cisco Cafe Expert CornerTop Contributors Leaderboards Cisco Live! Events Events Community CornerAwards & Recognition Behind the Scenes Feedback Forum Cisco Certifications Cisco Press Café Cisco On Demand Support & Downloads Community Resources Security Alerts Security Alerts News News Video Cisco Support YouTube Cisco YouTube Blogs Technical Documentation Cisco Products Products Services Services Solutions Solutions Global Support Numbers Cisco Support Community