Home » Infrastructure » Windows » ORA-12560 TNS: Protocol Adapter Error (Oracle 10g xe)
ORA-12560 TNS: Protocol Adapter Error [message #643483] Thu, 08 October 2015 07:05 Go to next message
denzil76
Messages: 1
Registered: October 2015
Location: India
Junior Member
Hello friends, I have this peculiar problem. I have installed Oracle 10g Express edition on my Win 2008 Entp Edition OS (64 bit). But I am not able to connect the database using Visual Studio 2010 and thru Sql Plus also. I can connect the database and browse thru records using the database Home page in the browser. I can also connect to this database via another computer having oracle 9.2 client but this node wont connect to its own database or any other database on other nodes.

I have gone thru most of the solutions in various forums but of no help. Please let me know what can be done in this case.


Regards,

Denzil.
Re: ORA-12560 TNS: Protocol Adapter Error [message #643485 is a reply to message #643483] Thu, 08 October 2015 07:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum.


Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

> But I am not able to connect the database using Visual Studio 2010 and thru Sql
above is completely devoid of any actionable detail.
We don't know what you actually did & we don't know how Oracle responded.

use COPY & PASTE, please

Re: ORA-12560 TNS: Protocol Adapter Error [message #643488 is a reply to message #643483] Thu, 08 October 2015 08:02 Go to previous messageGo to next message
gazzag
Messages: 1103
Registered: November 2010
Location: Bedwas, UK
Senior Member
Oracle 11g XE is available here.
Re: ORA-12560 TNS: Protocol Adapter Error [message #643489 is a reply to message #643483] Thu, 08 October 2015 08:24 Go to previous messageGo to next message
Michel Cadot
Messages: 67997
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You have to set ORACLE_SID environment variable.

Re: ORA-12560 TNS: Protocol Adapter Error [message #643490 is a reply to message #643489] Thu, 08 October 2015 08:29 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>ORA-12560 TNS: Protocol Adapter Error

Many varied causes exist for error above on Windows

Is the OS Service for the listener started & running?

open a Command Window & issue OS commands below

lsnrctl status
lsnrctl service

COPY the results from above then PASTE all back here
Re: ORA-12560 TNS: Protocol Adapter Error [message #643491 is a reply to message #643490] Thu, 08 October 2015 08:38 Go to previous message
gazzag
Messages: 1103
Registered: November 2010
Location: Bedwas, UK
Senior Member
Quote:
I can connect the database and browse thru records using the database Home page in the browser. I can also connect to this database via another computer having oracle 9.2 client
Previous Topic: not opened go to database homepage
Next Topic: Error while Installation
Goto Forum:
  


Current Time: Thu Oct 21 15:10:58 CDT 2021