SQL*Plus
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: SQL*Plus

  1. #1
    Join Date
    Jan 2002
    Posts
    45
    Hi all:

    I installed 8.17 and 9.02 on the same box under different O-H. However, when I tried to connect to the 9i DB using 8i SQL*Plus, I get the "TNS.... error". I got the same error when trying to connect to the 8i DB using 9i SQL*Plus. How do I get around this problem. Any help/advice will be much appreciated.

    TIA

    John

  2. #2
    Join Date
    Jan 2002
    Posts
    45
    My bad:

    Both are installed on a W2K server with 512 RAM and with plenty of HD space.

    John

  3. #3
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Post your complete error message. check whether you have configured the listener and tnsnames..
    -nagarjuna

  4. #4
    Join Date
    Jan 2002
    Posts
    45
    Got it figured by adding a local net service name using 9i's Net Configuration Assistant. I can now connect to the 8i DB using 9i SQL*Plus.

    Thanks for all the help though.

    John

  5. #5
    Join Date
    Aug 2001
    Posts
    390
    which Listener did you use ???? Make sure you add the connect string of each database to both TNSnames.

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