Ora 12560 Tns Protocol Adapter Error Xp
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
Ora-12560 Tns Protocol Adapter Error In Oracle 11g
about Stack Overflow the company Business Learn more about hiring developers or posting ads ora-12560 sqlplus with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack ora 12560 tns protocol adapter error 11g client Overflow is a community of 6.2 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
Ora-12560 Tns Protocol Adapter Error Sqlplus 11g
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 14.7k2387127 add a comment| 13 Answers 13 active oldest votes up vote 47 down vote
Ora-12560 Windows
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 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
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 tns-00530: protocol adapter error Ion Excel-DB Don Burleson Blog
Ora 12560 Tns Protocol Adapter Error Windows Oracle Client
ORA-12560: TNS: protocol adapter error Oracle Database Tips by Burleson ora 12560 tns protocol adapter error client machine Consulting Question: I installed Oracle 10g on my 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 http://stackoverflow.com/questions/6894558/ora-12560-tnsprotocol-adaptor-error 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 adapter error Answer by Edward Stoever: Is there a listener running? Have you run the netca program http://www.dba-oracle.com/t_ora_12560_tns_protocol_adapter_error.htm 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 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 s
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 http://techiesdigest.com/ora-12560-tns-protocol-adapter-error/ 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 protocol adapter 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 protocol adapter error 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 1388352 bytes Variable Size 620757184 bytes Database Buffers 444596224 bytes Redo Buffers 4591616 bytes Database mounted. Database opened. SQL> If you are still getting the same issue, write us in comment section. We will try to solve your problem. Subscribe to Get our FREE Newsletter automatically in your Inbox. 0 More Articl