Ora 12560 Tns Protocol Adapter Error Client Machine
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
Ora-12560 Tns Protocol Adapter Error In Oracle 11g
title. You can not post a blank message. Please type your message ora 12560 tns protocol adapter error 11g client and try again. More discussions in Service All PlacesOracle ApplicationsE-Business SuiteCustomer Experience (CX)Service This discussion is archived 12 ora-12560 tns protocol adapter error sqlplus 11g 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 I am using Win XP Pro. in my PC. I
Ora-12560 Sqlplus
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 error. I am new to Oracle. Please give me the steps how to fix this error to be able to run SQL+. Many thanks 159279Views Tags: none (add) This content has been marked as final.
Ora 12560 Tns Protocol Adapter Error Windows Oracle Client
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. 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: TN
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 tns-00530: protocol adapter error to access my database with named 'TEST', from cmd, but I am getting
Tns Protocol Adapter Not Loadable
"TNS:protocol adapter error" Below is the error : ============================================================================================= Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights tns-00511: no listener 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: https://community.oracle.com/thread/76240 / 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 http://www.orafaq.com/forum/t/185824/ 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: 24958Registered: January 2009 Location: SoCal 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.
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings http://stackoverflow.com/questions/6894558/ora-12560-tnsprotocol-adaptor-error and policies of this 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 http://itbloggertips.com/2013/11/fixed-ora-12560-tns-protocol-adapter-error/ 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 protocol adapter takes a minute: Sign up ORA-12560: TNS:protocol 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 tns protocol adapter 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 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
by Anil Kumar on November 17, 2013 All Posts, Database, Oracle DBA 14 Comments Rate this post When you login into Oracle Database and it throws an error message: Ora-12560: TNS: protocol adapter error Then follow the below mentioned steps to solve this issue. First of all, make sure that you have set the correct ORACLE_SID: C:\>sqlplus system/manager@xe SQL*Plus: Release 11.2.0.2.0 Production ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: 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, may be the OracleService for the 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. 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 Now restart the service using below method. Start > Run > Type Services.msc Start/Restart both Oracle service & listener service- OracleServiceXE & OracleXETNSListener 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 unable to resolve the issue, write below in comment section. We will try to solve your problem. Get Free Blogging Tips & Technology updates in your Email !!! Subscribe via RSS feed 0 Related PostsFixed - ORA-00844: Parameter not taking MEMORY_TARGET into accountFixed ORA-12518: TNS:listener could not hand off client connectionFixe