DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: ora-12538:TNS:no such protocol adaptor

  1. #1
    Join Date
    Aug 2000
    Location
    NY
    Posts
    37

    Red face

    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

  2. #2
    Join Date
    Sep 2000
    Posts
    155

    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

  3. #3
    Join Date
    Aug 2000
    Location
    NY
    Posts
    37
    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?

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    recreate the services with Oradim

  5. #5
    Join Date
    Aug 2000
    Location
    NY
    Posts
    37
    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

  6. #6
    Join Date
    Oct 2000
    Posts
    33
    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

  7. #7
    Join Date
    Nov 2006
    Posts
    1

    Smile 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.


    Cheers !!!!

  8. #8
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    [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
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    why reply to messages that are 6 YEARS OLD

  10. #10
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    :D
    Well this post came to my new posts listand i did not looked at the date.
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width