ora-12538:TNS:no such protocol adaptor

[charity]

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.

Can anybody tell me what's going on here?

thanks,
charity

[rpardip]

Try to look into Net8 error messages and you will find the
description for this error.

I think the problem is related to incorrect configuration of LISTENER service. Try to open LISTENER.ora file and double-check.

Hope this helps

[charity]

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)

CAn any body help with the spaecifics?

[pando]

recreate the services with Oradim

[charity]

Thanks Pando,
I have never created service before using ORADIM. Can you tell me the specifics involved?

P.S.I am running 8i(8.1.5) on NT.

thanks,
charity

[rschulze]

Folow this logic :

set ORACLE_SID=demo

E:\orant\bin\oradim80 -new -sid demo -intpwd manager -startmode auto -pfile E:\orant\database\initDEMO.ora

E:\orant\bin\oradim80 -startup -sid demo -starttype srvc -usrpwd manager -pfile E:\orant\database\initDEMO.ora

U do this in a dos window on the server

Good luck

[silvester21]

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.


Cheers !!!!

[simply_dba]

[QUOTE]C:\>svrmgrl
The name specified is not recognized as an
internal or external command, operable program or batch file.[/QUOTE]

check ORACLE_HOME is set .Also ORACLE_HOME\bin should be in your path

[davey23uk]

why reply to messages that are 6 YEARS OLD

[simply_dba]

:D
Well this post came to my new posts listand i did not looked at the date.