8i / Dev6i TNS error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: 8i / Dev6i TNS error

  1. #1
    Join Date
    Apr 2002
    Posts
    1

    Angry

    Fresh install
    Win98, 8i pers.edition (SID=ORCL) and 6i Dev
    c:\oracle\orapo c:\oracle\oradev

    edited C:\Oracle\Oradev\Net80\Admin\tnsnames.ora
    adding

    PO8 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = BEQ)
    (PROGRAM = oracle80)
    (ARGV0 = oracle80ORCL)
    (ARGS = '(DESCRIPTION=(LOCAL=YES)
    (ADDRESS=(PROTOCOL=beq)))'))
    (CONNECT_DATA = (SID = ORCL))
    )

    but I get ORA-12174: TNS can't resolve service name
    when I try system/manager with connect string "po8"
    on sqlplus, same problem with Form Builder


  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Find all of the tnsnames.ora files on your server and make sure they are the same.

    You can ignore the ones in "Sample" folders.

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

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