| ora-12560: tns:protocol adapter error after installing ODP.NET [message #360428] |
Thu, 20 November 2008 23:19  |
stanomatic
Messages: 1
Registered: November 2008
Location: Denver, CO
|
Junior Member |
|
|
I am new to Oracle and I am receiving this error after installing ODP.NET. “ora-12560: tns:protocol adapter error”
I installed 10g Express and ran a bat file. All is good. Inside the bat file it reads similar to “sqlplus USER/PASSWORD …”.
Installed ODP.NET and ran the identical bat file and had the error ora-12560: tns:protocol adapter error. BUT if I access All Programs | Oracle Database 10g Express Edition | Run SQL Command Line and log in with the identical credentials found in the bat file it WORKS!. In short, opening up cmd and connecting throws an error but the “All Programs | Oracle Database 10g Express Edition | Run SQL Command Line” works. Please make the distinction here.
I decided to replicate the problem. That is: Fresh install of 10g Express. I copied the tnsnames.ora, listener.ora, sqlnet.ora to my desktop and then installed ODP.NET. I did a file compare and they are identical. So the change is somewhere.
The listener service is working.
Does anyone have a fix instead of reinstalling 10g the next time this happens?
Stan
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
