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

Thread: URGENT one !!!

  1. #1
    Join Date
    Jan 2000
    Posts
    27

    Red face

    can I access Oracle 8.1.6 database with either 8.0.5 or 7.3 client....

  2. #2
    Join Date
    Aug 2000
    Posts
    30
    You can do it.

    Please make an entry in the tnsnames.ora. that's enough.

    you can find tnsnames.ora in orant\network\admin folder

    bye from jee

  3. #3
    Join Date
    Jan 2000
    Posts
    27
    what entry ???

  4. #4
    Join Date
    Nov 2000
    Posts
    62
    Accessing to ORACLE8.1 with lower version of sqlplus(8.0) throuth SQL*NET(NET8) is not a problem if you put Instance Name in your tnsnames.ora file and your Listner Process is up.
    but, with a lower version of Developer, you might not use Higher version of database as I know.

  5. #5
    Join Date
    Jan 2000
    Posts
    27
    Can you please tell me exactly which parameter....
    i mena weather SID or SERVICE_NAME or something else ...

  6. #6
    Join Date
    Nov 2000
    Posts
    62
    For this case,
    sqlplus system/manager@TEST_DB

    (TEST_DB is Service Name is need to be set in the tnsnames.ora)

    the following is the example of the tnsnames.ora file.
    TEST_DB =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = 117.0.8.1)
    (Port = 1521)
    )
    )
    (CONNECT_DATA = (SID = TEST)
    )
    )

  7. #7
    Join Date
    Jan 2000
    Posts
    27
    thats the same I've rightnow ??

  8. #8
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    Post your TNSNAMES.ORA file
    _________________________
    Joe Ramsey
    Senior Database Administrator
    dbaDirect, Inc.
    (877)687-3227

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