If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

Hi
Has any bodyever encountered this problem before?
Ora: -12538:TNS:no such protocol adaptor.
I could not find it under the error messages on documentation.

I tried to log on(through SQL*PLUS) to my NT machine running oracle 8i(8.1.5) and I had this message ORA-12538:TNS:no such protocol adaptor. This is exactly what I did:
e.g.
USERNAME.....................
PASWWORD..................
HOST STRING...............
Ora: -12538:TNS:no such protocol adaptor.

I logged on as system,sys,internal with all the right passwords but I kept getting the same error message.

I went to the dos prompt in attempt to get to the sever manager but that also did not help. This is exactly what I did at the dos prompt:

c:\>set oracle_sid=dbname
C:\>svrmgrl
The name specified is not recognized as an
internal or external command, operable program or batch file.

I think I have found out what the problem is but I am having a difficult time trying to solve it. I checked in services, all the oracle service are supposed to start automatically, but none of them started. So I clicked on them and clicked on the START button but it returned this error message:
could not start the oracleservice PROD on DDDDDD
Error 003: The system cannot find the path specified.

Note: PROD is the name of the service and DDDDD is the name of the computer(system)

12538:TNS:no such protocol adaptor

hi guys!!!

The problem could be as simple as mismatch of yor classpath. Just check your classpath settings to see if there are any conflicts in it.
May be you can check if you have set any variable like ORACLE_HOME. Remove/edit that variable and check connecting.