Re: re:ERROR:ORA-12560: TNS:protocol adapter error 609446 Nov 20, 2007 7:31 AM (in response to 521131) hi, facing a same problem.try to connect client to server but getting a same error. 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, INNo MATHs 25.545 προβολές 1:49 How to connect to Oracle Database using Toad for Oracle. - Διάρκεια: 8:42. I also goolged for this error and found that a lot of other people are also getting same error but unfortunately no one has any solution. useful reference

Ora-12560 Tns Protocol Adapter Error In Oracle 11g

A penny saved is a penny Can an irreducible representation have a zero character? I had getting ""ORA-12560: TNS:protoco.But ur 2nd-guide line more help me. Was Roosevelt the "biggest slave trader in recorded history"? also the user scott is created by default.

all of the advice on this page was for a local connection to a local database running on the machine sqlplus was. It worked fine without any errors. Best of Luck. Ora 12560 Tns Protocol Adapter Error Windows Oracle Client i enter the username and password is not correct and SQL*Plus: Release 11.1.0.6.0 - Production on Tue Nov 8 20:43:16 2011 Copyright (c) 1982, 2007, Oracle.

Ora 12560 Tns Protocol Adapter Error 11g Client

Also check /var/log/messages (Linux) for errors: TRACE_LEVEL_<> = admin TRACE_DIRECTORY_<> = <> TRACE_TIMESTAMP_<> = true Possible fixes for the TNS-12560 include: Check this page for more on SQL*Net Tracing Tips. Just goto Command prompt Set Oracle SID C:>set oracle_sid=ORCL Now run Net start command. Ora-12560 Tns Protocol Adapter Error In Oracle 11g That is, is "databaseServer" in a DNS or the machines hosts-file and that the lookup to it is correct. Ora-12560 Tns Protocol Adapter Error Sqlplus 11g Also, I had to make sure the IIS server was stopped because a default installation would try to start up the Apache HTTP server for Oracle.

Instance "orcl", status READY, has 1 handler(s) for this service... http://999software.com/protocol-adapter/ora-12560-tns-protocol-adapter-error-sql-plus.php When I tried to start an application I developed using odp.net, I got the following error message: "Could not load file or assembly 'system.EnterpriseServices,Version=2.0.0.0, Culture=neutral, PublicKeyToken=bo3f5f7f11d50a3a' or one of its dependencies. done July 05, 2012 - 2:50 am UTC Reviewer: A reader services.msc worked dude..thanks.. Browse other questions tagged oracle-11g-r2 windows linux sqlplus connectivity or ask your own question. Ora-12560 Sqlplus

It was a firewall issue - we had to open up access specifically to our client host on port 1521. What is the main spoken language in Kiev: Ukrainian or Russian? Under Oracle 10.2 the registry path is: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_Oracle You need a string named ORACLE_SID, with the value of your database sid. this page sqlplus scott/[email protected][databasename] as sysdba In this case with 11g XE I will use: sqlplus scott/[email protected] as sysdba Good luck!

share|improve this answer answered Aug 1 '11 at 5:46 Andrew Cooper 25.4k24688 add a comment| up vote 0 down vote If none the above work, then try this : Modify the

plz i needs ur help..... I don't know of anyone who has gotten V11 Oracle to work on Windows 7 Home edition. USB in computer screen not working Output the Hebrew alphabet Does the code terminate? Tns-00511: No Listener Regards Michel Report message to a moderator Re: ORA-12560: TNS:protocol adapter error [message #575255 is a reply to message #575251] Mon, 21 January 2013 14:08 Solomon Yakobson Messages:

redirect stdout and stderr to grep and filter out what you want to see and lose the rest. LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = hayer)(PORT = 1522)) ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hayer)(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = did you look up the error message to see what the likely action should be? Get More Info All rights reserved.