|
|
|
Избитая тема - Датабасе линк (HS=OK)
|
|||
|---|---|---|---|
|
#18+
----------------из инит.ora-------------- global_names = FALSE instance_name = P4D -------------из ...\hs\admin\initODBCREN.ora----------------- HS_FDS_CONNECT_INFO = ODBCREN HS_FDS_TRACE_LEVEL = 0 HS_FDS_TRACE_FILE_NAME = c:\hslog.txt ----------из листенера---------------- SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = P4D) (ORACLE_HOME = D:\oracle\ora81) (SID_NAME = P4D) ) (SID_DESC = (PROGRAM = extproc) (SID_NAME = PLSExtProc) (ORACLE_HOME = d:\oracle\ora81) ) (SID_DESC = (PROGRAM = hsodbc) (SID_NAME = ODBCREN) (ORACLE_HOME = d:\oracle\ora81) ) ) -----------из тнснамес--------------- ODBCREN = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Pentium4)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ODBCREN) ) (HS=OK) ) P4D = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = PENTIUM4)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = P4D) ) ) ------------ ODBC - источник под названием ODBCREN в system DSN проверял, нормально соединяется с БД Interbase. --------------------------- создаем Датабасе линк create public database link SQL2.WORLD connect to SYSDBA identified by "sysad" using 'ODBCREN'; ------------------------------------ Делаем запрос - select * from STDTRFS@SQL2.WORLD ----------------------------------------------------------------- Получаем сообщение ORA-02086:following severe error from SQL2.WORLD ORA-28511:lost RPC connection to heterogeneos remote agent using SID=(DESCRIPTION=(ADRESS_LIST=(ADRESS=(PROTOCOL=TCP)(HOST=Pentium4)(PORT=1251)))(CONNECT_DATA=(SERVICE_NAME=ODBCREN))) помогите или скажите, что с Interbase невозможно сделать Database link. Больно видеть обмен происходящий через таблицы Paradox. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 20.03.2003, 14:19 |
|
||
|
|

start [/forum/topic.php?fid=52&tid=1991399]: |
0ms |
get settings: |
10ms |
get forum list: |
15ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
147ms |
get topic data: |
10ms |
get forum data: |
2ms |
get page messages: |
26ms |
get tp. blocked users: |
1ms |
| others: | 237ms |
| total: | 454ms |

| 0 / 0 |
