Ora 12560 Tns Protocol Adapter Error Windows Vista
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 ora-12560 tns protocol adapter error in oracle 11g a 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
Tns-00530: Protocol Adapter Error
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 ora 12560 tns protocol adapter error windows oracle client final. 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
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 ora 12560 tns protocol adapter error client machine company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions tns protocol adapter not loadable Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million tns-00511: no listener 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 Google[d] for this error ORA-12560: TNS:protocol adaptor error but https://community.oracle.com/thread/76240 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 accepted Go to the windows machine that hosts the Oracle database server Go http://stackoverflow.com/questions/6894558/ora-12560-tnsprotocol-adaptor-error 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 26 at 13:30 add a comment| Did you find this question interesting? Try our newsletter Sign up for our newsletter and get our top new questions de
can find lot of troubleshooting techniques and other information which helps http://techorcl.blogspot.com/2013/10/ora-12560-tns-protocol-adapter-error.html you to get some idea to fix your issues.. Technologies http://www.dbatoolz.com/t/installing-oracle-instantclient-basic-and-instantclient-sqlplus-on-win32.html Databases Operating Systems Tips & Tricks IT Careers ORA-12560: TNS Protocol adapter error ORA-12560is common error on Windows that results from any number of different causes. ORA-12560 is also very common exception when we have two Oracle homes. Mostly ORA-12560 occurs when protocol adapter we have Oracle Client configuration related issues but some times it may be due to Server side and network related issues. To resolve ORA-12560 we need to ensure following points: - Ensure Database Service is up. - Ensure listener is up and pointing to desired database service. - Ensure all oracle variables tns protocol adapter are configured correctly (ORACLE_BASE, ORACLE_HOME, ORACLE_SID, PATH, TNS_ADMIN). - On Windows: Ensure Full Access is granted to ORACLE_HOME and its sub-directories. In Windows OS: --------------- C:\Users\Home>set ORACLE_HOME=F:\app\Home2\product\11.2.0\dbhome_1 C:\Users\Home>SET ORACLE_SID=RED C:\Users\Home>sqlplus "/as sysdba" Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error C:\Users\Home>oradim -start -sid RED C:\Users\Home>sqlplus "/as sysdba" SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 4 00:08:27 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 640286720 bytes Fixed Size 1376492 bytes Variable Size 213913364 bytes Database Buffers 419430400 bytes Redo Buffers 5566464 bytes Database mounted. Database opened. SQL> conn sys@red as sysdba Enter password: Connected. SQL> Possible fixes for the TNS-12560 include: Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: database, ORACLE No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Topics AWS (2) cloud (2) database (34) LINUX (8) MS SQL (4) NETWORKING
I typically setup a dedicated DBA Portal website wherever I work and then write up instructions for repetitive things like these. It’s all about – do it once and forget it. Here’s the copy of the writeup I did to install the latest 11g Oracle instantclient basic and instantclient sqlplus on win32: Download Software Go to Instant Client Downloads for Microsoft Windows (32-bit) download page: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html And download basic-win32 and sqlplus-win32 files to your PC (for example): instantclient-basic-win32-11.1.0.7.0.zip instantclient-sqlplus-win32-11.1.0.7.0.zip Create Oracle Directory Create a .comment-content 8 directory on your C drive (if you don’t already have one) and move both files into .comment-content 7. Unzip both files first unzip .comment-content 6 then unzip .comment-content 5 to unzip: right click on file point to WinZip Click Extract to here … End result should be a new folder called .comment-content 4 in your .comment-content 3: Setup your system %PATH% and %TNS_ADMIN% variables In Windows explorer LEFT pane, right click on My Computer icon and click Properties Click Advanced tab Click Environment variables button: In the System Variables panel select .comment-content 2 variable and click Edit button: In the Variable Value field paste the following: .comment-content 1. Make sure it’s before all other path values that point to your OLD Oracle clients, then clickOk Now find a variable called .comment-content 0 – it could be in either panel (System / User), if you don’t have such variable, create it in the User panel by clicking New: .comment-body 9 Click Ok Now click Ok on the Environment Variables screen and click Ok on the System Properties window to close it Setup tnsnames.ora file If you already have an existing copy of .comment-body 8 file then place it to: .comment-body 7 If you don’t - then create a new .comment-body 6 file, for example: .comment-body 5 Test 11g client by running sqlplus Open a new CMD window by going to Start->Run In the Run Window type in: cmd and press Ok: in the CMD window’s prompt - enter the following: .comment-body 4 where: .comment-body 3 example: .comment-body 2 Known Errors: If you get the .comment-body 1 error while running sqlplus: .comment-body 0 Here’s the solution: To fix the #comment-## 9 error, go to your registry editor (run regedit from Start->Run) and then: Navigate to Windows Registry in #comment-## 8 Remove the #comment-## 7 from there (select it and del