| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> DB Links problem in Oracle 8.1.6.1
We seem to be having a problem with DB links on a specific machine running
on Sun OS 5.6. This machine has the same configuration as the rest of the
machines. The only difference is that it has got multiple multiple databases
and multiple ORACLE_HOMES, i.e;
Oracle 7.3.4 Oracle 8.1.5 Oracle 8.1.6
There are around 35 databases on this machine of which 26 are in Oracle 7.3.4 , 5 in Oracle 8.1.5 and 4 in Oracle 8.1.6.1. The DB links work in other machines without any problems.
In this machine the DB links work from Oracle 7.3.4 to all other versions, but from Oracle 8.1.5 and 8.1.6.1 they seem to work with Oracle 8 and Oracle 8i versions of 8.1.5 and 8.1.6.1 only. DB links to a lower version of Oracle 7.3.4 seems to give the following error:
SQL> select name from v$database_at_test7;
select name from v$database_at_test7 ---->> Db link name for 7.3.4 DB
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL> conn sys_at_rtk19 ----->>> Oracle 8.1.6.1 Database
Enter password: *******
ERROR: ORA-01041: internal error. hostdef extension doesn't exist
Connected.
SQL> conn sys_at_rg18
Enter password: *******
Connected.
SQL> select name from v$database_at_test8; --->DB link name for 8.1.5 DB
NAME
NAME
 |
 |