ORA-12560 TNS protocol adapter error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-12560 TNS protocol adapter error

  1. #1
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    hi

    i am trying to connect to an ora 8.1.6 database on NT but it is giving me this error

    ORA-12560 TNS protocol adapter error

    what is the way out ?

    satish

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Check for documentation on your tnsnames.ora/listener.ora/remote password file authentication.
    Problem is in either of these three.


  3. #3
    Join Date
    Aug 2000
    Posts
    68

    Post

    Hows it going

    Sounds like, its a problem with your tns names file,

    1. Make sure you can ping the server,
    2. And ensure, that the tnsnames file is configured correctly.

    XR01.WORLD =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Xr01)
    (PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = xr01)
    )
    )

    Hope this syntax helps.....
    Carpe Diem

  4. #4
    Join Date
    Aug 2000
    Posts
    68
    sorry forgot this

    3. Try putting the IP address in the host name. and try to see if that works.

    Carpe Diem

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