can I access Oracle 8.1.6 database with either 8.0.5 or 7.3 client....
Printable View
can I access Oracle 8.1.6 database with either 8.0.5 or 7.3 client....
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
what entry ???
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.
Can you please tell me exactly which parameter....
i mena weather SID or SERVICE_NAME or something else ...
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)
)
)
thats the same I've rightnow ??
Post your TNSNAMES.ORA file