|
|
|
|
Расширения стандартных решений
|
|
Инструментарий разработчика
|
|
Приложения RCO Fact Extractor SDK
|
|
Инструментарий аналитика
|
|
Архив продуктов (более не поддерживаются)
|
|
|
Форум
|
Дмитрий Макаров |
06.09.05, 10:28 |
|
| RPC connection |
|
Недавно засел за оракл, но надо срочно поднять поиск поэтому:
ошибка:
select rco_context.get_normal_form('дому','ctxsys.setting_no_stopwords') from dual
*
ошибка в строке 1:
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "CTXSYS.RCO_CONTEXT", line 4329
ORA-06512: at "CTXSYS.RCO_CONTEXT", line 293
ORA-06512: at line 1
# TNSNAMES.ORA Network Configuration File: /home/oracle/OraHome1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECTION_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
RCO_HIRES =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = RCO_HIRES)
)
)
# LISTENER.ORA Network Configuration File: /home/oracle/OraHome1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY=EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hires.fotobank.ru)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/OraHome1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ANY,LD_LIBRARY_PATH=/home/oracle/OraHome1/ctx/lib:home/oracle/OraHome1/lib:/home/oracle/RCO/lib,RCO_HOME=/home/oracle/RCO/")
)
(SID_DESC =
(GLOBAL_DBNAME = RCO_HIRES)
(ORACLE_HOME = /home/oracle/OraHome1)
(SID_NAME = rco)
)
)
и вот:
oracle@hires:/mnt/hd3/oracle/RCO/log$ tnsping rco_hires
TNS Ping Utility for Linux: Version 9.2.0.6.0 - Production on 06-SEP-2005 10:03:04
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = RCO_HIRES))
OK (0 msec) |
 |
|
Дмитрий Макаров |
06.09.05, 11:59 |
|
| немного не правильно написал |
|
на самом деле он такой!
# LISTENER.ORA Network Configuration File: /home/oracle/OraHome1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY=EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hires.fotobank.ru)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/OraHome1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ANY,LD_LIBRARY_PATH=/home/oracle/OraHome1/ctx/lib:home/oracle/OraHome1/lib:/home/oracle/RCO/lib,RCO_HOME=/home/oracle/RCO/")
)
(SID_DESC =
(GLOBAL_DBNAME = RCO_HIRES)
(ORACLE_HOME = /home/oracle/OraHome1)
(SID_NAME = rco_hires)
)
)
|
|
|
Алексей Дмитровский |
06.09.05, 12:33 |
|
| re: немного не правильно написал |
|
ORA-28575 вызывается обычно ошибкой в конфигурации механизма вызова внешних процедур Oracle.
Полезные рекомендации можно найти в Note:70638.1 на Metalink'е.
К работе RCO эта ошибка отношения не имеет. |
|
|
|
|
 |
|
| |
|