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

Thread: SQL*Plus

  1. 09-30-2002, 08:01 PM #1
    vndba
    vndba is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 09-30-2002, 08:06 PM #2
    vndba
    vndba is offline Junior Member
    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
    Reply With Quote Reply With Quote
  3. 09-30-2002, 08:18 PM #3
    nagarjuna's Avatar
    nagarjuna
    nagarjuna is offline Oracle Apps DBA
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Post your complete error message. check whether you have configured the listener and tnsnames..
    -nagarjuna
    Reply With Quote Reply With Quote
  4. 09-30-2002, 08:52 PM #4
    vndba
    vndba is offline Junior Member
    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
    Reply With Quote Reply With Quote
  5. 09-30-2002, 09:34 PM #5
    mike73
    mike73 is offline Senior Member
    Join Date
    Aug 2001
    Posts
    390
    which Listener did you use ???? Make sure you add the connect string of each database to both TNSnames.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width