ora-12222:tns no such protocol adapter
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: ora-12222:tns no such protocol adapter

  1. #1
    Join Date
    Oct 2000
    Posts
    56
    Man... I did something to my workstation... and i can't figure out what i did. I've checked the registry, and the tnsnames.ora file is located where it's supposed to be...but suddenly i can't get to any of my databases...

    I checked and i still have read access to the tnsnames file... so that can't be the reason...

    I've even tried editing the registry to include TNS_ADMIN and specifying a different path... but i cant get in anywhere.. getting the same:
    ora-12222:tns no such protocol adapter
    or ... tns canot resolve host name message.

    I tried doing TNSPING and get
    Message 3509 not found; No message file for product=NETWORK, facility=TNS

    ... i'm not sure what this message means... can you tell me...

    how do i resolve this problem??? i thought i did all the right troubleshooting, but apparently not!@ :(

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    try reinstall oracle protocol support

  3. #3
    Join Date
    Oct 2000
    Posts
    56
    pando, is that on the oracle cd? I can't seem to find it as one of the options.

  4. #4
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    I got exactly the same problem as your on one of my users machine. They installed some other application which creates another TNS name some have changes the existing. So next, time when ever I try to connect, it gives the same error. After playing around, I had to do clean reinstall of Client. Then it fixed the problem.

    I suggest the same for you.

    Thanks
    Kishore Kumar

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    it should be on the CD, under net8 client I believe there is an option that says Oracle protocol support

  6. #6
    Join Date
    Oct 2000
    Posts
    56
    hmm... well i looked and there aren't any other existing tnsnames files anywhere.... (trying to get out of a new install)

  7. #7
    Join Date
    Oct 2000
    Posts
    21
    it's definitely there on the 8.1.6 CD under net8 products.

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