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

Thread: connecting from oracle 9i to 7.3.4

  1. #1
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159

    connecting from oracle 9i to 7.3.4

    Hi,
    I have connection issue connecting from 9i to 7.3.4.I checked metalink and they say its not supported.IS there any way i could connect from 9i sqlplus to 7.3.4 using sqlplus(9i).

    Thanks
    M.Suresh

  2. #2
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    Use Toad to connect to any version....

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by irehman
    Use Toad to connect to any version....
    And here I thought SQL*Plus was a product from Oracle... I didn't realize TOAD and SQL*Plus were the exact same thing
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    My point was, Toad has many more features then SQL*PLUS.

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by irehman
    My point was, Toad has many more features then SQL*PLUS.
    ... while on the other hand SQL*Plus has some features that TOAD doesn't and will never have....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by irehman
    My point was, Toad has many more features then SQL*PLUS.
    you are comapring oranges and apples, one is GUI, one is command line based how can you compare that

  7. #7
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159
    I have to do this through TNS connection and not with any other tool.

  8. #8
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: connecting from oracle 9i to 7.3.4

    Originally posted by msuresh
    Hi,
    I have connection issue connecting from 9i to 7.3.4.I checked metalink and they say its not supported.IS there any way i could connect from 9i sqlplus to 7.3.4 using sqlplus(9i).

    Thanks
    M.Suresh
    Are you getting any errors ??

    Show us your TNSNAMES.ORA file

    Ip address,sid,global_name and port number of the listener of the 7.3.4.1 server.

    May be we can have a look into it.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  9. #9
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    Re: connecting from oracle 9i to 7.3.4

    Originally posted by msuresh
    Hi,
    I have connection issue connecting from 9i to 7.3.4.I checked metalink and they say its not supported.IS there any way i could connect from 9i sqlplus to 7.3.4 using sqlplus(9i).

    Thanks
    M.Suresh
    It is not supported but it works. See below..
    Code:
    SQL*Plus: Release 9.0.1.0.1 - Production on Fri Mar 21 13:54:42 2003
    
    (c) Copyright 2001 Oracle Corporation.  All rights reserved.
    
    Connected to:
    Oracle7 Server Release 7.3.4.0.0 - Production
    With the distributed, replication and parallel query options
    PL/SQL Release 2.3.4.0.0 - Production
    
    SQL>
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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